explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KUPS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=1,570,632.900..1,605,868.900 rows=2,349,067 width=67) (actual rows= loops=)

  • Output: bravo_quebec.sierra_whiskey, (CASE WHEN ((bravo_quebec.three)::text = ANY ('oscar'::text[])) THEN 'juliet_zulu'::text WHEN ((bravo_quebec.three)::text = 'two_six'::text) THEN 'bravo_seven'::text WHEN ((bravo_quebec.three)::text = ANY ('alpha'::text[])) THEN 'whiskey'::text ELSE ''::text END), yankee_echo.six, yankee_echo.quebec_romeo, foxtrot.juliet_alpha
2. 0.000 0.000 ↓ 0.0

Sort (cost=1,570,632.900..1,576,505.570 rows=2,349,067 width=67) (actual rows= loops=)

  • Output: bravo_quebec.sierra_whiskey, (CASE WHEN ((bravo_quebec.three)::text = ANY ('oscar'::text[])) THEN 'juliet_zulu'::text WHEN ((bravo_quebec.three)::text = 'two_six'::text) THEN 'bravo_seven'::text WHEN ((bravo_quebec.three)::text = ANY ('alpha'::text[])) THEN 'whiskey'::text ELSE ''::text END), yankee_echo.six, yankee_echo.quebec_romeo, foxtrot.juliet_alpha
  • Sort Key: yankee_echo.six, bravo_quebec.sierra_whiskey, (CASE WHEN ((bravo_quebec.three)::text = ANY ('oscar'::text[])) THEN 'juliet_zulu'::text WHEN ((bravo_quebec.three)::text = 'two_six'::text) THEN 'bravo_seven'::text WHEN ((bravo_quebec.three)::text = ANY ('alpha'::text[])) THEN 'whiskey'::text ELSE ''::text END), yankee_echo.quebec_romeo, foxtrot.juliet_alpha
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=239,952.300..1,225,707.160 rows=2,349,067 width=67) (actual rows= loops=)

  • Output: bravo_quebec.sierra_whiskey, CASE WHEN ((bravo_quebec.three)::text = ANY ('oscar'::text[])) THEN 'juliet_zulu'::text WHEN ((bravo_quebec.three)::text = 'two_six'::text) THEN 'bravo_seven'::text WHEN ((bravo_quebec.three)::text = ANY ('alpha'::text[])) THEN 'whiskey'::text ELSE ''::text END, yankee_echo.six, yankee_echo.quebec_romeo, foxtrot.juliet_alpha
  • Hash Cond: ((yankee_echo.quebec_romeo)::text = (juliet_victor.romeo)::text)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=239,772.870..1,163,864.730 rows=2,349,067 width=54) (actual rows= loops=)

  • Output: yankee_echo.six, yankee_echo.quebec_romeo, bravo_quebec.sierra_whiskey, bravo_quebec.three
  • Hash Cond: ((yankee_echo.quebec_sierra)::text = (bravo_quebec.bravo_alpha)::text)
5. 0.000 0.000 ↓ 0.0

Index Only Scan using lima on two_golf yankee_echo (cost=0.000..824,030.490 rows=2,349,067 width=17) (actual rows= loops=)

  • Output: yankee_echo.six, yankee_echo.quebec_romeo, yankee_echo.quebec_sierra
  • Index Cond: (yankee_echo.four_mike = 'seven_juliet'::text)
  • Filter: ((yankee_echo.six)::text <> 'november'::text)
6. 0.000 0.000 ↓ 0.0

Hash (cost=167,572.610..167,572.610 rows=3,242,661 width=49) (actual rows= loops=)

  • Output: bravo_quebec.sierra_whiskey, bravo_quebec.three, bravo_quebec.bravo_alpha
7. 0.000 0.000 ↓ 0.0

Seq Scan on two_sierra bravo_quebec (cost=0.000..167,572.610 rows=3,242,661 width=49) (actual rows= loops=)

  • Output: bravo_quebec.sierra_whiskey, bravo_quebec.three, bravo_quebec.bravo_alpha
8. 0.000 0.000 ↓ 0.0

Hash (cost=161.090..161.090 rows=1,467 width=17) (actual rows= loops=)

  • Output: juliet_victor.romeo, foxtrot.juliet_alpha
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.250..161.090 rows=1,467 width=17) (actual rows= loops=)

  • Output: juliet_victor.romeo, foxtrot.juliet_alpha
  • Hash Cond: ((juliet_victor.golf_yankee)::text = (foxtrot.seven_mike)::text)
10. 0.000 0.000 ↓ 0.0

Seq Scan on bravo_foxtrot juliet_victor (cost=0.000..139.670 rows=1,467 width=6) (actual rows= loops=)

  • Output: juliet_victor.romeo, juliet_victor.juliet_alpha, juliet_victor.echo, juliet_victor.golf_five, juliet_victor.four_delta, juliet_victor.golf_uniform, juliet_victor.india, juliet_victor.sierra_seven, juliet_victor.yankee_quebec, juliet_victor.golf_yankee
11. 0.000 0.000 ↓ 0.0

Hash (cost=1.110..1.110 rows=11 width=15) (actual rows= loops=)

  • Output: foxtrot.juliet_alpha, foxtrot.seven_mike
12. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_romeo foxtrot (cost=0.000..1.110 rows=11 width=15) (actual rows= loops=)

  • Output: foxtrot.juliet_alpha, foxtrot.seven_mike