explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3nAE

Settings
# exclusive inclusive rows x rows loops node
1. 392.691 875.187 ↑ 142,754.0 2 1

Hash Join (cost=109,280.29..202,110.91 rows=285,508 width=14) (actual time=522.316..875.187 rows=2 loops=1)

2. 272.356 272.356 ↑ 1.0 2,949,857 1

Seq Scan on tickets t (cost=0..78,913.57 rows=2,949,857 width=14) (actual time=0.006..272.356 rows=2,949,857 loops=1)

3. 0.007 210.140 ↑ 142,754.0 2 1

Hash (cost=105,711.44..105,711.44 rows=285,508 width=14) (actual time=210.14..210.14 rows=2 loops=1)

4. 78.479 210.133 ↑ 142,754.0 2 1

Hash Join (cost=6,237.53..105,711.44 rows=285,508 width=14) (actual time=57.691..210.133 rows=2 loops=1)

5. 124.259 124.259 ↓ 1.0 859,656 1

Index Scan using idx_fare_confitions on ticket_flights tf (cost=0.43..97,225.92 rows=856,528 width=18) (actual time=0.013..124.259 rows=859,656 loops=1)

  • Index Cond: ((fare_conditions)::text = 'Business'::text)
6. 0.006 7.395 ↑ 71,622.0 1 1

Hash (cost=5,341.82..5,341.82 rows=71,622 width=4) (actual time=7.394..7.395 rows=1 loops=1)

7. 7.384 7.389 ↑ 71,622.0 1 1

Bitmap Heap Scan on flights f (cost=1,643.49..5,341.82 rows=71,622 width=4) (actual time=7.386..7.389 rows=1 loops=1)

  • Heap Blocks: exact=1
8. 0.005 0.005 ↑ 71,622.0 1 1

Bitmap Index Scan on idx_schedule2 (cost=0..1,625.59 rows=71,622 width=0) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: ((actual_departure - scheduled_departure) > '05:00:00'::interval)
Planning time : 0.344 ms
Execution time : 876.525 ms