explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcmF : All Workflows

Settings
# exclusive inclusive rows x rows loops node
1. 0.259 1,615.682 ↓ 363.0 726 1

Unique (cost=80,563.550..80,563.580 rows=2 width=80) (actual time=1,615.315..1,615.682 rows=726 loops=1)

2. 1.417 1,615.423 ↓ 363.0 726 1

Sort (cost=80,563.550..80,563.560 rows=2 width=80) (actual time=1,615.314..1,615.423 rows=726 loops=1)

  • Sort Key: quebec_three_three.november_lima, (papa_five('kilo'::text, (whiskey_three(lima_delta."india_three")))), (five(*)), ('zulu_six'::text)
  • Sort Method: quicksort Memory: 103kB
3. 0.053 1,614.006 ↓ 363.0 726 1

Append (cost=57,495.700..80,563.540 rows=2 width=80) (actual time=1,263.401..1,614.006 rows=726 loops=1)

4. 3.557 1,268.872 ↓ 385.0 385 1

GroupAggregate (cost=57,495.700..57,495.720 rows=1 width=66) (actual time=1,263.401..1,268.872 rows=385 loops=1)

  • Group Key: quebec_three_three.november_lima, (papa_five('kilo'::text, (whiskey_three(lima_delta."india_three"))))
5. 21.621 1,265.315 ↓ 28,942.0 28,942 1

Sort (cost=57,495.700..57,495.700 rows=1 width=26) (actual time=1,263.389..1,265.315 rows=28,942 loops=1)

  • Sort Key: quebec_three_three.november_lima, (papa_five('kilo'::text, (whiskey_three(lima_delta."india_three"))))
  • Sort Method: quicksort Memory: 3029kB
6. 63.429 1,243.694 ↓ 28,942.0 28,942 1

Merge Join (cost=55,355.440..57,495.690 rows=1 width=26) (actual time=1,031.436..1,243.694 rows=28,942 loops=1)

  • Merge Cond: ((lima_delta.lima_sierra = papa_charlie.lima_sierra) AND (lima_delta.lima_two = papa_charlie.lima_two) AND (lima_delta.india_four = papa_charlie.india_four))
7. 97.440 960.834 ↓ 3.7 164,959 1

Finalize GroupAggregate (cost=35,380.080..36,500.430 rows=44,814 width=34) (actual time=821.104..960.834 rows=164,959 loops=1)

  • Group Key: lima_delta.lima_sierra, lima_delta.lima_two, lima_delta.india_four
  • Filter: (whiskey_three(lima_delta."india_three") > 'two'::timestamp with time zone)
  • Rows Removed by Filter: 5085
8. 298.405 863.394 ↓ 4.1 184,733 1

Sort (cost=35,380.080..35,492.110 rows=44,814 width=34) (actual time=821.086..863.394 rows=184,733 loops=1)

  • Sort Key: lima_delta.lima_sierra, lima_delta.lima_two, lima_delta.india_four
  • Sort Method: external sort Disk: 9344kB
9. 120.809 564.989 ↓ 4.3 192,479 1

Gather (cost=24,984.560..31,917.820 rows=44,814 width=34) (actual time=301.051..564.989 rows=192,479 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
10. 89.911 444.180 ↓ 2.1 96,240 2

Partial GroupAggregate (cost=23,984.560..26,436.420 rows=44,814 width=34) (actual time=286.700..444.180 rows=96,240 loops=2)

  • Group Key: lima_delta.lima_sierra, lima_delta.lima_two, lima_delta.india_four
11. 291.163 354.269 ↑ 1.2 135,659 2

Sort (cost=23,984.560..24,385.300 rows=160,298 width=34) (actual time=286.670..354.269 rows=135,659 loops=2)

  • Sort Key: lima_delta.lima_sierra, lima_delta.lima_two, lima_delta.india_four
  • Sort Method: external merge Disk: 8192kB
12. 63.106 63.106 ↑ 1.2 135,659 2

Parallel Seq Scan on six lima_delta (cost=0.000..5,740.980 rows=160,298 width=34) (actual time=0.132..63.106 rows=135,659 loops=2)

13. 65.248 219.431 ↓ 1.3 31,037 1

Sort (cost=19,975.360..20,034.270 rows=23,564 width=48) (actual time=210.281..219.431 rows=31,037 loops=1)

  • Sort Key: papa_charlie.lima_sierra, papa_charlie.lima_two, papa_charlie.india_four
  • Sort Method: external sort Disk: 2072kB
14. 31.322 154.183 ↓ 1.3 31,037 1

Gather (cost=1,225.870..18,264.110 rows=23,564 width=48) (actual time=5.901..154.183 rows=31,037 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
15. 22.523 122.861 ↓ 1.1 15,518 2

Hash Join (cost=225.870..14,907.710 rows=13,861 width=48) (actual time=1.489..122.861 rows=15,518 loops=2)

  • Hash Cond: (papa_charlie.india_four = quebec_three_three.oscar)
16. 99.156 99.156 ↑ 1.1 60,363 2

Parallel Seq Scan on november_zulu papa_charlie (cost=0.000..9,961.780 rows=69,154 width=26) (actual time=0.184..99.156 rows=60,363 loops=2)

  • Filter: (india_four <> november_november ('alpha_lima'::integer[]))
  • Rows Removed by Filter: 28085
17. 0.010 1.182 ↑ 82.4 16 2

Hash (cost=209.380..209.380 rows=1,319 width=22) (actual time=1.182..1.182 rows=16 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
18. 1.172 1.172 ↑ 69.4 19 2

Seq Scan on zulu_india quebec_three_three (cost=0.000..209.380 rows=1,319 width=22) (actual time=0.341..1.172 rows=19 loops=2)

  • Filter: (((hotel_romeo ->> 'bravo'::text) !~~ 'four'::text) AND ((hotel_romeo ->> 'bravo'::text) !~~ 'victor'::text) AND ((hotel_romeo ->> 'bravo'::text) !~~ 'delta'::text) AND ((hotel_romeo ->> 'bravo'::text) !~~ 'yankee'::text))
  • Rows Removed by Filter: 1328
19. 4.876 345.081 ↓ 341.0 341 1

GroupAggregate (cost=23,067.780..23,067.800 rows=1 width=66) (actual time=275.109..345.081 rows=341 loops=1)

  • Group Key: mike1.november_lima, (papa_five('kilo'::text, seven.uniform_victor))
20. 89.528 340.205 ↓ 16,350.0 16,350 1

Sort (cost=23,067.780..23,067.780 rows=1 width=26) (actual time=275.097..340.205 rows=16,350 loops=1)

  • Sort Key: mike1.november_lima, (papa_five('kilo'::text, seven.uniform_victor))
  • Sort Method: quicksort Memory: 1642kB
21. 20.873 250.677 ↓ 16,350.0 16,350 1

Merge Join (cost=22,810.230..23,067.770 rows=1 width=26) (actual time=222.052..250.677 rows=16,350 loops=1)

  • Merge Cond: ((quebec_three_sierra1.india_four = seven.india_four) AND (quebec_three_sierra1.lima_sierra = seven.lima_sierra) AND (quebec_three_sierra1.lima_two = seven.lima_two))
22. 18.048 76.022 ↓ 4.8 18,160 1

Sort (cost=12,815.990..12,825.500 rows=3,804 width=48) (actual time=71.971..76.022 rows=18,160 loops=1)

  • Sort Key: quebec_three_sierra1.india_four, quebec_three_sierra1.lima_sierra, quebec_three_sierra1.lima_two
  • Sort Method: quicksort Memory: 2689kB
23. 10.407 57.974 ↓ 4.8 18,160 1

Gather (cost=1,225.870..12,589.780 rows=3,804 width=48) (actual time=1.898..57.974 rows=18,160 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
24. 6.271 47.567 ↓ 4.1 9,080 2

Hash Join (cost=225.870..11,209.380 rows=2,238 width=48) (actual time=1.515..47.567 rows=9,080 loops=2)

  • Hash Cond: (quebec_three_sierra1.india_four = mike1.oscar)
25. 40.069 40.069 ↓ 1.2 13,552 2

Parallel Seq Scan on november_zulu sierra (cost=0.000..10,221.510 rows=11,164 width=26) (actual time=0.202..40.069 rows=13,552 loops=2)

  • Filter: ((juliet_charlie = 'charlie'::recorduniform_delta.papa_golf) AND (india_four <> november_november ('alpha_lima'::integer[])))
  • Rows Removed by Filter: 74896
26. 0.011 1.227 ↑ 82.4 16 2

Hash (cost=209.380..209.380 rows=1,319 width=22) (actual time=1.227..1.227 rows=16 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
27. 1.216 1.216 ↑ 69.4 19 2

Seq Scan on zulu_india juliet_xray (cost=0.000..209.380 rows=1,319 width=22) (actual time=0.308..1.216 rows=19 loops=2)

  • Filter: (((hotel_romeo ->> 'bravo'::text) !~~ 'four'::text) AND ((hotel_romeo ->> 'bravo'::text) !~~ 'victor'::text) AND ((hotel_romeo ->> 'bravo'::text) !~~ 'delta'::text) AND ((hotel_romeo ->> 'bravo'::text) !~~ 'yankee'::text))
  • Rows Removed by Filter: 1328
28. 22.418 153.782 ↓ 1.2 26,975 1

Sort (cost=9,994.240..10,049.110 rows=21,949 width=34) (actual time=149.678..153.782 rows=26,975 loops=1)

  • Sort Key: seven.india_four, seven.lima_sierra, seven.lima_two
  • Sort Method: quicksort Memory: 2892kB
29. 3.753 131.364 ↓ 1.2 27,039 1

Subquery Scan on seven (cost=7,972.530..8,411.510 rows=21,949 width=34) (actual time=116.432..131.364 rows=27,039 loops=1)

30. 36.416 127.611 ↓ 1.2 27,039 1

HashAggregate (cost=7,972.530..8,192.020 rows=21,949 width=44) (actual time=116.431..127.611 rows=27,039 loops=1)

  • Group Key: papa_xray.lima_sierra, papa_xray.tango, papa_xray.lima_two, papa_xray.india_four
  • Filter: (alpha_four(papa_xray."india_three") > 'two'::timestamp with time zone)
  • Rows Removed by Filter: 2205
31. 91.195 91.195 ↓ 1.1 31,515 1

Seq Scan on six papa_xray (cost=0.000..7,544.330 rows=28,547 width=44) (actual time=0.335..91.195 rows=31,515 loops=1)

  • Filter: (whiskey_november ~~ 'hotel_india'::text)
  • Rows Removed by Filter: 239803
Planning time : 3.013 ms
Execution time : 1,632.615 ms