explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hL7j

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 18.272 ↑ 1.0 1 1

Aggregate (cost=64.76..64.77 rows=1 width=8) (actual time=18.272..18.272 rows=1 loops=1)

2. 18.269 18.269 ↓ 0.0 0 1

Index Scan using ix_company_id_owner_id on contacts (cost=0.43..64.51 rows=98 width=0) (actual time=18.269..18.269 rows=0 loops=1)

  • Index Cond: (company_id = '\x50613a5da3815e1953543666'::bytea)
  • Filter: ((read_for_users IS NULL) OR (((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && read_for_users) AND (company_id = (current_setting('nimble.company_id'::text))::bytea)) OR (read_for_groups IS NULL) OR (((string_to_array(current_setting('nimble.group_ids'::text), ','::text))::bytea[] && read_for_groups) AND (company_id = (current_setting('nimble.company_id'::text))::bytea)) OR ((owner_id = (current_setting('nimble.user_id'::text))::bytea) AND (company_id = (current_setting('nimble.company_id'::text))::bytea)) OR (edit_for_users IS NULL) OR (((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && edit_for_users) AND (company_id = (current_setting('nimble.company_id'::text))::bytea)) OR (edit_for_groups IS NULL) OR (((string_to_array(current_setting('nimble.group_ids'::text), ','::text))::bytea[] && edit_for_groups) AND (company_id = (current_setting('nimble.company_id'::text))::bytea)))
  • Rows Removed by Filter: 2,360
Planning time : 0.254 ms
Execution time : 18.328 ms