explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O2jb

Settings
# exclusive inclusive rows x rows loops node
1. 3,708.257 5,139.921 ↑ 120.0 19,639,061 1

Nested Loop (cost=5,625.85..29,467,654.94 rows=2,356,513,523 width=126) (actual time=73.545..5,139.921 rows=19,639,061 loops=1)

  • Output: tmp_lumpsum_payments.contract_amend_version_id, tmp_lumpsum_payments.company_id, x.contractee_company_id, x.contractee_grouping_id, tmp_lumpsum_payments.product_id, tmp_lumpsum_payments.lumpsum_id, tmp_lumpsum_payments.contract_lumpsum_id, tmp_lumpsum_payments.date_range
  • Buffers: local read=7159
2. 41.288 41.288 ↑ 1.0 173,797 1

Seq Scan on pg_temp_42.tmp_lumpsum_payments (cost=0.00..5,304.97 rows=173,797 width=94) (actual time=0.018..41.288 rows=173,797 loops=1)

  • Output: tmp_lumpsum_payments.contract_amend_version_id, tmp_lumpsum_payments.contract_renew_version_id, tmp_lumpsum_payments.company_id, tmp_lumpsum_payments.product_id, tmp_lumpsum_payments.lumpsum_id, tmp_lumpsum_payments.contract_lumpsum_id, tmp_lumpsum_payments.date_range, tmp_lumpsum_payments.delivery_month_actual_claim_dollars_direct, tmp_lumpsum_payments.delivery_month_actual_claim_dollars_deviated, tmp_lumpsum_payments.delivery_month_actual_claim_dollars_total, tmp_lumpsum_payments.received_month_actual_claim_dollars_direct, tmp_lumpsum_payments.received_month_actual_claim_dollars_deviated, tmp_lumpsum_payments.received_month_actual_claim_dollars_total, tmp_lumpsum_payments.processed_month_actual_claim_dollars_direct, tmp_lumpsum_payments.processed_month_actual_claim_dollars_deviated, tmp_lumpsum_payments.processed_month_actual_claim_dollars_total, tmp_lumpsum_payments.deduction_match_month_actual_claim_dollars_direct, tmp_lumpsum_payments.deduction_match_month_actual_claim_dollars_deviated, tmp_lumpsum_payments.deduction_match_month_actual_claim_dollars_total
  • Buffers: local read=3567
3. 1,316.747 1,390.376 ↑ 120.0 113 173,797

Materialize (cost=5,625.85..5,964.82 rows=13,559 width=32) (actual time=0.000..0.008 rows=113 loops=173,797)

  • Output: x.contractee_company_id, x.contractee_grouping_id
  • Buffers: local read=3592
4. 0.017 73.629 ↑ 120.0 113 1

Subquery Scan on x (cost=5,625.85..5,897.03 rows=13,559 width=32) (actual time=73.518..73.629 rows=113 loops=1)

  • Output: x.contractee_company_id, x.contractee_grouping_id
  • Buffers: local read=3592
5. 43.944 73.612 ↑ 120.0 113 1

HashAggregate (cost=5,625.85..5,761.44 rows=13,559 width=32) (actual time=73.516..73.612 rows=113 loops=1)

  • Output: tmp_pfl.contractee_grouping_id, tmp_pfl.contractee_company_id
  • Group Key: tmp_pfl.contractee_grouping_id, tmp_pfl.contractee_company_id
  • Buffers: local read=3592
6. 29.668 29.668 ↑ 1.0 135,590 1

Seq Scan on pg_temp_42.tmp_pfl (cost=0.00..4,947.90 rows=135,590 width=32) (actual time=0.011..29.668 rows=135,590 loops=1)

  • Output: tmp_pfl.contract_amend_version_id, tmp_pfl.contract_renew_version_id, tmp_pfl.contract_family_id, tmp_pfl.contract_template_id, tmp_pfl.contractee_company_id, tmp_pfl.contractee_grouping_id, tmp_pfl.accrual_company_id, tmp_pfl.contract_item_id, tmp_pfl.lumpsum_id, tmp_pfl.contract_lumpsum_id, tmp_pfl.product_id, tmp_pfl.sale_id, tmp_pfl.sale_earning_id, tmp_pfl.date_range, tmp_pfl.accrued_quantity_uom_type_id, tmp_pfl.accrued_quantity, tmp_pfl.accrued_amount_direct, tmp_pfl.accrued_amount_deviated, tmp_pfl.accrued_amount_lumpsum, tmp_pfl.actual_gross_sales_dollars
  • Buffers: local read=3592