explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i2UD

Settings
# exclusive inclusive rows x rows loops node
1. 1,642.919 27,081.199 ↑ 1,095.7 3,413 1

Nested Loop (cost=176.07..5,998,134.37 rows=3,739,650 width=3,574) (actual time=20,741.662..27,081.199 rows=3,413 loops=1)

  • Buffers: shared hit=14263038
2. 707.820 25,390.498 ↑ 1,095.7 3,413 1

Merge Join (cost=175.64..2,364,424.86 rows=3,739,650 width=2,010) (actual time=20,724.196..25,390.498 rows=3,413 loops=1)

  • Merge Cond: (events.event_key = status.event_key)
  • Buffers: shared hit=14105738
3. 11,418.376 11,418.376 ↓ 1.0 7,900,954 1

Index Scan using events_pkey on events (cost=0.43..1,057,547.11 rows=7,883,556 width=1,912) (actual time=0.015..11,418.376 rows=7,900,954 loops=1)

  • Filter: ((deleted)::text = 'N'::text)
  • Rows Removed by Filter: 2488
  • Buffers: shared hit=6586396
4. 13,264.302 13,264.302 ↑ 986.5 3,791 1

Index Scan using status_idx09 on status (cost=0.44..1,240,803.02 rows=3,739,899 width=98) (actual time=1,836.521..13,264.302 rows=3,791 loops=1)

  • Index Cond: ((status_current)::text = 'Y'::text)
  • Filter: (((status_type)::text <> 'RJ'::text) AND ((status_category)::text = 'R'::text))
  • Rows Removed by Filter: 9583265
  • Buffers: shared hit=7519342
5. 47.782 47.782 ↑ 1.0 1 3,413

Index Scan using patient_pkey on patient (cost=0.43..0.46 rows=1 width=1,564) (actual time=0.013..0.014 rows=1 loops=3,413)

  • Index Cond: (computer_number = events.computer_number)
  • Buffers: shared hit=13674
Planning time : 7.909 ms
Execution time : 27,082.182 ms