explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HdU5 : Optimization for: plan #PiHV

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 373.079 15,943.067 ↓ 1.3 397,524 1

GroupAggregate (cost=276,745.93..293,622.04 rows=303,757 width=22) (actual time=12,069.228..15,943.067 rows=397,524 loops=1)

  • Group Key: ticketno
  • Filter: (max(departuredate) < (now() - '5 days'::interval))
  • Rows Removed by Filter: 76102
2. 14,578.096 15,569.988 ↑ 1.0 1,514,128 1

Sort (cost=276,745.93..280,599.39 rows=1,541,382 width=22) (actual time=12,069.209..15,569.988 rows=1,514,128 loops=1)

  • Sort Key: ticketno
  • Sort Method: external merge Disk: 50256kB
3. 991.892 991.892 ↑ 1.0 1,514,128 1

Seq Scan on gdsticketcoupon (cost=0.00..86,712.29 rows=1,541,382 width=22) (actual time=0.007..991.892 rows=1,514,128 loops=1)

  • Filter: ((couponstatus)::text = ANY ('{AirportControl,OriginalIssue,Suspended,NotAvailable}'::text[]))
  • Rows Removed by Filter: 957091