explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yREx

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5,356.372 ↑ 1.0 1 1

Finalize Aggregate (cost=546,935.31..546,935.32 rows=1 width=8) (actual time=5,356.372..5,356.372 rows=1 loops=1)

2. 240.490 5,356.439 ↓ 1.5 3 1

Gather (cost=546,935.09..546,935.30 rows=2 width=8) (actual time=5,356.358..5,356.439 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 49.757 5,115.949 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=545,935.09..545,935.10 rows=1 width=8) (actual time=5,115.949..5,115.949 rows=1 loops=3)

4. 649.720 5,066.192 ↑ 1.2 724,438 3 / 3

Hash Join (cost=439,511.94..543,740.31 rows=877,911 width=0) (actual time=3,319.721..5,066.192 rows=724,438 loops=3)

  • Hash Cond: (d.gs_claim_product_id = p.row_id)
5. 777.162 3,333.250 ↑ 1.2 725,648 3 / 3

Hash Join (cost=283,470.07..364,526.60 rows=880,320 width=16) (actual time=2,233.333..3,333.250 rows=725,648 loops=3)

  • Hash Cond: (td.line_item_claim_item_id = d.line_item_claim_item_id)
6. 220.201 360.092 ↑ 1.2 725,649 3 / 3

Hash Join (cost=2,426.17..43,363.50 rows=880,320 width=9) (actual time=35.958..360.092 rows=725,649 loops=3)

  • Hash Cond: (td.transaction_id = t.transaction_id)
7. 112.684 112.684 ↑ 1.2 725,649 3 / 3

Parallel Seq Scan on import_afs_claim_transaction_detail td (cost=0.00..28,738.38 rows=905,535 width=17) (actual time=8.463..112.684 rows=725,649 loops=3)

  • Filter: current_ind
  • Rows Removed by Filter: 105,901
8. 10.218 27.207 ↑ 1.0 48,633 3 / 3

Hash (cost=1,818.26..1,818.26 rows=48,633 width=8) (actual time=27.207..27.207 rows=48,633 loops=3)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,412kB
9. 16.989 16.989 ↑ 1.0 48,633 3 / 3

Seq Scan on import_afs_claim_transaction t (cost=0.00..1,818.26 rows=48,633 width=8) (actual time=0.032..16.989 rows=48,633 loops=3)

  • Filter: current_ind
  • Rows Removed by Filter: 1,393
10. 601.759 2,195.996 ↑ 1.0 2,515,246 3 / 3

Hash (cost=232,348.51..232,348.51 rows=2,518,351 width=25) (actual time=2,195.996..2,195.996 rows=2,515,246 loops=3)

  • Buckets: 131,072 Batches: 32 Memory Usage: 5,450kB
11. 1,594.237 1,594.237 ↑ 1.0 2,515,246 3 / 3

Seq Scan on import_afs_claim_detail d (cost=0.00..232,348.51 rows=2,518,351 width=25) (actual time=0.029..1,594.237 rows=2,515,246 loops=3)

12. 478.507 1,083.222 ↑ 1.0 2,511,461 3 / 3

Hash (cost=112,385.61..112,385.61 rows=2,511,461 width=16) (actual time=1,083.222..1,083.222 rows=2,511,461 loops=3)

  • Buckets: 262,144 Batches: 32 Memory Usage: 5,727kB
13. 604.715 604.715 ↑ 1.0 2,511,461 3 / 3

Seq Scan on import_legacy_invoice_product p (cost=0.00..112,385.61 rows=2,511,461 width=16) (actual time=0.039..604.715 rows=2,511,461 loops=3)

Planning time : 4.342 ms
Execution time : 5,356.640 ms