explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bN4o

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

ProjectSet (cost=6.31..245.47 rows=1,000 width=245) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on hierarchy_entity h (cost=6.31..240.22 rows=1 width=450) (actual rows= loops=)

  • Recheck Cond: (org_id = (current_setting('jwt.claims.org_id'::text, true))::integer)
  • Filter: (((((((((current_setting('jwt.claims.data'::text, true))::json -> 'permission'::text) -> 'access'::text) -> 'hierarchy_entity'::text))::text)::integer IS NULL) OR ((((((((current_setting('jwt.claims.data'::text, true))::json -> 'permission'::text) -> 'access'::text) -> 'hierarchy_entity'::text))::text)::integer & 1) = 1)) AND ((((((((current_setting('jwt.claims.data'::text, true))::json -> 'permission'::text) -> 'access'::text) -> 'all'::text))::text)::integer IS NULL) OR ((((((((current_setting('jwt.claims.data'::text, true))::json -> 'permission'::text) -> 'access'::text) -> 'all'::text))::text)::integer & 1) = 1)) AND teacher_hierarchy_access(h.*, ((current_setting('jwt.claims.data'::text, true))::jsonb -> 'properties'::text)))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hierarchy_entity_org_id_level_index (cost=0.00..6.31 rows=269 width=0) (actual rows= loops=)

  • Index Cond: (org_id = (current_setting('jwt.claims.org_id'::text, true))::integer)