explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6ZOUA

Settings
# exclusive inclusive rows x rows loops node
1. 3,818.376 24,408.687 ↑ 1.0 1 1

Aggregate (cost=1,846,662.88..1,846,662.92 rows=1 width=72) (actual time=24,408.687..24,408.687 rows=1 loops=1)

  • Buffers: shared hit=45,329 read=595,288, temp read=13,707 written=13,701
  • I/O Timings: read=2,382.006
2. 1,304.072 20,590.311 ↓ 1.0 1,967,559 1

Hash Left Join (cost=116,560.19..1,802,672.09 rows=1,955,146 width=18) (actual time=1,257.957..20,590.311 rows=1,967,559 loops=1)

  • Hash Cond: (hcs.reimbursement_request_id = rr.id)
  • Buffers: shared hit=45,320 read=595,288, temp read=8,413 written=8,407
  • I/O Timings: read=2,382.006
3. 18,200.480 18,200.480 ↓ 1.0 1,967,559 1

Seq Scan on health_care_service hcs (cost=0.00..1,597,287.72 rows=1,955,146 width=12) (actual time=169.984..18,200.480 rows=1,967,559 loops=1)

  • Filter: ((modification_date < current_date) AND (modification_date > (current_date - 7)))
  • Rows Removed by Filter: 21,405,124
  • Buffers: shared hit=44,198 read=559,730
  • I/O Timings: read=2,250.144
4. 293.547 1,085.759 ↓ 1.0 766,608 1

Hash (cost=87,902.54..87,902.54 rows=766,574 width=12) (actual time=1,085.759..1,085.759 rows=766,608 loops=1)

  • Buckets: 524,288 Batches: 4 Memory Usage: 12,548kB
  • Buffers: shared hit=1,122 read=35,558, temp written=2,300
  • I/O Timings: read=131.862
5. 543.873 792.212 ↓ 1.0 766,608 1

Hash Left Join (cost=2,533.44..87,902.54 rows=766,574 width=12) (actual time=19.603..792.212 rows=766,608 loops=1)

  • Hash Cond: (rr.il_id = il.id)
  • Buffers: shared hit=1,122 read=35,558
  • I/O Timings: read=131.862
6. 228.929 228.929 ↓ 1.0 766,608 1

Seq Scan on reimb_requests rr (cost=0.00..59,497.22 rows=766,574 width=11) (actual time=0.022..228.929 rows=766,608 loops=1)

  • Buffers: shared hit=1,104 read=35,396
  • I/O Timings: read=123.153
7. 6.709 19.410 ↓ 1.0 28,870 1

Hash (cost=1,595.20..1,595.20 rows=28,869 width=6) (actual time=19.410..19.410 rows=28,870 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,337kB
  • Buffers: shared hit=18 read=162
  • I/O Timings: read=8.709
8. 12.701 12.701 ↓ 1.0 28,870 1

Index Only Scan using constraint_invoice_list_id_pk on invoice_list il (cost=0.29..1,595.20 rows=28,869 width=6) (actual time=0.068..12.701 rows=28,870 loops=1)

  • Heap Fetches: 79
  • Buffers: shared hit=18 read=162
  • I/O Timings: read=8.709
Planning time : 2.698 ms
Execution time : 24,411.248 ms