explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3kGE

Settings
# exclusive inclusive rows x rows loops node
1. 5,525.467 5,624.988 ↓ 0.0 0 1

Bitmap Heap Scan on contacts (cost=8,452.86..96,710.78 rows=530,861 width=220) (actual time=5,624.988..5,624.988 rows=0 loops=1)

  • Recheck Cond: (company_id = '\x4c2118ad54397f271b000000'::bytea)
  • Filter: ((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,052,168
  • Heap Blocks: exact=18,009
2. 99.521 99.521 ↑ 1.0 1,052,168 1

Bitmap Index Scan on ix_rls_permissions (cost=0.00..8,320.14 rows=1,052,445 width=0) (actual time=99.521..99.521 rows=1,052,168 loops=1)

  • Index Cond: (company_id = '\x4c2118ad54397f271b000000'::bytea)
Planning time : 0.307 ms
Execution time : 5,625.379 ms