explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CkDq

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

Sort (cost=5,898.88..5,899.14 rows=104 width=76) (actual rows= loops=)

  • Sort Key: (count(fl.*)) DESC
2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=5,883.00..5,895.40 rows=104 width=76) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,883.00..5,891.76 rows=104 width=44) (actual rows= loops=)

  • Group Key: ((ap.airport_name ->> 'ru'::text))
4. 0.000 0.000 ↓ 0.0

Sort (cost=5,883.00..5,884.49 rows=597 width=119) (actual rows= loops=)

  • Sort Key: ((ap.airport_name ->> 'ru'::text))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.34..5,855.47 rows=597 width=119) (actual rows= loops=)

  • Hash Cond: (fl.departure_airport = ap.airport_code)
6. 0.000 0.000 ↓ 0.0

Seq Scan on flights fl (cost=0.00..5,847.00 rows=597 width=91) (actual rows= loops=)

  • Filter: (actual_departure > ('2017-08-15 18:00:00+03'::timestamp with time zone - '1 day'::interval))
7. 0.000 0.000 ↓ 0.0

Hash (cost=4.04..4.04 rows=104 width=65) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on airports_data ap (cost=0.00..4.04 rows=104 width=65) (actual rows= loops=)