explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cwFb

Settings
# exclusive inclusive rows x rows loops node
1. 150.035 4,359.792 ↓ 2.2 122,062 1

GroupAggregate (cost=2,189,514.39..2,195,721.39 rows=56,428 width=186) (actual time=3,508.161..4,359.792 rows=122,062 loops=1)

  • Group Key: outbound_flight_key, inbound_flight_key
2. 3,915.439 4,209.757 ↑ 2.8 203,437 1

Sort (cost=2,189,514.39..2,190,925.07 rows=564,272 width=186) (actual time=3,508.149..4,209.757 rows=203,437 loops=1)

  • Sort Key: outbound_flight_key, inbound_flight_key
  • Sort Method: external merge Disk: 36,544kB
3. 294.318 294.318 ↑ 2.8 203,437 1

Index Only Scan using fflights_9 on full_flights (cost=0.95..2,031,456.39 rows=564,272 width=186) (actual time=0.024..294.318 rows=203,437 loops=1)

  • Index Cond: (outbound_departure_airport = 'PAD'::text)
  • Heap Fetches: 203,437
Planning time : 0.118 ms
Execution time : 4,389.780 ms