explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OdUR

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 6,076.832 ↓ 3.0 3 1

Sort (cost=1,148.49..1,148.49 rows=1 width=3,647) (actual time=6,076.829..6,076.832 rows=3 loops=1)

  • Sort Key: events.event_key
  • Sort Method: quicksort Memory: 28kB
  • Buffers: shared hit=1161 read=1566
2. 194.940 6,076.760 ↓ 3.0 3 1

Nested Loop (cost=2.15..1,148.48 rows=1 width=3,647) (actual time=5,400.287..6,076.760 rows=3 loops=1)

  • Buffers: shared hit=1161 read=1566
3. 1.036 5,879.154 ↓ 86.0 86 1

Nested Loop (cost=1.87..1,145.05 rows=1 width=3,651) (actual time=1,218.114..5,879.154 rows=86 loops=1)

  • Buffers: shared hit=811 read=1536
4. 1.212 4,734.576 ↓ 86.0 86 1

Nested Loop (cost=1.44..1,141.94 rows=1 width=2,155) (actual time=1,201.407..4,734.576 rows=86 loops=1)

  • Buffers: shared hit=626 read=1376
5. 1.054 4,676.346 ↓ 86.0 86 1

Nested Loop (cost=1.00..1,138.79 rows=1 width=105) (actual time=1,201.292..4,676.346 rows=86 loops=1)

  • Buffers: shared hit=357 read=1301
6. 3,945.840 3,945.840 ↓ 86.0 86 1

Index Scan using status_idx05 on status (cost=0.57..1,134.32 rows=1 width=95) (actual time=1,192.987..3,945.840 rows=86 loops=1)

  • Index Cond: (((status_category)::text = 'AP'::text) AND ((status_current)::text = 'Y'::text) AND (start_date = '2019-02-05 00:00:00'::timestamp without time zone))
  • Filter: (((site)::text = 'RVY01'::text) AND ((((site)::text || (status_category)::text) || (status_current)::text) = 'RVY01APY'::text))
  • Rows Removed by Filter: 2084
  • Buffers: shared hit=133 read=1180
7. 729.452 729.452 ↑ 1.0 1 86

Index Scan using exams_pkey on exams (cost=0.44..4.46 rows=1 width=14) (actual time=8.480..8.482 rows=1 loops=86)

  • Index Cond: (exam_key = status.exam_key)
  • Buffers: shared hit=224 read=121
8. 57.018 57.018 ↑ 1.0 1 86

Index Scan using events_pkey on events (cost=0.44..3.14 rows=1 width=2,054) (actual time=0.661..0.663 rows=1 loops=86)

  • Index Cond: (event_key = exams.event_key)
  • Filter: ((deleted)::text = 'N'::text)
  • Buffers: shared hit=269 read=75
9. 1,143.542 1,143.542 ↑ 1.0 1 86

Index Scan using patient_pkey on patient (cost=0.43..3.11 rows=1 width=1,496) (actual time=13.296..13.297 rows=1 loops=86)

  • Index Cond: (computer_number = events.computer_number)
  • Buffers: shared hit=185 read=160
10. 2.666 2.666 ↓ 0.0 0 86

Index Scan using examcd_pkey on examcd (cost=0.28..2.92 rows=1 width=8) (actual time=0.031..0.031 rows=0 loops=86)

  • Index Cond: ((code)::text = (exams.examination)::text)
  • Filter: ((modality)::text = 'R'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=255 read=3