explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dwt4

Settings
# exclusive inclusive rows x rows loops node
1. 379.860 8,219.866 ↑ 1.0 2,073,229 1

Gather (cost=1,507,969.96..2,113,530.28 rows=2,132,144 width=8) (actual time=6,225.183..8,219.866 rows=2,073,229 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 174
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 24.224 ms, Inlining 128.297 ms, Optimization 1614.156 ms, Emission 1044.442 ms, Total 2811.119 ms"Execution Time: 8,313.843 ms
2. 282.617 7,840.006 ↑ 1.3 691,076 3 / 3

Parallel Hash Semi Join (cost=1,506,969.96..1,899,315.88 rows=888,393 width=8) (actual time=6,200.668..7,840.006 rows=691,076 loops=3)

  • Hash Cond: (f.dim_repair_order_id = fll5.dim_repair_order_id)
3. 276.157 5,252.466 ↑ 1.3 691,076 3 / 3

Parallel Hash Semi Join (cost=1,142,140.52..1,522,271.04 rows=888,393 width=32) (actual time=3,887.093..5,252.466 rows=691,076 loops=3)

  • Hash Cond: (f.dim_repair_order_id = flllc.dim_repair_order_id)
4. 285.994 3,062.458 ↑ 1.3 691,076 3 / 3

Parallel Hash Semi Join (cost=588,485.94..956,401.05 rows=888,393 width=24) (actual time=1,970.096..3,062.458 rows=691,076 loops=3)

  • Hash Cond: (f.dim_repair_order_id = fllcr.dim_repair_order_id)
5. 453.539 1,000.291 ↑ 1.1 843,973 3 / 3

Parallel Hash Join (cost=40,683.12..396,382.83 rows=888,393 width=16) (actual time=192.376..1,000.291 rows=843,973 loops=3)

  • Hash Cond: (f.dim_repair_order_id = dro.dim_repair_order_id)
6. 356.024 356.024 ↑ 1.3 1,089,051 3 / 3

Parallel Seq Scan on fact_labor_line f (cost=0.00..346,893.14 rows=1,361,314 width=8) (actual time=0.018..356.024 rows=1,089,051 loops=3)

7. 72.339 190.728 ↑ 1.2 220,273 3 / 3

Parallel Hash (cost=37,245.14..37,245.14 rows=275,039 width=8) (actual time=190.728..190.728 rows=220,273 loops=3)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 34,080kB
8. 118.389 118.389 ↑ 1.2 220,273 3 / 3

Parallel Seq Scan on dim_repair_order dro (cost=0.00..37,245.14 rows=275,039 width=8) (actual time=0.037..118.389 rows=220,273 loops=3)

  • Filter: (pay_type = ANY ('{C,W}'::bpchar[]))
  • Rows Removed by Filter: 116,888
9. 138.012 1,776.173 ↑ 1.2 350,733 3 / 3

Parallel Hash (cost=542,454.33..542,454.33 rows=427,879 width=8) (actual time=1,776.173..1,776.173 rows=350,733 loops=3)

  • Buckets: 2,097,152 (originally 1048576) Batches: 1 (originally 1) Memory Usage: 65,760kB
10. 457.129 1,638.161 ↑ 1.2 350,733 3 / 3

Parallel Hash Join (cost=188,673.43..542,454.33 rows=427,879 width=8) (actual time=842.121..1,638.161 rows=350,733 loops=3)

  • Hash Cond: (fllcr.dim_labor_line_id = dllcr.dim_labor_line_id)
11. 344.479 344.479 ↑ 1.3 1,089,051 3 / 3

Parallel Seq Scan on fact_labor_line fllcr (cost=0.00..346,893.14 rows=1,361,314 width=16) (actual time=0.017..344.479 rows=1,089,051 loops=3)

12. 122.812 836.553 ↑ 1.3 350,733 3 / 3

Parallel Hash (cost=183,012.33..183,012.33 rows=452,888 width=8) (actual time=836.552..836.553 rows=350,733 loops=3)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 57,600kB
13. 713.741 713.741 ↑ 1.3 350,733 3 / 3

Parallel Seq Scan on dim_labor_line dllcr (cost=0.00..183,012.33 rows=452,888 width=8) (actual time=0.051..713.741 rows=350,733 loops=3)

  • Filter: ((is_roams_line = 'Y'::bpchar) AND (labor_category = ANY ('{C,M,R}'::bpchar[])))
  • Rows Removed by Filter: 801,973
14. 192.853 1,913.851 ↑ 1.2 627,400 3 / 3

Parallel Hash (cost=544,353.41..544,353.41 rows=744,094 width=8) (actual time=1,913.851..1,913.851 rows=627,400 loops=3)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 90,048kB
15. 576.031 1,720.998 ↑ 1.2 627,400 3 / 3

Parallel Hash Join (cost=189,254.95..544,353.41 rows=744,094 width=8) (actual time=805.124..1,720.998 rows=627,400 loops=3)

  • Hash Cond: (flllc.dim_labor_line_id = dlllc.dim_labor_line_id)
16. 344.232 344.232 ↑ 1.3 1,089,051 3 / 3

Parallel Seq Scan on fact_labor_line flllc (cost=0.00..346,893.14 rows=1,361,314 width=16) (actual time=0.013..344.232 rows=1,089,051 loops=3)

17. 213.137 800.735 ↑ 1.3 627,400 3 / 3

Parallel Hash (cost=179,410.13..179,410.13 rows=787,586 width=8) (actual time=800.735..800.735 rows=627,400 loops=3)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 90,048kB
18. 587.598 587.598 ↑ 1.3 627,400 3 / 3

Parallel Seq Scan on dim_labor_line dlllc (cost=0.00..179,410.13 rows=787,586 width=8) (actual time=0.052..587.598 rows=627,400 loops=3)

  • Filter: (labor_category = ANY ('{C,M,R}'::bpchar[]))
  • Rows Removed by Filter: 525,306
19. 335.040 2,304.923 ↓ 1.1 1,089,051 3 / 3

Parallel Hash (cost=351,998.06..351,998.06 rows=1,026,510 width=8) (actual time=2,304.923..2,304.923 rows=1,089,051 loops=3)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 160,608kB
20. 1,969.883 1,969.883 ↓ 1.1 1,089,051 3 / 3

Parallel Seq Scan on fact_labor_line fll5 (cost=0.00..351,998.06 rows=1,026,510 width=8) (actual time=930.104..1,969.883 rows=1,089,051 loops=3)

  • Filter: (pay_type_short = ANY ('{C,W,I}'::bpchar[]))