explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AyTL

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 2.929 ↑ 1.0 101 1

Sort (cost=1,409.08..1,409.34 rows=104 width=76) (actual time=2.923..2.929 rows=101 loops=1)

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

WindowAgg (cost=1,400.66..1,405.60 rows=104 width=76) (actual time=2.782..2.884 rows=101 loops=1)

3. 0.380 2.623 ↑ 1.0 101 1

HashAggregate (cost=1,400.66..1,401.96 rows=104 width=44) (actual time=2.594..2.623 rows=101 loops=1)

  • Group Key: (ap.airport_name ->> 'ru'::text)
4. 0.509 2.243 ↑ 1.0 541 1

Hash Join (cost=18.13..1,395.02 rows=564 width=119) (actual time=0.377..2.243 rows=541 loops=1)

  • Hash Cond: (fl.departure_airport = ap.airport_code)
5. 1.485 1.652 ↑ 1.0 541 1

Bitmap Heap Scan on flights fl (cost=12.79..1,386.73 rows=564 width=91) (actual time=0.277..1.652 rows=541 loops=1)

  • Recheck Cond: (actual_departure > ('2017-08-15 18:00:00+03'::timestamp with time zone - '1 day'::interval))
  • Heap Blocks: exact=485
6. 0.167 0.167 ↑ 1.0 541 1

Bitmap Index Scan on flight_departure_idx (cost=0.00..12.65 rows=564 width=0) (actual time=0.167..0.167 rows=541 loops=1)

  • Index Cond: (actual_departure > ('2017-08-15 18:00:00+03'::timestamp with time zone - '1 day'::interval))
7. 0.042 0.082 ↑ 1.0 104 1

Hash (cost=4.04..4.04 rows=104 width=65) (actual time=0.082..0.082 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)