explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ybqF

Settings
# exclusive inclusive rows x rows loops node
1. 1,231.999 1,231.999 ↑ 1.1 980,697 1

Seq Scan on files (cost=0.00..396,360.68 rows=1,037,020 width=546) (actual time=0.007..1,231.999 rows=980,697 loops=1)

  • Filter: (status <> ALL ('{1,2,7}'::integer[]))
  • Rows Removed by Filter: 3820694
Planning time : 0.059 ms
Execution time : 1,267.685 ms