explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w6sG

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2.101 ↓ 0.0 0 1

Delete on full_flights (cost=13.69..21.76 rows=1 width=222) (actual time=2.101..2.101 rows=0 loops=1)

2. 0.002 2.099 ↓ 0.0 0 1

Nested Loop (cost=13.69..21.76 rows=1 width=222) (actual time=2.099..2.099 rows=0 loops=1)

3. 0.001 2.097 ↓ 0.0 0 1

Subquery Scan on sub_query (cost=12.75..12.77 rows=1 width=408) (actual time=2.097..2.097 rows=0 loops=1)

4. 0.002 2.096 ↓ 0.0 0 1

HashAggregate (cost=12.75..12.76 rows=1 width=186) (actual time=2.096..2.096 rows=0 loops=1)

  • Group Key: full_flights_1.outbound_flight_key, full_flights_1.inbound_flight_key
5. 2.094 2.094 ↓ 0.0 0 1

Index Scan using fflights_7 on full_flights full_flights_1 (cost=0.70..12.73 rows=2 width=186) (actual time=2.094..2.094 rows=0 loops=1)

  • Index Cond: (outbound_departure_airport = 'TXL'::text)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using full_flights_big_index on full_flights (cost=0.95..8.98 rows=1 width=192) (never executed)

  • Index Cond: ((outbound_departure_airport = 'TXL'::text) AND (outbound_flight_key = sub_query.outbound_flight_key) AND (inbound_flight_key = sub_query.inbound_flight_key))
  • Filter: (updated_at <> sub_query.most_recent_date)
Planning time : 0.553 ms
Execution time : 2.166 ms