explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CHkZ

Settings
# exclusive inclusive rows x rows loops node
1. 505.546 1,514,014.734 ↓ 9.0 9 1

GroupAggregate (cost=9.800..99,051.740 rows=1 width=580) (actual time=130,824.356..1,514,014.734 rows=9 loops=1)

  • Output: seven_six.lima_golf, five_hotel(CASE WHEN ((five_whiskey_five.three_xray)::text = 'november_juliet'::text) THEN delta_romeo.delta_hotel ELSE 'november_golf'::double precision END), five_hotel(CASE WHEN (((five_whiskey_five.three_xray)::text = 'zulu_india'::text) AND (delta_papa (...)
  • Group Key: seven_six.lima_golf
2. 556.032 1,513,509.188 ↓ 334,546.0 334,546 1

Nested Loop (cost=9.800..99,051.690 rows=1 width=572) (actual time=29,813.011..1,513,509.188 rows=334,546 loops=1)

  • Output: seven_six.lima_golf, five_whiskey_five.three_xray, delta_romeo.delta_hotel, four_uniform.romeo_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, seven_two (...)
  • Inner Unique: true
  • Join Filter: ((five_whiskey_five.three_xray)::text = (delta_romeo.three_xray)::text)
  • Rows Removed by Join Filter: 510469
3. 139,123.403 1,512,096.808 ↓ 428,174.0 428,174 1

Nested Loop (cost=9.800..99,050.570 rows=1 width=802) (actual time=596.756..1,512,096.808 rows=428,174 loops=1)

  • Output: delta_romeo.delta_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, delta_romeo.three_xray, seven_six.lima_golf, seven_six.two_november, seven_six.quebec_charlie (...)
  • Join Filter: (delta_romeo.papa_bravo = six_six18.romeo_india)
  • Rows Removed by Join Filter: 1572683102
4. 288,828.559 1,260,363.643 ↓ 428,174.0 428,174 1

Nested Loop (cost=9.800..98,945.910 rows=1 width=810) (actual time=596.596..1,260,363.643 rows=428,174 loops=1)

  • Output: delta_romeo.delta_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, delta_romeo.three_xray, delta_romeo.papa_bravo, seven_six.lima_golf, seven_six.two_november, three_hotel (...)
  • Inner Unique: true
  • Join Filter: (delta_romeo.papa_bravo = oscar_victor_bravo.romeo_india)
  • Rows Removed by Join Filter: 3565461048
5. 677.049 673,525.980 ↓ 428,174.0 428,174 1

Nested Loop (cost=9.800..98,460.440 rows=1 width=806) (actual time=594.985..673,525.980 rows=428,174 loops=1)

  • Output: delta_romeo.delta_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, delta_romeo.three_xray, delta_romeo.papa_bravo, seven_six.lima_golf, seven_six.two_november, (...)
  • Inner Unique: true
6. 357,369.812 670,636.686 ↓ 442,449.0 442,449 1

Nested Loop Left Join (cost=9.380..98,459.990 rows=1 width=810) (actual time=594.649..670,636.686 rows=442,449 loops=1)

  • Output: delta_romeo.delta_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, delta_romeo.three_xray, delta_romeo.juliet_echo, delta_romeo.papa_bravo, seven_six.lima_golf, echo_mike_seven (...)
  • Inner Unique: true
  • Join Filter: ((delta_romeo.seven_three)::text = (bravo_two_oscar.seven_three)::text)
  • Rows Removed by Join Filter: 3514874049
  • Filter: ((bravo_two_oscar.papa_six five_romeo NULL) OR ((bravo_two_oscar.papa_six)::text = ANY ('golf_foxtrot'::text[])))
7. 24,529.581 38,948.494 ↓ 442,449.0 442,449 1

Nested Loop (cost=9.380..97,882.010 rows=1 width=948) (actual time=594.620..38,948.494 rows=442,449 loops=1)

  • Output: delta_romeo.delta_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, delta_romeo.three_xray, delta_romeo.seven_three, delta_romeo.juliet_echo, delta_romeo.papa_bravo, seven_six.lima_golf, golf_november (...)
  • Join Filter: (((delta_romeo.uniform_delta)::text = (seven_six.yankee_quebec)::text) AND ((delta_romeo.three_xray)::text = seven_six.three_xray))
  • Rows Removed by Join Filter: 230364966
8. 6.559 6.559 ↓ 139.0 417 1

Index Scan using victor on kilo_juliet seven_six (cost=0.280..62.110 rows=3 width=694) (actual time=0.072..6.559 rows=417 loops=1)

  • Output: seven_six.yankee_quebec, seven_six.juliet_seven, seven_six.bravo_quebec, seven_six.lima_golf, seven_six.delta_golf, three_quebec (...)
  • Filter: (((seven_six.zulu_echo)::text = 'four_sierra'::text) AND ((seven_six.lima_golf)::text <> november_november ('delta_lima'::text[])))
  • Rows Removed by Filter: 220
9. 11,466.107 14,412.354 ↓ 1,076.8 553,495 417

Materialize (cost=9.100..97,794.210 rows=514 width=530) (actual time=0.002..34.562 rows=553,495 loops=417)

  • Output: delta_romeo.delta_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, delta_romeo.uniform_delta, delta_romeo.three_xray, delta_romeo.seven_three, delta_romeo.juliet_echo, delta_romeo.papa_bravo
10. 263.767 2,946.247 ↓ 1,076.8 553,495 1

Hash Join (cost=9.100..97,791.640 rows=514 width=530) (actual time=0.571..2,946.247 rows=553,495 loops=1)

  • Output: delta_romeo.delta_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, delta_romeo.uniform_delta, delta_romeo.three_xray, delta_romeo.seven_three, delta_romeo.juliet_echo, delta_romeo.papa_bravo
  • Inner Unique: true
  • Hash Cond: ((delta_romeo.juliet_lima)::text = (echo_mike_lima.juliet_lima)::text)
11. 574.695 2,682.334 ↓ 25.6 1,014,838 1

Nested Loop (cost=0.430..97,677.620 rows=39,585 width=748) (actual time=0.405..2,682.334 rows=1,014,838 loops=1)

  • Output: delta_romeo.delta_hotel, delta_romeo.two_foxtrot7charlie_sierra_golf, delta_romeo.two_foxtrot7quebec_xray1, delta_romeo.juliet_lima, delta_romeo.uniform_delta, delta_romeo.three_xray, delta_romeo.seven_three, delta_romeo.juliet_echo, delta_romeo.papa_bravo
12. 0.032 0.032 ↑ 1.0 1 1

Seq Scan on seven_xray_echo hotel_three (cost=0.000..1.100 rows=1 width=8) (actual time=0.029..0.032 rows=1 loops=1)

  • Output: november_delta5.bravo_quebec, november_delta5.five_whiskey_xray, november_delta5.six_bravo, november_delta5.charlie_sierra_six, seven_mike (...)
  • Filter: ((november_delta5.five_whiskey_xray)::text = 'sierra'::text)
  • Rows Removed by Filter: 7
13. 2,107.607 2,107.607 ↓ 25.6 1,014,838 1

Index Scan using juliet_mike_xray on hotel_lima delta_romeo (cost=0.430..97,280.670 rows=39,585 width=756) (actual time=0.373..2,107.607 rows=1,014,838 loops=1)

  • Output: delta_romeo.seven_three, delta_romeo.uniform_delta, delta_romeo.november_two, delta_romeo.yankee_india, delta_romeo.mike_india_hotel, delta_romeo.golf_hotel, delta_romeo.quebec_foxtrot, delta_romeo.mike_golf, delta_romeo.three_xray, delta_romeo.four_romeo, delta_romeo.juliet_echo, delta_romeo.kilo_golf, delta_romeo.uniform_six, (...)
  • Index Cond: (delta_romeo.four_romeo = november_delta5.bravo_quebec)
14. 0.006 0.146 ↑ 1.0 4 1

Hash (cost=8.620..8.620 rows=4 width=36) (actual time=0.145..0.146 rows=4 loops=1)

  • Output: echo_mike_lima.juliet_lima
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.140 0.140 ↑ 1.0 4 1

Seq Scan on oscar_golf echo_mike_lima (cost=0.000..8.620 rows=4 width=36) (actual time=0.067..0.140 rows=4 loops=1)

  • Output: echo_mike_lima.juliet_lima
  • Filter: ((echo_mike_lima.juliet_lima)::text = ANY ('foxtrot_victor'::text[]))
  • Rows Removed by Filter: 304
16. 274,318.380 274,318.380 ↑ 1.7 7,945 442,449

Seq Scan on india_india bravo_two_oscar (cost=0.000..358.230 rows=13,523 width=412) (actual time=0.001..0.620 rows=7,945 loops=442,449)

  • Output: bravo_two_oscar.seven_three, bravo_two_oscar.oscar_bravo, bravo_two_oscar.yankee_seven, bravo_two_oscar.lima_golf, bravo_two_oscar.bravo_romeo, bravo_two_oscar.zulu_echo, bravo_two_oscar.oscar_zulu_four, bravo_two_oscar.seven_xray_oscar, bravo_two_oscar.two_alpha, seven_sierra (...)
17. 2,212.245 2,212.245 ↑ 1.0 1 442,449

Index Scan using oscar_victor_golf on juliet_victor four_uniform (cost=0.420..0.450 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=442,449)

  • Output: four_uniform.four_delta, four_uniform.yankee_victor, four_uniform.yankee_victor2, four_uniform.whiskey, four_uniform.bravo_two_charlie, four_lima (...)
  • Index Cond: (four_uniform.four_delta = delta_romeo.juliet_echo)
  • Filter: (((four_uniform.juliet_two)::text <> 'foxtrot_four'::text) AND ((four_uniform.yankee_victor)::text = ANY ('six_victor'::text[])))
  • Rows Removed by Filter: 0
18. 298,009.104 298,009.104 ↑ 1.1 8,328 428,174

Seq Scan on mike_two oscar_victor_bravo (cost=0.000..371.320 rows=9,132 width=4) (actual time=0.001..0.696 rows=8,328 loops=428,174)

  • Output: oscar_victor_bravo.romeo_india, oscar_victor_bravo.mike_india_uniform, oscar_victor_bravo.delta_delta, oscar_victor_bravo.five_quebec, oscar_victor_bravo.juliet_sierra, oscar_victor_bravo.oscar_zulu_three, oscar_victor_bravo.papa_four, oscar_victor_bravo.five_three, oscar_victor_bravo.zulu_quebec2, oscar_victor_bravo.xray (...)
19. 112,609.762 112,609.762 ↑ 1.0 3,674 428,174

Seq Scan on hotel_oscar lima_delta (cost=0.000..58.740 rows=3,674 width=4) (actual time=0.002..0.263 rows=3,674 loops=428,174)

  • Output: six_six18.oscar_zulu_three, six_six18.romeo_india, six_six18.india_charlie, six_six18.november_quebec, six_six18.india_mike, hotel_whiskey (...)
20. 856.348 856.348 ↑ 1.0 2 428,174

Seq Scan on juliet_mike_golf five_whiskey_five (cost=0.000..1.090 rows=2 width=20) (actual time=0.002..0.002 rows=2 loops=428,174)

  • Output: five_whiskey_five.three_xray, five_whiskey_five.charlie_bravo, five_whiskey_five.four_india, five_whiskey_five.charlie_charlie, five_whiskey_five.charlie_charlie2, five_whiskey_five.papa_quebec, five_whiskey_five.delta_foxtrot (...)
  • Filter: ((five_whiskey_five.three_xray)::text = ANY ('golf_xray'::text[]))
  • Rows Removed by Filter: 5