explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wi6C

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 92.096 ↑ 1.0 101 1

Sort (cost=5,898.88..5,899.14 rows=104 width=76) (actual time=92.091..92.096 rows=101 loops=1)

  • Sort Key: (count(fl.*)) DESC
  • Sort Method: quicksort Memory: 33kB
2. 0.180 92.026 ↑ 1.0 101 1

WindowAgg (cost=5,883.00..5,895.40 rows=104 width=76) (actual time=91.922..92.026 rows=101 loops=1)

3. 0.135 91.846 ↑ 1.0 101 1

GroupAggregate (cost=5,883.00..5,891.76 rows=104 width=44) (actual time=91.678..91.846 rows=101 loops=1)

  • Group Key: ((ap.airport_name ->> 'ru'::text))
4. 0.702 91.711 ↑ 1.1 541 1

Sort (cost=5,883.00..5,884.49 rows=597 width=119) (actual time=91.670..91.711 rows=541 loops=1)

  • Sort Key: ((ap.airport_name ->> 'ru'::text))
  • Sort Method: quicksort Memory: 128kB
5. 0.474 91.009 ↑ 1.1 541 1

Hash Join (cost=5.34..5,855.47 rows=597 width=119) (actual time=0.498..91.009 rows=541 loops=1)

  • Hash Cond: (fl.departure_airport = ap.airport_code)
6. 90.457 90.457 ↑ 1.1 541 1

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

  • Filter: (actual_departure > ('2017-08-15 18:00:00+03'::timestamp with time zone - '1 day'::interval))
  • Rows Removed by Filter: 214326
7. 0.040 0.078 ↑ 1.0 104 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
8. 0.038 0.038 ↑ 1.0 104 1

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