explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H3Cd

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

Delete on full_flights (cost=9.42..17.48 rows=1 width=222) (actual time=23.893..23.893 rows=0 loops=1)

2. 0.001 23.891 ↓ 0.0 0 1

Nested Loop (cost=9.42..17.48 rows=1 width=222) (actual time=23.891..23.891 rows=0 loops=1)

  • Join Filter: ((full_flights.updated_at <> sub_query.most_recent_date) AND (full_flights.outbound_flight_key = sub_query.outbound_flight_key) AND (full_flights.inbound_flight_key = sub_query.inbound_flight_key))
3. 23.890 23.890 ↓ 0.0 0 1

Index Scan using fflights_7 on full_flights (cost=0.70..8.72 rows=1 width=192) (actual time=23.890..23.890 rows=0 loops=1)

  • Index Cond: ((outbound_departure_airport = 'TXL'::text) AND (outbound_arrival_airport = 'PMI'::text))
4. 0.000 0.000 ↓ 0.0 0

Subquery Scan on sub_query (cost=8.72..8.74 rows=1 width=408) (never executed)

5. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8.72..8.73 rows=1 width=186) (never executed)

  • Group Key: full_flights_1.outbound_flight_key, full_flights_1.inbound_flight_key
6. 0.000 0.000 ↓ 0.0 0

Index Scan using fflights_7 on full_flights full_flights_1 (cost=0.70..8.72 rows=1 width=186) (never executed)

  • Index Cond: ((outbound_departure_airport = 'TXL'::text) AND (outbound_arrival_airport = 'PMI'::text))
Planning time : 0.529 ms
Execution time : 23.954 ms