explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3qz

Settings
# exclusive inclusive rows x rows loops node
1. 910.896 910.896 ↑ 1.0 1,514,128 1

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

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