explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o4w8

Settings
# exclusive inclusive rows x rows loops node
1. 6,714.578 49,579.335 ↓ 732.0 10,575,286 1

Gather (cost=21,036.71..342,310.63 rows=14,447 width=2,144) (actual time=8,325.933..49,579.335 rows=10,575,286 loops=1)

  • Buffers: shared hit=9634 read=240230, temp read=224159 written=224228
2. 26,979.393 42,864.757 ↓ 585.6 3,525,095 3

Hash Join (cost=20,036.71..339,865.93 rows=6,020 width=2,144) (actual time=8,194.969..42,864.757 rows=3,525,095 loops=3)

  • Buffers: shared hit=9634 read=240230, temp read=224159 written=224228
3. 12,658.592 15,832.183 ↓ 585.6 3,525,095 3

Hash Join (cost=15,468.49..333,368.8 rows=6,020 width=439) (actual time=8,140.299..15,832.183 rows=3,525,095 loops=3)

  • Buffers: shared hit=6426 read=240230, temp read=224159 written=224228
4. 2,777.730 2,777.730 ↑ 1.3 3,525,471 3

Seq Scan on fact_contract fc (cost=0..284,812.23 rows=4,407,023 width=219) (actual time=0.053..2,777.73 rows=3,525,471 loops=3)

  • Buffers: shared hit=512 read=240230
5. 142.028 395.861 ↓ 15.7 54,443 3

Hash (cost=15,416.49..15,416.49 rows=3,467 width=236) (actual time=395.861..395.861 rows=54,443 loops=3)

  • Buffers: shared hit=5914, temp written=1444
6. 63.864 253.833 ↓ 15.7 54,443 3

Hash Join (cost=12,791..15,416.49 rows=3,467 width=236) (actual time=184.008..253.833 rows=54,443 loops=3)

  • Buffers: shared hit=5914
7. 8.260 8.260 ↑ 1.8 54,445 3

Seq Scan on fact_product_uom_conversion fpuc (cost=0..2,244.8 rows=96,080 width=115) (actual time=0.013..8.26 rows=54,445 loops=3)

  • Buffers: shared hit=1284
8. 20.780 181.709 ↓ 7.0 25,300 3

Hash (cost=12,745.65..12,745.65 rows=3,628 width=121) (actual time=181.709..181.709 rows=25,300 loops=3)

  • Buffers: shared hit=4630
9. 24.131 160.929 ↓ 7.0 25,300 3

Hash Join (cost=5,257.34..12,745.65 rows=3,628 width=121) (actual time=59.656..160.929 rows=25,300 loops=3)

  • Buffers: shared hit=4630
10. 54.614 136.546 ↑ 1.8 54,445 3

Hash Join (cost=5,252.59..11,984.02 rows=96,080 width=129) (actual time=59.352..136.546 rows=54,445 loops=3)

  • Buffers: shared hit=4586
11. 23.771 23.771 ↑ 1.8 54,445 3

Seq Scan on fact_product_uom_conversion fpuc_product (cost=0..2,244.8 rows=96,080 width=115) (actual time=0.023..23.771 rows=54,445 loops=3)

  • Buffers: shared hit=1284
12. 8.312 58.161 ↑ 1.2 56,981 3

Hash (cost=4,014.26..4,014.26 rows=71,226 width=14) (actual time=58.16..58.161 rows=56,981 loops=3)

  • Buffers: shared hit=3302
13. 49.849 49.849 ↓ 1.2 85,472 2

Seq Scan on dim_product p (cost=0..4,014.26 rows=71,226 width=14) (actual time=0.021..49.849 rows=85,472 loops=2)

  • Buffers: shared hit=3302
14. 0.044 0.252 ↑ 1.0 110 3

Hash (cost=3.1..3.1 rows=110 width=9) (actual time=0.252..0.252 rows=110 loops=3)

  • Buffers: shared hit=6
15. 0.208 0.208 ↑ 1.0 110 3

Seq Scan on dim_uom u (cost=0..3.1 rows=110 width=9) (actual time=0.181..0.208 rows=110 loops=3)

  • Buffers: shared hit=6
16. 7.237 53.181 ↑ 1.2 52,915 3

Hash (cost=3,741.43..3,741.43 rows=66,143 width=5) (actual time=53.181..53.181 rows=52,915 loops=3)

  • Buffers: shared hit=3080
17. 45.944 45.944 ↓ 1.2 79,372 2

Seq Scan on dim_contract_amend_version amend (cost=0..3,741.43 rows=66,143 width=5) (actual time=0.038..45.944 rows=79,372 loops=2)

  • Buffers: shared hit=3080