explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pcVy

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

Sort (cost=32.120..32.130 rows=1 width=137) (actual rows= loops=)

  • Sort Key: seven.quebec, yankee.hotel DESC
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.040..32.110 rows=1 width=137) (actual rows= loops=)

  • -> Index Scan using bs_room_pub_matchday_pk on bs_room_pub_matchday tb (cost=0.28..5.46 rows=1 width=50)' Index Cond: ((cf_tourid = '1'::numeric) AND (cf_roomid = ts.cf_roomid) AND (cf_tour_matchdayid = '2359'::numeric))'
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.770..26.190 rows=1 width=140) (actual rows= loops=)

  • Join Filter: ((kilo_hotel.four_charlie = india.four_charlie) AND (yankee.echo = india.echo) AND (yankee.quebec = india.quebec))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.490..23.590 rows=1 width=216) (actual rows= loops=)

  • Join Filter: (yankee.echo = (two.echo)::numeric)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.220..12.650 rows=1 width=195) (actual rows= loops=)

  • Hash Cond: (kilo_hotel.four_charlie = yankee.four_charlie)
6. 0.000 0.000 ↓ 0.0

Seq Scan on mike kilo_hotel (cost=0.000..1.310 rows=31 width=35) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=11.210..11.210 rows=1 width=160) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Append (cost=0.000..11.210 rows=1 width=160) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on golf_four yankee (cost=0.000..11.200 rows=1 width=160) (actual rows= loops=)

  • Filter: ((lima = 'kilo_golf'::numeric) AND (whiskey = 'four_uniform'::numeric))
10. 0.000 0.000 ↓ 0.0

Index Scan using four_victor on charlie two (cost=0.280..10.920 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ((four_charlie = kilo_hotel.four_charlie) AND (lima = 'kilo_golf'::numeric) AND (whiskey = 'four_uniform'::numeric))
11. 0.000 0.000 ↓ 0.0

Index Scan using four_two on golf_two india (cost=0.280..2.590 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ((echo = (two.echo)::numeric) AND (lima = 'kilo_golf'::numeric) AND (whiskey = 'four_uniform'::numeric))
  • Filter: (two.four_charlie = four_charlie)