explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 8Ye1 : 32786

options
exclusive inclusive rows x rows loops node
5.090 3813.946 ↓ 42.0 2815 1
→

Group (cost=1660.300..1664.650 rows=67 width=343) (actual time=3808.431..3813.946 rows=2815 loops=1)

57.580 3808.856 ↓ 56.0 3753 1
→

Sort (cost=1660.300..1660.470 rows=67 width=343) (actual time=3808.428..3808.856 rows=3753 loops=1)

  • Sort Key: bravo_papa.mike_foxtrot, bravo_papa.seven_victor, bravo_papa.five_six, bravo_papa.romeo_two, bravo_papa.oscar_papa_delta, bravo_papa.hotel_golf, bravo_papa.oscar_papa_three, bravo_papa.hotel_kilo, bravo_papa.delta_three_six, bravo_papa.mike_six32787kilo_oscar267286, bravo_papa.mike_six32787kilo_oscar267287, bravo_papa.mike_six32787kilo_oscar267288, bravo_papa.bravo_charlie, (((CASE WHEN ((lima_sierra(bravo_papa.bravo_charlie, 0))::text = 'november'::text) THEN ''delta_alpha' 'alpha_november'0'papa'0'kilo_foxtrot'0'::text) END)), bravo_papa.golf_delta, bravo_papa.mike_six32788kilo_oscar267224, bravo_papa.echo_uniform
  • Sort Method: quicksort Memory: 1093kB
7.285 3751.276 ↓ 56.0 3753 1
→

Subquery Scan on foo (cost=1656.090..1658.270 rows=67 width=343) (actual time=3743.490..3751.276 rows=3753 loops=1)

23.721 3743.991 ↓ 56.0 3753 1
→

Sort (cost=1656.090..1656.260 rows=67 width=226) (actual time=3743.474..3743.991 rows=3753 loops=1)

  • Sort Key: charlie_india.delta_five, lima_two.seven_victor
  • Sort Method: quicksort Memory: 1093kB
7.124 3720.270 ↓ 56.0 3753 1
→

Nested Loop Left Join (cost=598.200..1654.060 rows=67 width=226) (actual time=25.997..3720.270 rows=3753 loops=1)

416.908 3709.393 ↓ 3753.0 3753 1
→

Nested Loop Left Join (cost=593.230..1385.470 rows=1 width=224) (actual time=25.988..3709.393 rows=3753 loops=1)

  • Join Filter: (((CASE WHEN ((lima_sierra(lima_two.quebec_seven, 0))::text = 'november'::text) THEN ''victor_mike' 'sierra_whiskey'0'papa'0'victor_kilo'0'five_juliet'0'four_papa' 'juliet_november'0'papa'0'bravo_two'0'::text) END)))
7.855 136.212 ↓ 3753.0 3753 1
→

Nested Loop Left Join (cost=62.840..854.940 rows=1 width=128) (actual time=0.970..136.212 rows=3753 loops=1)

  • Join Filter: (golf_quebec2.delta_mike = whiskey_india.delta_mike)
0.574 113.345 ↓ 3753.0 3753 1
→

Nested Loop (cost=40.420..832.480 rows=1 width=114) (actual time=0.858..113.345 rows=3753 loops=1)

0.330 101.512 ↓ 3753.0 3753 1
→

Nested Loop (cost=40.420..824.100 rows=1 width=98) (actual time=0.851..101.512 rows=3753 loops=1)

3.193 93.676 ↓ 3753.0 3753 1
→

Nested Loop Left Join (cost=40.420..815.820 rows=1 width=98) (actual time=0.845..93.676 rows=3753 loops=1)

4.259 86.730 ↓ 3753.0 3753 1
→

Nested Loop Left Join (cost=40.420..815.490 rows=1 width=94) (actual time=0.841..86.730 rows=3753 loops=1)

1.967 74.965 ↓ 3753.0 3753 1
→

Nested Loop (cost=40.420..807.110 rows=1 width=82) (actual time=0.833..74.965 rows=3753 loops=1)

3.458 65.492 ↓ 3753.0 3753 1
→

Nested Loop (cost=40.420..806.830 rows=1 width=90) (actual time=0.828..65.492 rows=3753 loops=1)

0.479 47.022 ↓ 83.4 3753 1
→

Nested Loop (cost=40.420..501.390 rows=45 width=66) (actual time=0.815..47.022 rows=3753 loops=1)

0.945 27.778 ↓ 5.5 3753 1
→

Nested Loop (cost=40.420..183.590 rows=686 width=34) (actual time=0.804..27.778 rows=3753 loops=1)

0.552 1.723 ↓ 1.9 62 1
→

Hash Join (cost=40.420..128.660 rows=33 width=26) (actual time=0.792..1.723 rows=62 loops=1)

  • Hash Cond: (romeo_delta2.juliet_victor = golf_quebec2.quebec_seven)
0.497 0.497 ↓ 1.0 4018 1
→

Seq Scan on delta_delta echo_two (cost=0.000..72.930 rows=3993 width=8) (actual time=0.007..0.497 rows=4018 loops=1)

0.009 0.674 ↑ 1.0 9 1
→

Hash (cost=40.310..40.310 rows=9 width=26) (actual time=0.674..0.674 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
0.665 0.665 ↑ 1.0 9 1
→

Seq Scan on tango echo_zulu (cost=0.000..40.310 rows=9 width=26) (actual time=0.130..0.665 rows=9 loops=1)

  • Filter: (delta_mike = ANY ('six_victor'::text[]))
25.110 25.110 ↓ 2.0 61 62
→

Index Scan using golf_november on four_echo sierra_echo (cost=0.000..1.280 rows=31 width=8) (actual time=0.151..0.405 rows=61 loops=62)

  • Index Cond: (sierra_echo.yankee_romeo_three = romeo_delta2.yankee_romeo_three)
18.765 18.765 ↑ 1.0 1 3753
→

Index Scan using hotel_lima on charlie_delta lima_two (cost=0.000..0.450 rows=1 width=36) (actual time=0.004..0.005 rows=1 loops=3753)

  • Index Cond: (lima_two.quebec_seven = sierra_echo.kilo_quebec)
  • Filter: (lima_two.hotel_oscar = 297)
15.012 15.012 ↑ 1.0 1 3753
→

Index Scan using whiskey_kilo on seven_hotel charlie_india (cost=0.000..6.780 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=3753)

  • Index Cond: (charlie_india.echo_juliet = lima_two.romeo_two)
  • Filter: (charlie_india.quebec_whiskey = 297)
7.506 7.506 ↑ 1.0 1 3753
→

Index Scan using two on zulu_charlie uniform (cost=0.000..0.270 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=3753)

  • Index Cond: (alpha_two2.quebec_seven = sierra_echo.yankee_romeo_three)
7.506 7.506 ↑ 1.0 1 3753
→

Index Scan using whiskey_kilo on seven_hotel delta_three_seven (cost=0.000..8.370 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=3753)

  • Index Cond: (golf_quebec2.sierra_juliet = four_hotel2.echo_juliet)
3.753 3.753 ↓ 0.0 0 3753
→

Index Scan using whiskey_two on tango whiskey_india (cost=0.000..0.310 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=3753)

  • Index Cond: (whiskey_india.sierra_juliet = charlie_india.echo_juliet)
  • Filter: (whiskey_india.hotel_oscar = 297)
7.506 7.506 ↑ 1.0 1 3753
→

Index Scan using golf_echo on quebec_hotel mike_november (cost=0.000..8.270 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=3753)

  • Index Cond: (mike_november.quebec_whiskey = 297)
11.259 11.259 ↑ 1.0 1 3753
→

Index Scan using whiskey_kilo on seven_hotel alpha_india (cost=0.000..8.370 rows=1 width=24) (actual time=0.002..0.003 rows=1 loops=3753)

  • Index Cond: (alpha_india.echo_juliet = mike_november.echo_juliet)
11.259 15.012 ↓ 9.0 9 3753
→

Group (cost=22.420..22.440 rows=1 width=46) (actual time=0.000..0.004 rows=9 loops=3753)

3.693 3.753 ↓ 9.0 9 3753
→

Sort (cost=22.420..22.420 rows=1 width=25) (actual time=0.000..0.001 rows=9 loops=3753)

  • Sort Key: whiskey_india.delta_mike, whiskey_india.bravo_six
  • Sort Method: quicksort Memory: 25kB
0.039 0.060 ↓ 9.0 9 1
→

Bitmap Heap Scan on tango whiskey_india (cost=4.530..22.410 rows=1 width=25) (actual time=0.030..0.060 rows=9 loops=1)

  • Recheck Cond: (hotel_oscar = 297)
  • Filter: (delta_mike = ANY ('six_victor'::text[]))
0.021 0.021 ↑ 1.0 37 1
→

Bitmap Index Scan on echo_delta (cost=0.000..4.530 rows=37 width=0) (actual time=0.021..0.021 rows=37 loops=1)

  • Index Cond: (hotel_oscar = 297)
3073.707 3156.273 ↓ 99.0 99 3753
→

GroupAggregate (cost=530.390..530.490 rows=1 width=154) (actual time=0.033..0.841 rows=99 loops=3753)

62.297 82.566 ↓ 144.0 144 3753
→

Sort (cost=530.390..530.390 rows=1 width=154) (actual time=0.006..0.022 rows=144 loops=3753)

  • Sort Key: bravo_papa.romeo_two, bravo_papa.seven_victor, bravo_papa.alpha_charlie, bravo_papa.foxtrot, bravo_papa.bravo_charlie, (((CASE WHEN ((lima_sierra(bravo_papa.bravo_charlie, 0))::text = 'november'::text) THEN ''delta_alpha' 'juliet_november'0'papa'0'bravo_two'0'::text) END))
  • Sort Method: quicksort Memory: 62kB
0.555 20.269 ↓ 144.0 144 1
→

Subquery Scan on foo (cost=530.340..530.380 rows=1 width=154) (actual time=19.705..20.269 rows=144 loops=1)

0.449 19.714 ↓ 144.0 144 1
→

Sort (cost=530.340..530.350 rows=1 width=79) (actual time=19.684..19.714 rows=144 loops=1)

  • Sort Key: lima_two.romeo_two, lima_two.seven_victor
  • Sort Method: quicksort Memory: 45kB
0.093 19.265 ↓ 144.0 144 1
→

Nested Loop (cost=0.000..530.330 rows=1 width=79) (actual time=0.185..19.265 rows=144 loops=1)

0.256 18.308 ↓ 144.0 144 1
→

Nested Loop Left Join (cost=0.000..530.000 rows=1 width=67) (actual time=0.175..18.308 rows=144 loops=1)

0.381 17.332 ↓ 144.0 144 1
→

Nested Loop (cost=0.000..521.620 rows=1 width=55) (actual time=0.169..17.332 rows=144 loops=1)

0.299 15.778 ↓ 65.2 391 1
→

Nested Loop (cost=0.000..519.870 rows=6 width=37) (actual time=0.163..15.778 rows=391 loops=1)

1.828 14.303 ↓ 49.0 147 1
→

Nested Loop (cost=0.000..470.270 rows=3 width=26) (actual time=0.152..14.303 rows=147 loops=1)

3.395 3.395 ↓ 43.2 1816 1
→

Index Scan using six_foxtrot on mike_charlie echo_romeo (cost=0.000..133.990 rows=42 width=12) (actual time=0.017..3.395 rows=1816 loops=1)

  • Index Cond: ((six_five >= 'alpha_hotel'::date) AND (six_five <= 'zulu_hotel'::date))
9.080 9.080 ↓ 0.0 0 1816
→

Index Scan using hotel_lima on charlie_delta lima_two (cost=0.000..7.990 rows=1 width=18) (actual time=0.005..0.005 rows=0 loops=1816)

  • Index Cond: (lima_two.quebec_seven = echo_romeo.kilo_quebec)
  • Filter: (lima_two.hotel_oscar = 297)
1.176 1.176 ↑ 1.0 3 147
→

Index Scan using mike_mike on sierra_four_seven three (cost=0.000..16.500 rows=3 width=19) (actual time=0.006..0.008 rows=3 loops=147)

  • Index Cond: (three.romeo_hotel = echo_romeo.quebec_seven)
1.173 1.173 ↓ 0.0 0 391
→

Index Scan using india_kilo on tango oscar_charlie (cost=0.000..0.280 rows=1 width=26) (actual time=0.003..0.003 rows=0 loops=391)

  • Index Cond: (golf_quebec3.quebec_seven = three.zulu_romeo)
  • Filter: (golf_quebec3.delta_mike = ANY ('six_victor'::text[]))
0.720 0.720 ↑ 1.0 1 144
→

Index Scan using whiskey_kilo on seven_hotel xray (cost=0.000..8.370 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=144)

  • Index Cond: (golf_quebec3.sierra_juliet = four_hotel3.echo_juliet)
0.864 0.864 ↑ 1.0 1 144
→

Index Scan using quebec_lima on romeo_charlie charlie_tango (cost=0.000..0.330 rows=1 width=20) (actual time=0.005..0.006 rows=1 loops=144)

  • Index Cond: (charlie_tango.yankee_romeo_papa = three.india_victor)
  • Filter: (charlie_tango.romeo_zulu = ANY ('six_seven'::text[]))
3.753 3.753 ↓ 0.0 0 3753
→

Bitmap Heap Scan on six_november sierra_four_golf (cost=4.970..267.470 rows=90 width=10) (actual time=0.001..0.001 rows=0 loops=3753)

  • Recheck Cond: (sierra_four_golf.juliet_victor = whiskey_india.quebec_seven)
0.000 0.000 ↓ 0.0 0 3753
→

Bitmap Index Scan on golf_golf (cost=0.000..4.950 rows=90 width=0) (actual time=0.000..0.000 rows=0 loops=3753)

  • Index Cond: (sierra_four_golf.juliet_victor = whiskey_india.quebec_seven)