explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cnsG

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 96.826 ↑ 1.0 101 1

Sort (cost=5,899.74..5,900.00 rows=104 width=76) (actual time=96.820..96.826 rows=101 loops=1)

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

WindowAgg (cost=5,883.70..5,896.25 rows=104 width=76) (actual time=96.688..96.786 rows=101 loops=1)

3. 0.135 96.635 ↑ 1.0 101 1

GroupAggregate (cost=5,883.70..5,892.61 rows=104 width=44) (actual time=96.468..96.635 rows=101 loops=1)

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

Sort (cost=5,883.70..5,885.22 rows=609 width=119) (actual time=96.459..96.500 rows=541 loops=1)

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

Hash Join (cost=5.34..5,855.53 rows=609 width=119) (actual time=0.741..95.953 rows=541 loops=1)

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

Seq Scan on flights fl (cost=0.00..5,847.00 rows=609 width=91) (actual time=0.647..95.438 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.080 ↑ 1.0 104 1

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

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

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