DiscoverPostgres FMpg_stat_statements track_planning
pg_stat_statements track_planning

pg_stat_statements track_planning

Update: 2024-11-29
Share

Description

Nikolay and Michael discuss the track_planning parameter of pg_stat_statements — what it is, how it affects performance, and when or whether you should switch it on.
 
Here are some links to things they mentioned:


~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!


~~~

Postgres FM is produced by:


With special thanks to:

  • Jessie Draws for the elephant artwork 
Comments 
In Channel
GIN Indexes

GIN Indexes

2025-03-1440:59

Best Practices

Best Practices

2025-03-0740:49

Extended Statistics

Extended Statistics

2025-02-2832:41

SQL vs NoSQL

SQL vs NoSQL

2025-02-1450:01

Return of the BUFFERS

Return of the BUFFERS

2025-02-0751:46

Reads causing writes

Reads causing writes

2025-01-2426:48

NOT VALID constraints

NOT VALID constraints

2025-01-1733:56

pg_squeeze

pg_squeeze

2025-01-1036:26

pg_duckdb

pg_duckdb

2025-01-0340:08

RLS vs performance

RLS vs performance

2024-12-2040:48

jOOQ

jOOQ

2024-12-1350:31

Column Tetris

Column Tetris

2024-12-0641:06

Append-only tables

Append-only tables

2024-11-1544:07

Denormalization

Denormalization

2024-11-0835:08

Advanced psql

Advanced psql

2024-10-2552:37

Postgres Gotchas

Postgres Gotchas

2024-10-1840:19

Advanced EXPLAIN

Advanced EXPLAIN

2024-10-1148:47

loading
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

pg_stat_statements track_planning

pg_stat_statements track_planning

Nikolay Samokhvalov and Michael Christofides