explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IBsx

Settings
# exclusive inclusive rows x rows loops node
1. 18,675.728 18,675.728 ↓ 0.0 0 1

Seq Scan on contacts (cost=0.00..97,334.98 rows=530,146 width=220) (actual time=18,675.728..18,675.728 rows=0 loops=1)

  • Filter: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND ((current_setting('nimble.see_all_contacts'::text))::boolean OR ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND ((owner_id = (current_setting('nimble.user_id'::text))::bytea) OR ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && read_for_users) OR ((string_to_array(current_setting('nimble.group_ids'::text), ','::text))::bytea[] && read_for_groups)))))
  • Rows Removed by Filter: 1,193,700
Planning time : 1.871 ms
Execution time : 18,675.795 ms