explain.depesz.com

PostgreSQL's explain analyze made readable

Result: puDT

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.013 ↓ 0.0 0 1

Update on pg_temp_7.tmp_fact_accrual pf (cost=0.00..0.00 rows=0 width=0) (actual time=0.013..0.013 rows=0 loops=1)

2. 0.012 0.012 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=684) (actual time=0.011..0.012 rows=0 loops=1)

  • Output: pf.contract_amend_version_id, pf.contract_renew_version_id, pf.contract_family_id, pf.contract_template_id, pf.contractee_company_id, pf.contractee_grouping_id, pf.accrual_company_id, pf.contract_item_id, pf.lumpsum_id, pf.contract_lumpsum_id, pf.product_id, pf.accrued_quantity, pf.accrued_quantity_uom_type_id, pf.accrued_amount_direct, pf.accrued_amount_deviated, pf.accrued_amount_lumpsum, pf.accrual_date, pf.row_id, pf.accrual_run_sk, pf.contract_family_sk, pf.contract_renew_version_sk, pf.contract_amend_version_sk, pf.contract_sk, pf.product_sk, pf.lumpsum_sk, pf.accrual_company_sk, pf.uom_sk, (pf.accrued_quantity - accrued_quantity), (pf.accrued_amount_direct - accrued_amount_direct), (pf.accrued_amount_deviated - accrued_amount_deviated), (pf.accrued_amount_lumpsum - accrued_amount_lumpsum), pf.ctid, ctid
  • One-Time Filter: false
Planning time : 0.234 ms
Execution time : 0.074 ms