explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LCCN

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 70.067 ↑ 1.0 50 1

Limit (cost=23,525.65..23,531.48 rows=50 width=120) (actual time=57.806..70.067 rows=50 loops=1)

  • Buffers: shared hit=1,349 read=816
2. 34.925 70.060 ↑ 78.4 50 1

Gather Merge (cost=23,525.65..23,983.01 rows=3,920 width=120) (actual time=57.804..70.060 rows=50 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1,349 read=816
3. 0.265 35.135 ↑ 30.2 65 3 / 3

Sort (cost=22,525.63..22,530.53 rows=1,960 width=120) (actual time=35.131..35.135 rows=65 loops=3)

  • Sort Key: lp.madate DESC
  • Sort Method: quicksort Memory: 85kB
  • Buffers: shared hit=1,349 read=816
4. 0.432 34.870 ↑ 13.6 144 3 / 3

Nested Loop (cost=89.31..22,418.45 rows=1,960 width=120) (actual time=3.093..34.870 rows=144 loops=3)

  • Buffers: shared hit=1,335 read=816
5. 12.280 12.701 ↑ 12.3 159 3 / 3

Parallel Bitmap Heap Scan on liste_patient lp (cost=88.89..13,625.95 rows=1,960 width=12) (actual time=2.382..12.701 rows=159 loops=3)

  • Recheck Cond: (qui = 17)
  • Heap Blocks: exact=158
  • Buffers: shared hit=44 read=244
6. 0.421 0.421 ↑ 9.9 476 1 / 3

Bitmap Index Scan on liste_patient_qui_idx (cost=0.00..87.71 rows=4,704 width=0) (actual time=1.263..1.263 rows=476 loops=1)

  • Index Cond: (qui = 17)
  • Buffers: shared hit=1 read=4
7. 21.737 21.737 ↑ 1.0 1 476 / 3

Index Scan using patient_pkey on patient p (cost=0.42..4.49 rows=1 width=112) (actual time=0.137..0.137 rows=1 loops=476)

  • Index Cond: (id = lp.patient_id)
  • Buffers: shared hit=1,291 read=572
Planning time : 4.129 ms
Execution time : 70.327 ms