explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ub2a

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 3,212.614 ↑ 1.0 50 1

Limit (cost=0.86..3,292.25 rows=50 width=122) (actual time=514.200..3,212.614 rows=50 loops=1)

  • Buffers: shared hit=19,077 read=57
2. 0.491 3,212.566 ↑ 136.6 50 1

Nested Loop (cost=0.86..449,539.44 rows=6,829 width=122) (actual time=514.196..3,212.566 rows=50 loops=1)

  • Buffers: shared hit=19,077 read=57
3. 2,687.275 2,687.275 ↑ 136.6 50 1

Index Scan Backward using liste_patient_madate_idx on liste_patient lp (cost=0.44..439,500.18 rows=6,829 width=12) (actual time=481.392..2,687.275 rows=50 loops=1)

  • Filter: (qui = 17)
  • Rows Removed by Filter: 1,736,156
  • Buffers: shared hit=18,934
4. 524.800 524.800 ↑ 1.0 1 50

Index Scan using patient_pkey on patient p (cost=0.42..1.47 rows=1 width=114) (actual time=10.496..10.496 rows=1 loops=50)

  • Index Cond: (id = lp.patient_id)
  • Buffers: shared hit=143 read=57
Planning time : 285.401 ms
Execution time : 3,212.739 ms