explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nSod

Settings
# exclusive inclusive rows x rows loops node
1. 180,511.726 200,098.807 ↓ 0.0 0 1

Insert on public.fact_accrual (cost=0.00..844,774.66 rows=11,129,444 width=136) (actual time=200,098.807..200,098.807 rows=0 loops=1)

  • Buffers: shared hit=111316355 read=116315 dirtied=236241 written=178255, local read=677833 dirtied=475666 written=475665
  • I/O Timings: read=12730.281 write=886.545
  • Functions: 2
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 1.528 ms, Inlining 9.873 ms, Optimization 119.753 ms, Emission 76.695 ms, Total 207.849 ms
2. 19,587.081 19,587.081 ↑ 3.1 3,574,274 1

Seq Scan on pg_temp_7.tmp_fact_accrual tfa (cost=0.00..844,774.66 rows=11,129,444 width=136) (actual time=210.422..19,587.081 rows=3,574,274 loops=1)

  • Output: nextval('fact_accrual_accrual_sk_seq'::regclass), 24, tfa.contract_family_sk, tfa.contract_renew_version_sk, tfa.contract_amend_version_sk, tfa.product_sk, tfa.lumpsum_sk, tfa.accrual_company_sk, tfa.accrual_date, tfa.uom_sk, tfa.accrued_quantity, tfa.accrued_amount_direct, tfa.accrued_amount_deviated, tfa.accrued_amount_lumpsum, 4255, tfa.contract_sk, tfa.accrued_quantity_delta, tfa.accrued_amount_direct_delta, tfa.accrued_amount_deviated_delta, tfa.accrued_amount_lumpsum_delta
  • Buffers: shared hit=3574283 read=2 dirtied=1, local read=677833 dirtied=475666 written=475665
  • I/O Timings: read=2983.415
Execution time : 201,109.152 ms