explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NC31

Settings
# exclusive inclusive rows x rows loops node
1. 0.822 0.822 ↑ 1.0 3 1

Seq Scan on programstage ps (cost=0.00..2.39 rows=3 width=17) (actual time=0.179..0.822 rows=3 loops=1)

  • Filter: (((publicaccess)::text ~~ '__r%'::text) OR (publicaccess IS NULL))
  • Rows Removed by Filter: 28
Planning time : 11.467 ms
Execution time : 0.894 ms