explain.depesz.com

A tool for finding a real cause for slow queries.

Result: JyG : Project Cost Info

options
# exclusive inclusive rows x rows loops node
1. 5.854 4049.455 ↑ 18.3 218 1
→

HashAggregate (cost=59203.090..59511.780 rows=3983 width=123) (actual time=4049.149..4049.455 rows=218 loops=1)

2. 1.026 4043.601 ↓ 1.0 4002 1
→

Hash Left Join (cost=58782.240..58964.110 rows=3983 width=123) (actual time=4041.050..4043.601 rows=4002 loops=1)

  • Hash Cond: (kilo_echo.quebec_seven = four.juliet)
3. 1.207 271.473 ↓ 1.0 4002 1
→

Hash Right Join (cost=2474.730..2609.330 rows=3983 width=91) (actual time=269.941..271.473 rows=4002 loops=1)

  • Hash Cond: (seven_delta.juliet = kilo_echo.quebec_seven)
4. 0.338 0.338 ↑ 1.0 3983 1
→

Seq Scan on kilo_zulu seven_delta (cost=0.000..79.830 rows=3983 width=10) (actual time=0.003..0.338 rows=3983 loops=1)

5. 0.050 269.928 ↑ 1.0 218 1
→

Hash (cost=2472.010..2472.010 rows=218 width=85) (actual time=269.928..269.928 rows=218 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
6. 0.030 269.878 ↑ 1.0 218 1
→

Hash Left Join (cost=2438.920..2472.010 rows=218 width=85) (actual time=269.819..269.878 rows=218 loops=1)

  • Hash Cond: (kilo_echo.quebec_seven = delta_echo.quebec_seven)
7. 0.086 269.783 ↑ 1.0 218 1
→

Hash Right Join (cost=2317.900..2350.160 rows=218 width=53) (actual time=269.749..269.783 rows=218 loops=1)

  • Hash Cond: (delta_november.charlie_seven = six_juliet.quebec_seven)
8. 0.154 0.154 ↓ 1.0 628 1
→

Seq Scan on romeo delta_november (cost=0.000..27.740 rows=627 width=10) (actual time=0.002..0.154 rows=628 loops=1)

  • Filter: ((november_lima)::text = 'uniform'::text)
9. 0.047 269.543 ↑ 1.0 218 1
→

Hash (cost=2315.170..2315.170 rows=218 width=51) (actual time=269.543..269.543 rows=218 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
10. 0.081 269.496 ↑ 1.0 218 1
→

Hash Right Join (cost=2282.930..2315.170 rows=218 width=51) (actual time=269.474..269.496 rows=218 loops=1)

  • Hash Cond: (mike_whiskey.charlie_seven = six_juliet.quebec_seven)
11. 0.151 0.151 ↓ 1.0 626 1
→

Seq Scan on romeo mike_whiskey (cost=0.000..27.740 rows=625 width=10) (actual time=0.003..0.151 rows=626 loops=1)

  • Filter: ((november_lima)::text = 'oscar'::text)
12. 0.039 269.264 ↑ 1.0 218 1
→

Hash (cost=2280.210..2280.210 rows=218 width=45) (actual time=269.264..269.264 rows=218 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
13. 0.073 269.225 ↑ 1.0 218 1
→

Hash Right Join (cost=2273.950..2280.210 rows=218 width=45) (actual time=269.196..269.225 rows=218 loops=1)

  • Hash Cond: (six_juliet.quebec_seven = kilo_echo.charlie_seven)
14. 0.591 268.109 ↓ 1.8 356 1
→

HashAggregate (cost=2214.740..2218.240 rows=200 width=84) (actual time=267.950..268.109 rows=356 loops=1)

15. 167.335 267.518 ↑ 1.0 356 1
→

Hash Right Join (cost=927.170..2203.170 rows=356 width=84) (actual time=100.809..267.518 rows=356 loops=1)

  • Hash Cond: (six_six.charlie_seven = six_juliet.quebec_seven)
16. 98.672 99.844 ↓ 1.1 293 1
→

HashAggregate (cost=908.160..912.190 rows=269 width=77) (actual time=99.663..99.844 rows=293 loops=1)

17. 0.150 1.172 ↑ 1.0 323 1
→

Hash Left Join (cost=29.470..66.570 rows=324 width=77) (actual time=0.639..1.172 rows=323 loops=1)

  • Hash Cond: (six_six.quebec_seven = seven_lima.seven_sierra)
18. 0.223 0.846 ↑ 1.0 323 1
→

Hash Right Join (cost=19.870..53.940 rows=324 width=49) (actual time=0.451..0.846 rows=323 loops=1)

  • Hash Cond: (papa_echo.charlie_seven = six_six.charlie_seven)
19. 0.189 0.189 ↓ 1.0 627 1
→

Seq Scan on romeo papa_echo (cost=0.000..24.590 rows=626 width=8) (actual time=0.005..0.189 rows=627 loops=1)

  • Filter: charlie_alpha_sierra
20. 0.179 0.434 ↑ 1.0 323 1
→

Hash (cost=15.820..15.820 rows=324 width=45) (actual time=0.434..0.434 rows=323 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
21. 0.255 0.255 ↑ 1.0 323 1
→

Seq Scan on delta_delta six_six (cost=0.000..15.820 rows=324 width=45) (actual time=0.007..0.255 rows=323 loops=1)

  • Filter: (((victor_juliet)::text <> 'alpha_romeo'::text) AND ((victor_juliet)::text <> 'mike_sierra'::text))
22. 0.086 0.176 ↑ 1.1 217 1
→

Hash (cost=6.490..6.490 rows=249 width=36) (actual time=0.176..0.176 rows=217 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
23. 0.090 0.090 ↑ 1.0 249 1
→

Seq Scan on tango_november seven_lima (cost=0.000..6.490 rows=249 width=36) (actual time=0.005..0.090 rows=249 loops=1)

24. 0.166 0.339 ↑ 1.0 356 1
→

Hash (cost=14.560..14.560 rows=356 width=20) (actual time=0.339..0.339 rows=356 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
25. 0.173 0.173 ↑ 1.0 356 1
→

Seq Scan on bravo_kilo six_juliet (cost=0.000..14.560 rows=356 width=20) (actual time=0.003..0.173 rows=356 loops=1)

26. 0.102 1.043 ↑ 1.0 218 1
→

Hash (cost=56.480..56.480 rows=218 width=41) (actual time=1.043..1.043 rows=218 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
27. 0.151 0.941 ↑ 1.0 218 1
→

Hash Right Join (cost=29.540..56.480 rows=218 width=41) (actual time=0.888..0.941 rows=218 loops=1)

  • Hash Cond: (seven_xray.charlie_seven = kilo_echo.charlie_seven)
28. 0.294 0.294 ↓ 1.0 627 1
→

Seq Scan on romeo seven_xray (cost=0.000..24.590 rows=626 width=10) (actual time=0.005..0.294 rows=627 loops=1)

  • Filter: charlie_alpha_sierra
29. 0.096 0.496 ↑ 1.0 218 1
→

Hash (cost=26.810..26.810 rows=218 width=35) (actual time=0.496..0.496 rows=218 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
30. 0.144 0.400 ↑ 1.0 218 1
→

Hash Right Join (cost=10.900..26.810 rows=218 width=35) (actual time=0.345..0.400 rows=218 loops=1)

  • Hash Cond: (six_juliet.quebec_seven = kilo_echo.charlie_seven)
31. 0.038 0.038 ↑ 1.0 356 1
→

Seq Scan on bravo_kilo six_juliet (cost=0.000..14.560 rows=356 width=13) (actual time=0.003..0.038 rows=356 loops=1)

32. 0.105 0.218 ↑ 1.0 218 1
→

Hash (cost=8.180..8.180 rows=218 width=22) (actual time=0.218..0.218 rows=218 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
33. 0.113 0.113 ↑ 1.0 218 1
→

Seq Scan on seven_kilo kilo_echo (cost=0.000..8.180 rows=218 width=22) (actual time=0.007..0.113 rows=218 loops=1)

34. 0.001 0.065 ↓ 0.0 0 1
→

Hash (cost=121.010..121.010 rows=1 width=36) (actual time=0.065..0.065 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
35. 0.000 0.064 ↓ 0.0 0 1
→

Subquery Scan on vwprj_claim_received (cost=120.980..121.010 rows=1 width=36) (actual time=0.064..0.064 rows=0 loops=1)

36. 0.001 0.064 ↓ 0.0 0 1
→

HashAggregate (cost=120.980..121.000 rows=1 width=56) (actual time=0.064..0.064 rows=0 loops=1)

37. 0.000 0.063 ↓ 0.0 0 1
→

Nested Loop Left Join (cost=90.260..120.850 rows=1 width=56) (actual time=0.063..0.063 rows=0 loops=1)

38. 0.003 0.063 ↓ 0.0 0 1
→

Hash Right Join (cost=90.260..120.350 rows=1 width=54) (actual time=0.063..0.063 rows=0 loops=1)

  • Hash Cond: (mike_whiskey.charlie_seven = six_six.charlie_seven)
39. 0.000 0.000 ↓ 0.0 0
→

Seq Scan on romeo mike_whiskey (cost=0.000..27.740 rows=625 width=10) (actual time=.. rows= loops=0)

  • Filter: ((november_lima)::text = 'oscar'::text)
40. 0.000 0.060 ↓ 0.0 0 1
→

Hash (cost=90.250..90.250 rows=1 width=52) (actual time=0.060..0.060 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
41. 0.006 0.060 ↓ 0.0 0 1
→

Hash Right Join (cost=60.150..90.250 rows=1 width=52) (actual time=0.060..0.060 rows=0 loops=1)

  • Hash Cond: (delta_november.charlie_seven = six_six.charlie_seven)
42. 0.000 0.000 ↓ 0.0 0
→

Seq Scan on romeo delta_november (cost=0.000..27.740 rows=627 width=10) (actual time=.. rows= loops=0)

  • Filter: ((november_lima)::text = 'uniform'::text)
43. 0.000 0.054 ↓ 0.0 0 1
→

Hash (cost=60.140..60.140 rows=1 width=46) (actual time=0.054..0.054 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
44. 0.004 0.054 ↓ 0.0 0 1
→

Hash Right Join (cost=55.830..60.140 rows=1 width=46) (actual time=0.054..0.054 rows=0 loops=1)

  • Hash Cond: (six_six.quebec_seven = six_six.quebec_seven)
45. 0.000 0.000 ↓ 0.0 0
→

HashAggregate (cost=28.840..30.640 rows=181 width=20) (actual time=.. rows= loops=0)

46. 0.000 0.000 ↓ 0.0 0
→

Hash Join (cost=9.600..27.480 rows=181 width=20) (actual time=.. rows= loops=0)

  • Hash Cond: (six_six.quebec_seven = seven_lima.seven_sierra)
47. 0.000 0.000 ↓ 0.0 0
→

Seq Scan on delta_delta six_six (cost=0.000..14.850 rows=324 width=20) (actual time=.. rows= loops=0)

  • Filter: ((victor_juliet)::text <> november_november ('whiskey_five'::text[]))
48. 0.000 0.000 ↓ 0.0 0
→

Hash (cost=6.490..6.490 rows=249 width=4) (actual time=.. rows= loops=0)

49. 0.000 0.000 ↓ 0.0 0
→

Seq Scan on tango_november seven_lima (cost=0.000..6.490 rows=249 width=4) (actual time=.. rows= loops=0)

50. 0.000 0.050 ↓ 0.0 0 1
→

Hash (cost=26.980..26.980 rows=1 width=34) (actual time=0.050..0.050 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
51. 0.006 0.050 ↓ 0.0 0 1
→

Hash Join (cost=10.900..26.980 rows=1 width=34) (actual time=0.050..0.050 rows=0 loops=1)

  • Hash Cond: (six_six.charlie_seven = kilo_echo.charlie_seven)
52. 0.003 0.003 ↑ 324.0 1 1
→

Seq Scan on delta_delta six_six (cost=0.000..14.850 rows=324 width=28) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: ((victor_juliet)::text <> november_november ('whiskey_five'::text[]))
53. 0.010 0.041 ↓ 0.0 0 1
→

Hash (cost=8.180..8.180 rows=218 width=10) (actual time=0.041..0.041 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
54. 0.031 0.031 ↑ 1.0 218 1
→

Seq Scan on seven_kilo kilo_echo (cost=0.000..8.180 rows=218 width=10) (actual time=0.002..0.031 rows=218 loops=1)

55. 0.000 0.000 ↓ 0.0 0
→

Index Scan using tango_seven on romeo papa_echo (cost=0.000..0.490 rows=1 width=10) (actual time=.. rows= loops=0)

  • Index Cond: (six_six.papa_mike = quebec_seven)
56. 0.039 3771.102 ↓ 1.0 178 1
→

Hash (cost=56305.300..56305.300 rows=177 width=36) (actual time=3771.102..3771.102 rows=178 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
57. 0.011 3771.063 ↓ 1.0 178 1
→

Subquery Scan on vwexpense (cost=56301.760..56305.300 rows=177 width=36) (actual time=3771.023..3771.063 rows=178 loops=1)

58. 3339.262 3771.052 ↓ 1.0 178 1
→

HashAggregate (cost=56301.760..56303.530 rows=177 width=44) (actual time=3771.022..3771.052 rows=178 loops=1)

59. 17.818 431.790 ↓ 1.3 29342 1
→

Hash Right Join (cost=10725.600..11588.820 rows=21945 width=44) (actual time=411.609..431.790 rows=29342 loops=1)

  • Hash Cond: (two.charlie_alpha_yankee = charlie_oscar.quebec_seven)
60. 2.371 2.371 ↑ 1.0 18279 1
→

Seq Scan on alpha_xray two (cost=0.000..483.820 rows=18282 width=12) (actual time=0.002..2.371 rows=18279 loops=1)

61. 1.017 411.601 ↓ 1.0 5771 1
→

Hash (cost=10655.630..10655.630 rows=5598 width=40) (actual time=411.601..411.601 rows=5771 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 447kB
62. 1.743 410.584 ↓ 1.0 5771 1
→

Hash Right Join (cost=10405.450..10655.630 rows=5598 width=40) (actual time=408.400..410.584 rows=5771 loops=1)

  • Hash Cond: (quebec_whiskey.victor_echo = quebec_juliet.quebec_seven)
63. 0.449 0.449 ↑ 1.0 5662 1
→

Seq Scan on alpha_three quebec_whiskey (cost=0.000..144.640 rows=5664 width=12) (actual time=0.002..0.449 rows=5662 loops=1)

64. 0.822 408.392 ↓ 1.0 4795 1
→

Hash (cost=10347.480..10347.480 rows=4637 width=36) (actual time=408.392..408.392 rows=4795 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 336kB
65. 1.384 407.570 ↓ 1.0 4795 1
→

Hash Right Join (cost=10216.350..10347.480 rows=4637 width=36) (actual time=405.439..407.570 rows=4795 loops=1)

  • Hash Cond: (quebec_juliet.charlie_alpha_yankee = charlie_oscar.quebec_seven)
66. 0.616 3.058 ↑ 1.0 4527 1
→

Hash Right Join (cost=313.310..359.600 rows=4539 width=12) (actual time=2.303..3.058 rows=4527 loops=1)

  • Hash Cond: (november_hotel.seven_sierra = quebec_juliet.quebec_seven)
67. 0.377 0.625 ↑ 1.0 1245 1
→

HashAggregate (cost=43.250..55.700 rows=1245 width=4) (actual time=0.479..0.625 rows=1245 loops=1)

68. 0.248 0.248 ↑ 1.0 1550 1
→

Seq Scan on november_hotel (cost=0.000..39.380 rows=1550 width=4) (actual time=0.003..0.248 rows=1550 loops=1)

  • Filter: (seven_sierra > 0)
69. 0.630 1.817 ↑ 1.0 4527 1
→

Hash (cost=213.320..213.320 rows=4539 width=12) (actual time=1.817..1.817 rows=4527 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 195kB
70. 1.187 1.187 ↑ 1.0 4527 1
→

Seq Scan on victor_mike quebec_juliet (cost=0.000..213.320 rows=4539 width=12) (actual time=0.005..1.187 rows=4527 loops=1)

  • Filter: (((victor_juliet)::text <> 'alpha_romeo'::text) AND ((victor_juliet)::text <> 'mike_sierra'::text))
71. 0.667 403.128 ↑ 1.0 4637 1
→

Hash (cost=9845.080..9845.080 rows=4637 width=28) (actual time=403.128..403.128 rows=4637 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 290kB
72. 1.610 402.461 ↑ 1.0 4637 1
→

Hash Right Join (cost=9728.670..9845.080 rows=4637 width=28) (actual time=400.643..402.461 rows=4637 loops=1)

  • Hash Cond: (whiskey_lima.quebec_seven = charlie_oscar.quebec_seven)
73. 1.525 398.631 ↓ 1.2 4664 1
→

Sort (cost=9452.410..9461.740 rows=3732 width=20) (actual time=398.416..398.631 rows=4664 loops=1)

  • Sort Key: (CASE WHEN ((whiskey_lima.quebec_echo = 0::double precision) OR (whiskey_lima.quebec_echo five NULL)) THEN 1::double precision ELSE lima((whiskey_lima.charlie_india / whiskey_lima.quebec_echo), 1::double precision) END)
  • Sort Method: quicksort Memory: 411kB
74. 2.221 397.106 ↓ 1.2 4664 1
→

Subquery Scan on vwtemp (cost=3409.080..9231.000 rows=3732 width=20) (actual time=42.368..397.106 rows=4664 loops=1)

75. 355.442 394.885 ↓ 1.2 4664 1
→

HashAggregate (cost=3409.080..9175.020 rows=3732 width=52) (actual time=42.366..394.885 rows=4664 loops=1)

76. 0.671 39.443 ↓ 1.0 4665 1
→

Hash Left Join (cost=3203.160..3315.800 rows=4664 width=52) (actual time=38.008..39.443 rows=4665 loops=1)

  • Hash Cond: (charlie_oscar.quebec_seven = whiskey_lima.quebec_seven)
77. 6.081 15.561 ↑ 1.0 4664 1
→

HashAggregate (cost=1320.070..1366.710 rows=4664 width=32) (actual time=14.789..15.561 rows=4664 loops=1)

78. 5.886 9.480 ↓ 1.0 18370 1
→

Hash Right Join (cost=264.940..1091.550 rows=18282 width=32) (actual time=2.131..9.480 rows=18370 loops=1)

  • Hash Cond: (two.charlie_alpha_yankee = charlie_oscar.quebec_seven)
79. 1.471 1.471 ↑ 1.0 18279 1
→

Seq Scan on alpha_xray two (cost=0.000..483.820 rows=18282 width=12) (actual time=0.001..1.471 rows=18279 loops=1)

80. 0.661 2.123 ↑ 1.0 4664 1
→

Hash (cost=206.640..206.640 rows=4664 width=24) (actual time=2.123..2.123 rows=4664 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 292kB
81. 1.462 1.462 ↑ 1.0 4664 1
→

Seq Scan on echo charlie_oscar (cost=0.000..206.640 rows=4664 width=24) (actual time=0.002..1.462 rows=4664 loops=1)

82. 0.002 23.211 ↓ 1.2 10 1
→

Hash (cost=1882.980..1882.980 rows=8 width=24) (actual time=23.211..23.211 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
83. 0.003 23.209 ↓ 1.2 10 1
→

Subquery Scan on vwtemp (cost=1882.770..1882.980 rows=8 width=24) (actual time=23.204..23.209 rows=10 loops=1)

84. 0.017 23.206 ↓ 1.2 10 1
→

HashAggregate (cost=1882.770..1882.900 rows=8 width=56) (actual time=23.203..23.206 rows=10 loops=1)

85. 0.114 23.189 ↓ 1.2 10 1
→

Hash Left Join (cost=426.980..1882.590 rows=8 width=56) (actual time=8.115..23.189 rows=10 loops=1)

  • Hash Cond: (charlie_quebec.quebec_seven = kilo_echo.seven_sierra)
  • Filter: ((lima(kilo_echo.quebec_seven, 0) > 0) AND (whiskey_xray(kilo_echo.bravo_quebec) = 'oscar'::text))
86. 16.915 16.915 ↑ 37.9 119 1
→

Seq Scan on victor_mike charlie_quebec (cost=0.000..1397.040 rows=4516 width=44) (actual time=0.138..16.915 rows=119 loops=1)

  • Filter: (((victor_juliet)::text <> 'mike_sierra'::text) AND ((victor_juliet)::text <> 'alpha_romeo'::text) AND (whiskey_xray(hotel) <> 'oscar'::text))
87. 0.336 6.160 ↓ 193.2 1546 1
→

Hash (cost=426.880..426.880 rows=8 width=20) (actual time=6.160..6.160 rows=1546 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 85kB
88. 5.824 5.824 ↓ 193.2 1546 1
→

Seq Scan on november_hotel kilo_echo (cost=0.000..426.880 rows=8 width=20) (actual time=0.043..5.824 rows=1546 loops=1)

  • Filter: (whiskey_xray(bravo_quebec) = 'oscar'::text)
89. 0.691 2.220 ↑ 1.0 4637 1
→

Hash (cost=218.300..218.300 rows=4637 width=20) (actual time=2.220..2.220 rows=4637 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 236kB
90. 1.529 1.529 ↑ 1.0 4637 1
→

Seq Scan on echo charlie_oscar (cost=0.000..218.300 rows=4637 width=20) (actual time=0.004..1.529 rows=4637 loops=1)

  • Filter: ((victor_juliet)::text <> 'mike_sierra'::text)