explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hZk3

Settings
# exclusive inclusive rows x rows loops node
1. 7.910 580.394 ↑ 1.6 878 1

Gather (cost=258,306.98..291,645.06 rows=1,430 width=274) (actual time=554.371..580.394 rows=878 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 1.395 572.484 ↑ 1.9 439 2 / 2

Hash Join (cost=257,306.98..290,502.06 rows=841 width=274) (actual time=552.433..572.484 rows=439 loops=2)

  • Hash Cond: (si.originatordivision_id = od_db.id)
3. 3.458 571.072 ↑ 3.0 3,883 2 / 2

Nested Loop (cost=257,305.79..290,460.60 rows=11,776 width=274) (actual time=465.680..571.072 rows=3,883 loops=2)

4. 60.535 559.848 ↑ 3.0 3,883 2 / 2

Parallel Hash Join (cost=257,305.36..260,601.47 rows=11,776 width=8) (actual time=465.654..559.848 rows=3,883 loops=2)

  • Hash Cond: (ps_ddeps.id = ps_eps.id)
5. 35.203 35.203 ↑ 1.2 128,400 2 / 2

Parallel Seq Scan on ddearlypaymentsettlement ps_ddeps (cost=0.00..2,899.58 rows=151,058 width=8) (actual time=0.008..35.203 rows=128,400 loops=2)

6. 115.125 464.110 ↓ 2.0 248,777 2 / 2

Parallel Hash (cost=255,754.03..255,754.03 rows=124,106 width=16) (actual time=464.110..464.110 rows=248,777 loops=2)

  • Buckets: 524288 Batches: 1 Memory Usage: 27488kB
7. 321.836 348.985 ↓ 2.0 248,777 2 / 2

Parallel Bitmap Heap Scan on earlypaymentsettlement ps_eps (cost=9,295.71..255,754.03 rows=124,106 width=16) (actual time=101.363..348.985 rows=248,777 loops=2)

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=94270
8. 27.149 27.149 ↓ 1.0 497,554 1 / 2

Bitmap Index Scan on earlypaymentsettlement_creationdate_idx (cost=0.00..9,171.61 rows=496,423 width=0) (actual time=54.298..54.298 rows=497,554 loops=1)

  • Index Cond: (creationdate >= '2019-02-01'::date)
9. 7.766 7.766 ↑ 1.0 1 7,766 / 2

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..2.54 rows=1 width=274) (actual time=0.002..0.002 rows=1 loops=7,766)

  • Index Cond: (id = ps_eps.invoice_id)
10. 0.003 0.017 ↑ 1.0 1 2 / 2

Hash (cost=1.18..1.18 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.014 0.014 ↑ 1.0 1 2 / 2

Seq Scan on divisionbase od_db (cost=0.00..1.18 rows=1 width=8) (actual time=0.012..0.014 rows=1 loops=2)

  • Filter: (buyer_id = 66895525)
  • Rows Removed by Filter: 13
Planning time : 0.652 ms
Execution time : 580.664 ms