explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W1mn

Settings
# exclusive inclusive rows x rows loops node
1. 50,765.718 213,012.713 ↓ 1,106.4 542,133 1

Gather (cost=9,227.05..60,220.6 rows=490 width=2,141) (actual time=1,630.035..213,012.713 rows=542,133 loops=1)

  • Buffers: shared hit=25977902 read=2373591 dirtied=10636 written=1413
2. 4,789.782 162,246.995 ↓ 941.2 271,066 2

Nested Loop (cost=8,227.05..59,171.6 rows=288 width=2,141) (actual time=2,741.606..162,246.995 rows=271,066 loops=2)

  • Buffers: shared hit=25977902 read=2373591 dirtied=10636 written=1413
3. 156,405.158 157,457.206 ↓ 941.2 271,066 2

Nested Loop (cost=8,226.63..58,946.13 rows=288 width=325) (actual time=2,741.198..157,457.206 rows=271,066 loops=2)

  • Buffers: shared hit=23825432 read=2357528 dirtied=10636 written=1413
4. 621.222 1,050.152 ↓ 30.9 82,210 2

Nested Loop (cost=8,226.07..14,180.97 rows=2,659 width=126) (actual time=129.407..1,050.152 rows=82,210 loops=2)

  • Buffers: shared hit=374924 read=25452 written=5
5. 103.157 428.917 ↓ 10.9 38,205 2

Hash Join (cost=8,225.65..12,437.93 rows=3,495 width=66) (actual time=129.338..428.917 rows=38,205 loops=2)

  • Buffers: shared hit=772 read=7982
6. 159.923 324.310 ↑ 1.2 82,212 2

Hash Join (cost=8,219.95..11,924.05 rows=96,721 width=74) (actual time=127.714..324.31 rows=82,212 loops=2)

  • Buffers: shared hit=703 read=7974
7. 37.694 37.694 ↑ 1.2 82,212 2

Seq Scan on fact_product_uom_conversion fpuc_product (cost=0..3,450.21 rows=96,721 width=60) (actual time=0.022..37.694 rows=82,212 loops=2)

  • Buffers: shared hit=701 read=1782
8. 44.666 126.693 ↑ 1.0 86,628 2

Hash (cost=7,094.43..7,094.43 rows=90,042 width=14) (actual time=126.692..126.693 rows=86,628 loops=2)

  • Buffers: shared hit=2 read=6192
9. 82.027 82.027 ↑ 1.0 86,628 2

Seq Scan on dim_product p (cost=0..7,094.43 rows=90,042 width=14) (actual time=0.025..82.027 rows=86,628 loops=2)

  • Buffers: shared hit=2 read=6192
10. 0.051 1.450 ↑ 1.0 108 2

Hash (cost=4.08..4.08 rows=108 width=9) (actual time=1.45..1.45 rows=108 loops=2)

  • Buffers: shared hit=4 read=2
11. 1.399 1.399 ↑ 1.0 108 2

Seq Scan on dim_uom u (cost=0..4.08 rows=108 width=9) (actual time=0.015..1.399 rows=108 loops=2)

  • Buffers: shared hit=4 read=2
12. 0.013 0.013 ↑ 1.0 2 76,410

Index Scan using product_uom_conversion_pkey on fact_product_uom_conversion fpuc (cost=0.42..0.48 rows=2 width=60) (actual time=0.009..0.013 rows=2 loops=76,410)

  • Index Cond: (fpuc.product_sk = p.product_sk)
  • Buffers: shared hit=374152 read=17470 written=5
13. 1.896 1.896 ↑ 3.0 8 164,420

Index Scan using fact_contract_product_sk_idx on fact_contract fc (cost=0.56..16.54 rows=24 width=215) (actual time=1.745..1.896 rows=8 loops=164,420)

  • Index Cond: (fc.product_sk = p.product_sk)
  • Filter: (fc.client_sk = 11)
  • Buffers: shared hit=23450508 read=2332076 dirtied=10636 written=1408
14. 0.007 0.007 ↑ 1.0 1 542,133

Index Scan using dim_contract_amend_version_contract_amend_version_sk_idx on dim_contract_amend_version amend (cost=0.42..0.47 rows=1 width=5) (actual time=0.007..0.007 rows=1 loops=542,133)

  • Index Cond: (amend.contract_amend_version_sk = fc.contract_amend_version_sk)
  • Buffers: shared hit=2152470 read=16063