explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9tDP

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

Sort (cost=13.600..13.620 rows=9 width=180) (actual rows= loops=)

  • Sort Key: three.seven_papa
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=13.340..13.450 rows=9 width=180) (actual rows= loops=)

  • Group Key: three.lima, five.seven_zulu
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.560..13.250 rows=9 width=668) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.420..10.070 rows=9 width=151) (actual rows= loops=)

  • Join Filter: (five.lima = hotel_romeo_oscar_yankee_kilo.lima)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.150..9.460 rows=1 width=164) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on five (cost=0.000..1.260 rows=1 width=17) (actual rows= loops=)

  • Filter: (seven_oscar = 'november'::uuid)
7. 0.000 0.000 ↓ 0.0

Index Scan using hotel_delta on three (cost=0.150..8.170 rows=1 width=147) (actual rows= loops=)

  • Index Cond: (lima = five.lima)
8. 0.000 0.000 ↓ 0.0

Index Scan using mike on tango hotel_romeo_oscar_yankee_kilo (cost=0.270..0.500 rows=9 width=19) (actual rows= loops=)

  • Index Cond: (lima = three.lima)
9. 0.000 0.000 ↓ 0.0

Index Scan using charlie on zulu two (cost=0.140..0.350 rows=1 width=519) (actual rows= loops=)

  • Index Cond: (hotel_romeo_oscar_yankee_tango = hotel_romeo_oscar_yankee_kilo.hotel_romeo_oscar_yankee_tango)