explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9hJx

Settings
# exclusive inclusive rows x rows loops node
1. 17,566.193 574,199.770 ↑ 1.0 1 1

Aggregate (cost=2,808,588.41..2,808,588.44 rows=1 width=48) (actual time=574,199.769..574,199.770 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=20,084 read=1,047,852, temp read=7,704 written=7,698
  • I/O Timings: read=52,291.512
2. 4,541.854 556,633.577 ↑ 1.0 810,696 1

Hash Left Join (cost=117,722.61..2,796,251.12 rows=822,486 width=18) (actual time=29,235.643..556,633.577 rows=810,696 loops=1)

  • Output: hcs.id, rr.id, il.id
  • Hash Cond: (rr.il_id = il.id)
  • Buffers: shared hit=20,075 read=1,047,852, temp read=5,522 written=5,516
  • I/O Timings: read=52,291.512
3. 9,297.840 551,712.236 ↑ 1.0 810,696 1

Hash Left Join (cost=113,587.50..2,764,357.10 rows=822,486 width=18) (actual time=28,855.860..551,712.236 rows=810,696 loops=1)

  • Output: hcs.id, rr.id, rr.il_id
  • Hash Cond: (hcs.reimbursement_request_id = rr.id)
  • Buffers: shared hit=12,851 read=1,047,852, temp read=5,522 written=5,516
  • I/O Timings: read=52,291.512
4. 524,668.030 524,668.030 ↑ 1.0 810,696 1

Seq Scan on schema_rr_adm.health_care_service hcs (cost=0.00..2,610,092.70 rows=822,486 width=12) (actual time=4,586.356..524,668.030 rows=810,696 loops=1)

  • Output: hcs.id, hcs.reimbursement_request_id
  • Filter: ((hcs.modification_date < current_date) AND (hcs.modification_date > (current_date - 1)))
  • Rows Removed by Filter: 37,132,623
  • Buffers: shared hit=4,467 read=1,010,040
  • I/O Timings: read=48,346.557
5. 3,011.053 17,746.366 ↑ 1.0 981,834 1

Hash (cost=76,199.60..76,199.60 rows=1,000,120 width=12) (actual time=17,746.366..17,746.366 rows=981,834 loops=1)

  • Output: rr.id, rr.il_id
  • Buckets: 524,288 Batches: 4 Memory Usage: 14,975kB
  • Buffers: shared hit=8,384 read=37,812, temp written=2,970
  • I/O Timings: read=3,944.955
6. 14,735.313 14,735.313 ↑ 1.0 981,834 1

Seq Scan on schema_rr_adm.reimb_requests rr (cost=0.00..76,199.60 rows=1,000,120 width=12) (actual time=136.097..14,735.313 rows=981,834 loops=1)

  • Output: rr.id, rr.il_id
  • Buffers: shared hit=8,384 read=37,812
  • I/O Timings: read=3,944.955
7. 181.608 379.487 ↑ 1.0 42,665 1

Hash (cost=2,741.70..2,741.70 rows=42,874 width=6) (actual time=379.487..379.487 rows=42,665 loops=1)

  • Output: il.id
  • Buckets: 65,536 Batches: 1 Memory Usage: 2,118kB
  • Buffers: shared hit=7,224
8. 197.879 197.879 ↑ 1.0 42,665 1

Index Only Scan using constraint_invoice_list_id_pk on schema_rr_adm.invoice_list il (cost=0.29..2,741.70 rows=42,874 width=6) (actual time=0.066..197.879 rows=42,665 loops=1)

  • Output: il.id
  • Heap Fetches: 8,930
  • Buffers: shared hit=7,224
Planning time : 2.840 ms
Execution time : 574,200.199 ms