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
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

Patroni

Patroni

2024-10-0445:33

Postgres 17

Postgres 17

2024-09-2742:03

Planning time

Planning time

2024-09-2042:17

Slow count

Slow count

2024-09-1343:25

Skip scan

Skip scan

2024-09-0657:49

Get or Create

Get or Create

2024-08-2350:19

Index-Only Scans

Index-Only Scans

2024-08-0939:15

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