explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eMoR

Settings
# exclusive inclusive rows x rows loops node
1. 222.224 222.224 ↓ 0.0 0 1

Seq Scan on useraccount (cost=0.00..1,913.26 rows=536 width=1,193) (actual time=222.224..222.224 rows=0 loops=1)

  • Filter: (CASE WHEN (ice_user_territory(id) IS NULL) THEN CASE WHEN (ice_user_territory_org(id) IS NULL) THEN false ELSE (ice_user_territory(current_setting('user.id'::text)) @> ice_user_territory_org(id)) END ELSE (ice_user_territory(current_setting('user.id'::text)) @> ice_user_territory(id)) END OR (ice_get_current_setting('account.bypass'::text) = '1'::text))
  • Rows Removed by Filter: 1067