explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YFTO

Settings
# exclusive inclusive rows x rows loops node
1. 0.297 46,249.331 ↓ 1.4 789 1

Limit (cost=6,878.250..6,939.740 rows=572 width=437) (actual time=46,248.038..46,249.331 rows=789 loops=1)

2. 0.832 46,249.034 ↓ 1.4 789 1

Group (cost=6,878.250..6,939.740 rows=572 width=437) (actual time=46,248.036..46,249.034 rows=789 loops=1)

  • Group Key: (xray_yankee(charlie_xray('mike_bravo'::text, ((india_kilo."india_three")::timestamp without time zone)::timestamp with time zone), 'whiskey_three'::text)), india_kilo.kilo_alpha, (xray_yankee(charlie_xray('mike_bravo'::text, ((india_kilo.five_charlie)::timestamp without time zone)::timestamp with time zone), 'whiskey_three'::text)), india_kilo.charlie_oscar, india_kilo.three_victor, india_kilo.november_tango, india_kilo.charlie_papa, india_kilo.oscar, india_kilo.tango_six, india_kilo.november_xray, india_kilo.two_zulu, india_kilo.hotel_juliet, india_kilo.echo_papa, india_kilo.five_bravo, india_kilo.uniform_india, india_kilo.delta, india_kilo.juliet, india_kilo.whiskey_golf, india_kilo.hotel_echo, india_kilo.six_mike, india_kilo.six_two, (lima((india_kilo.bravo)::text, india_kilo.two_lima)), india_kilo.tango_quebec, india_kilo.echo_xray, india_kilo.five_oscar, (lima((india_kilo.golf)::integer, (india_kilo.mike_echo)::integer)), india_kilo.kilo_oscar
3. 7.386 46,248.202 ↓ 1.4 794 1

Sort (cost=6,878.250..6,879.680 rows=572 width=437) (actual time=46,248.033..46,248.202 rows=794 loops=1)

  • Sort Key: (xray_yankee(charlie_xray('mike_bravo'::text, ((india_kilo."india_three")::timestamp without time zone)::timestamp with time zone), 'whiskey_three'::text)), india_kilo.kilo_alpha, (xray_yankee(charlie_xray('mike_bravo'::text, ((india_kilo.five_charlie)::timestamp without time zone)::timestamp with time zone), 'whiskey_three'::text)), india_kilo.charlie_oscar, india_kilo.three_victor, india_kilo.november_tango, india_kilo.charlie_papa, india_kilo.oscar, india_kilo.tango_six, india_kilo.november_xray, india_kilo.two_zulu, india_kilo.hotel_juliet, india_kilo.echo_papa, india_kilo.five_bravo, india_kilo.uniform_india, india_kilo.delta, india_kilo.juliet, india_kilo.whiskey_golf, india_kilo.hotel_echo, india_kilo.six_mike, india_kilo.six_two, (lima((india_kilo.bravo)::text, india_kilo.two_lima)), india_kilo.tango_quebec, india_kilo.echo_xray, india_kilo.five_oscar, (lima((india_kilo.golf)::integer, (india_kilo.mike_echo)::integer)), india_kilo.kilo_oscar
  • Sort Method: quicksort Memory: 254kB
4. 32.604 46,240.816 ↓ 1.4 794 1

Nested Loop (cost=0.560..6,852.050 rows=572 width=437) (actual time=0.426..46,240.816 rows=794 loops=1)

5. 46,194.714 46,194.714 ↓ 1.4 794 1

Index Scan using three_hotel on india_kilo (cost=0.560..2,318.560 rows=572 width=477) (actual time=0.023..46,194.714 rows=794 loops=1)

  • Index Cond: (zulu = 'quebec'::text)
6. 0.955 13.498 ↑ 1.0 1 794

Materialize (cost=0.000..4,504.890 rows=1 width=37) (actual time=0.001..0.017 rows=1 loops=794)

7. 12.543 12.543 ↑ 1.0 1 1

Seq Scan on five_hotel xray_two (cost=0.000..4,504.890 rows=1 width=37) (actual time=0.370..12.543 rows=1 loops=1)

  • Filter: (uniform_four = 'quebec'::text)
  • Rows Removed by Filter: 84710
Planning time : 0.428 ms
Execution time : 46,249.623 ms