explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jyWK

Settings
# exclusive inclusive rows x rows loops node
1. 860.568 5,436.160 ↑ 1.0 1 1

Aggregate (cost=257,121.36..257,121.39 rows=1 width=48) (actual time=5,436.159..5,436.160 rows=1 loops=1)

  • Output: count(hcs.id), (count(hcs.id) / 24), count(DISTINCT rr.id), (count(DISTINCT rr.id) / 24), count(DISTINCT il.id), (count(DISTINCT il.id) / 24)
  • Buffers: shared hit=47622 read=65706, temp read=6453 written=6447
  • I/O Timings: read=2941.454
2. 229.726 4,575.592 ↓ 1.1 596,355 1

Hash Left Join (cost=117,260.57..248,866.14 rows=550,348 width=18) (actual time=1,308.029..4,575.592 rows=596,355 loops=1)

  • Output: hcs.id, rr.id, il.id
  • Hash Cond: (rr.il_id = il.id)
  • Buffers: shared hit=47622 read=65706, temp read=4849 written=4843
  • I/O Timings: read=2941.454
3. 484.820 4,285.195 ↓ 1.1 596,355 1

Hash Left Join (cost=112,865.45..225,896.77 rows=550,348 width=18) (actual time=1,247.267..4,285.195 rows=596,355 loops=1)

  • Output: hcs.id, rr.id, rr.il_id
  • Hash Cond: (hcs.reimbursement_request_id = rr.id)
  • Buffers: shared hit=47620 read=63982, temp read=4849 written=4843
  • I/O Timings: read=2900.228
4. 2,575.689 2,575.689 ↓ 1.1 596,355 1

Index Only Scan using idx_hcs_moddate on schema_rr_adm.health_care_service hcs (cost=0.57..84,283.65 rows=550,348 width=12) (actual time=0.301..2,575.689 rows=596,355 loops=1)

  • Output: hcs.id, hcs.reimbursement_request_id
  • Index Cond: ((hcs.modification_date < current_date) AND (hcs.modification_date > (current_date - 1)))
  • Heap Fetches: 596355
  • Buffers: shared hit=47617 read=17322
  • I/O Timings: read=2343.445
5. 301.909 1,224.686 ↓ 1.0 982,463 1

Hash (cost=76,136.86..76,136.86 rows=982,462 width=12) (actual time=1,224.686..1,224.686 rows=982,463 loops=1)

  • Output: rr.id, rr.il_id
  • Buckets: 524288 Batches: 4 Memory Usage: 14981kB
  • Buffers: shared hit=3 read=46660, temp written=2971
  • I/O Timings: read=556.783
6. 922.777 922.777 ↓ 1.0 982,463 1

Seq Scan on schema_rr_adm.reimb_requests rr (cost=0.00..76,136.86 rows=982,462 width=12) (actual time=0.401..922.777 rows=982,463 loops=1)

  • Output: rr.id, rr.il_id
  • Buffers: shared hit=3 read=46660
  • I/O Timings: read=556.783
7. 10.479 60.671 ↑ 1.0 42,706 1

Hash (cost=3,007.18..3,007.18 rows=42,706 width=6) (actual time=60.671..60.671 rows=42,706 loops=1)

  • Output: il.id
  • Buckets: 65536 Batches: 1 Memory Usage: 2119kB
  • Buffers: shared hit=2 read=1724
  • I/O Timings: read=41.226
8. 50.192 50.192 ↑ 1.0 42,706 1

Seq Scan on schema_rr_adm.invoice_list il (cost=0.00..3,007.18 rows=42,706 width=6) (actual time=0.512..50.192 rows=42,706 loops=1)

  • Output: il.id
  • Buffers: shared hit=2 read=1724
  • I/O Timings: read=41.226
Planning time : 27.358 ms
Execution time : 5,438.008 ms