explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WMSS

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 4.706 1,876.642 ↑ 33.0 77 1

Gather Motion 24:1 (slice6; segments: 24) (cost=0.00..5,930.32 rows=2,541 width=41) (actual time=1,876.340..1,876.642 rows=77 loops=1)

  • Merge Key: share0_ref2.record_src, share0_ref2.test_record, share0_ref2.to_char
2. 0.325 1,871.936 ↑ 15.1 7 1

Sort (cost=0.00..5,930.07 rows=106 width=41) (actual time=1,871.932..1,871.936 rows=7 loops=1)

  • Sort Key: victor_kilo0kilo2.bravo, victor_kilo0kilo2.seven, victor_kilo0kilo2.xray
  • Sort Method: quicksort Memory: 792kB
3. 0.000 1,871.611 ↑ 15.1 7 1

Sequence (cost=0.00..5,929.91 rows=106 width=41) (actual time=1,871.329..1,871.611 rows=7 loops=1)

4. 1,141.689 1,141.689 ↓ 1.0 1,308,677 1

Shared Scan (share slice:id 6:0) (cost=0.00..2,969.70 rows=1,307,033 width=1) (actual time=982.640..1,141.689 rows=1,308,677 loops=1)

5. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..2,969.70 rows=1,307,033 width=1) (never executed)

6. 540.620 745.619 ↓ 1.0 1,308,677 1

Result (cost=0.00..2,968.39 rows=1,307,033 width=24) (actual time=0.597..745.619 rows=1,308,677 loops=1)

7. 204.999 204.999 ↓ 1.0 1,308,677 1

Seq Scan on victor_alpha (cost=0.00..2,866.52 rows=1,307,033 width=29) (actual time=0.415..204.999 rows=1,308,677 loops=1)

8. 30.286 772.545 ↑ 15.1 7 1

Append (cost=0.00..2,960.20 rows=106 width=41) (actual time=772.267..772.545 rows=7 loops=1)

9. 0.553 741.941 ↑ 21.2 5 1

HashAggregate (cost=0.00..1,025.97 rows=106 width=41) (actual time=741.871..741.941 rows=5 loops=1)

  • Group Key: victor_kilo0kilo2.bravo, victor_kilo0kilo2.seven, victor_kilo0kilo2.xray
  • Extra Text: (seg1) Hash chain length 1.2 avg, 2 max, using 4 of 32 buckets; total 0 expansions.
10. 126.707 741.388 ↓ 1.1 120 1

Redistribute Motion 24:24 (slice1; segments: 24) (cost=0.00..1,025.93 rows=106 width=41) (actual time=345.874..741.388 rows=120 loops=1)

  • Hash Key: share0_ref2.record_src, share0_ref2.test_record, share0_ref2.to_char
11. 0.020 614.681 ↑ 1.6 67 1

Result (cost=0.00..1,025.92 rows=106 width=41) (actual time=614.624..614.681 rows=67 loops=1)

12. 481.898 614.661 ↑ 1.6 67 1

HashAggregate (cost=0.00..1,025.92 rows=106 width=41) (actual time=614.619..614.661 rows=67 loops=1)

  • Group Key: victor_kilo0kilo2.bravo, victor_kilo0kilo2.seven, victor_kilo0kilo2.xray
  • Extra Text: (seg0) Hash chain length 2.5 avg, 6 max, using 27 of 32 buckets; total 0 expansions.
13. 132.763 132.763 ↓ 1.0 1,308,677 1

Shared Scan (share slice:id 1:0) (cost=0.00..522.35 rows=1,307,033 width=29) (actual time=0.106..132.763 rows=1,308,677 loops=1)

14. 0.006 0.184 ↓ 2.0 2 1

Result (cost=0.00..832.60 rows=1 width=41) (actual time=0.177..0.184 rows=2 loops=1)

15. 0.019 0.178 ↓ 2.0 2 1

GroupAggregate (cost=0.00..832.60 rows=1 width=33) (actual time=0.171..0.178 rows=2 loops=1)

  • Group Key: victor_kilo0kilo3.bravo, victor_kilo0kilo3.seven
16. 0.105 0.159 ↓ 48.0 48 1

Sort (cost=0.00..832.60 rows=1 width=33) (actual time=0.156..0.159 rows=48 loops=1)

  • Sort Key: victor_kilo0kilo3.bravo, victor_kilo0kilo3.seven
  • Sort Method: quicksort Memory: 824kB
17. 0.000 0.054 ↓ 48.0 48 1

Redistribute Motion 24:24 (slice2; segments: 24) (cost=0.00..832.60 rows=1 width=33) (actual time=0.007..0.054 rows=48 loops=1)

  • Hash Key: share0_ref3.record_src, share0_ref3.test_record
18. 0.007 616.918 ↓ 5.0 5 1

Result (cost=0.00..832.60 rows=1 width=33) (actual time=616.887..616.918 rows=5 loops=1)

19. 616.911 616.911 ↓ 5.0 5 1

HashAggregate (cost=0.00..832.60 rows=1 width=33) (actual time=616.881..616.911 rows=5 loops=1)

  • Group Key: victor_kilo0kilo3.bravo, victor_kilo0kilo3.seven
  • Extra Text: (seg0) Hash chain length 1.0 avg, 1 max, using 5 of 32 buckets; total 0 expansions.
  • -> Shared Scan (share slice:id 2:0) (cost=0.00..497.15 rows=1,307,033 width=21) (actual time=0.098..112.928 rows=1,308,677 loops
20. 0.002 0.124 ↑ 1.0 1 1

Result (cost=0.00..656.27 rows=1 width=41) (actual time=0.124..0.124 rows=1 loops=1)

21. 0.014 0.122 ↑ 1.0 1 1

GroupAggregate (cost=0.00..656.27 rows=1 width=29) (actual time=0.122..0.122 rows=1 loops=1)

  • Group Key: victor_kilo0kilo4.bravo
22. 0.068 0.108 ↓ 24.0 24 1

Sort (cost=0.00..656.27 rows=1 width=29) (actual time=0.108..0.108 rows=24 loops=1)

  • Sort Key: victor_kilo0kilo4.bravo
  • Sort Method: quicksort Memory: 792kB
23. 0.000 0.040 ↓ 24.0 24 1

Redistribute Motion 24:24 (slice3; segments: 24) (cost=0.00..656.27 rows=1 width=29) (actual time=0.007..0.040 rows=24 loops=1)

  • Hash Key: share0_ref4.record_src
24. 0.005 582.807 ↓ 4.0 4 1

Result (cost=0.00..656.27 rows=1 width=29) (actual time=582.781..582.807 rows=4 loops=1)

25. 582.802 582.802 ↓ 4.0 4 1

HashAggregate (cost=0.00..656.27 rows=1 width=29) (actual time=582.777..582.802 rows=4 loops=1)

  • Group Key: victor_kilo0kilo4.bravo
  • Extra Text: (seg0) Hash chain length 1.0 avg, 1 max, using 4 of 32 buckets; total 0 expansions.
  • -> Shared Scan (share slice:id 3:0) (cost=0.00..484.55 rows=1,307,033 width=17) (actual time=0.093..118.760 rows=1,308,677 loops
26. 0.005 0.010 ↑ 1.0 1 1

Result (cost=0.00..445.36 rows=1 width=36) (actual time=0.009..0.010 rows=1 loops=1)

27. 0.000 0.005 ↑ 1.0 1 1

Redistribute Motion 1:24 (slice5) (cost=0.00..445.36 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1)

28. 0.223 1,599.695 ↑ 1.0 1 1

Aggregate (cost=0.00..445.36 rows=1 width=16) (actual time=1,599.695..1,599.695 rows=1 loops=1)

29. 1,202.094 1,599.472 ↓ 24.0 24 1

Gather Motion 24:1 (slice4; segments: 24) (cost=0.00..445.36 rows=1 width=16) (actual time=1,229.317..1,599.472 rows=24 loops=1)

30. 247.108 397.378 ↑ 1.0 1 1

Aggregate (cost=0.00..445.36 rows=1 width=16) (actual time=397.378..397.378 rows=1 loops=1)

31. 150.270 150.270 ↓ 1.0 1,308,677 1

Shared Scan (share slice:id 4:0) (cost=0.00..443.60 rows=1,307,033 width=4) (actual time=0.130..150.270 rows=1,308,677 loops=1)