explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jacD

Settings
# exclusive inclusive rows x rows loops node
1. 99,725.008 99,725.008 ↑ 768.0 4 1

Seq Scan on business_objects business_objects_alias (cost=0.00..896,776.94 rows=3,072 width=85) (actual time=43,194.731..99,725.008 rows=4 loops=1)

  • Filter: ((synonyms @> '{what}'::text[]) OR (lower((value)::text) ~~ '% what %'::text) OR (lower((label)::text) ~~ '% what %'::text) OR (lower((value)::text) = 'what'::text) OR (lower((label)::text) = 'what'::text))
  • Rows Removed by Filter: 22435931