explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vVRg

Settings
# exclusive inclusive rows x rows loops node
1. 567.423 42,087.746 ↓ 1.0 4,693,321 1

Result (cost=0.56..117,051,523.58 rows=4,675,587 width=26) (actual time=6,940.196..42,087.746 rows=4,693,321 loops=1)

  • One-Time Filter: ((current_setting('nimble.company_id'::text))::bytea = '\x4c2118ad54397f271b000000'::bytea)
2. 15,810.070 41,520.323 ↓ 1.0 4,693,321 1

Index Only Scan using contacts_tags_associations_pkey on contacts_tags_associations (cost=0.56..117,051,523.58 rows=4,675,587 width=26) (actual time=6,940.193..41,520.323 rows=4,693,321 loops=1)

  • Index Cond: (company_id = '\x4c2118ad54397f271b000000'::bytea)
  • Filter: ((SubPlan 1) OR (alternatives: SubPlan 2 or hashed SubPlan 3) OR (alternatives: SubPlan 4 or hashed SubPlan 5) OR (SubPlan 6) OR (alternatives: SubPlan 7 or hashed SubPlan 8) OR (SubPlan 9) OR (alternatives: SubPlan 10 or hashed SubPlan 11) OR (SubPlan 12) OR (alternatives: SubPlan 13 or hashed SubPlan 14))
  • Rows Removed by Filter: 20,308
  • Heap Fetches: 4,713,629
3.          

SubPlan (for Index Only Scan)

4. 18,854.516 18,854.516 ↑ 1.0 1 4,713,629

Index Scan using contacts_pkey on contacts (cost=0.44..2.77 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=4,713,629)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • Filter: ((read_for_users IS NULL) AND ((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: 0
5. 0.000 0.000 ↓ 0.0 0

Index Scan using contacts_pkey on contacts contacts_1 (cost=0.44..2.78 rows=1 width=0) (never executed)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • 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))) AND ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && read_for_users))
6. 153.084 1,555.690 ↓ 0.0 0 1

Gather (cost=28,296.60..110,953.52 rows=5,245 width=13) (actual time=1,551.929..1,555.690 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 1,337.136 1,402.606 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on contacts contacts_2 (cost=8,296.60..90,429.02 rows=2,185 width=13) (actual time=1,402.606..1,402.606 rows=0 loops=3)

  • Recheck Cond: (company_id = (current_setting('nimble.company_id'::text))::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))) AND ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && read_for_users))
  • Rows Removed by Filter: 350,723
  • Heap Blocks: exact=6,210
8. 65.470 65.470 ↓ 1.0 1,052,168 1 / 3

Bitmap Index Scan on ix_rls_permissions (cost=0.00..8,295.29 rows=1,048,984 width=0) (actual time=196.409..196.409 rows=1,052,168 loops=1)

  • Index Cond: (company_id = (current_setting('nimble.company_id'::text))::bytea)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using contacts_pkey on contacts contacts_3 (cost=0.44..2.77 rows=1 width=0) (never executed)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • Filter: ((owner_id = (current_setting('nimble.user_id'::text))::bytea) AND ((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))))
10. 8.502 8.502 ↓ 0.0 0 1

Index Scan using ix_company_id_owner_id on contacts contacts_4 (cost=0.44..18.60 rows=26 width=13) (actual time=8.502..8.502 rows=0 loops=1)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (owner_id = (current_setting('nimble.user_id'::text))::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)))
11. 193.090 193.090 ↓ 0.0 0 38,618

Index Scan using contacts_pkey on contacts contacts_5 (cost=0.44..2.77 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=38,618)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • Filter: ((read_for_groups IS NULL) AND ((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: 1
12. 0.000 0.000 ↓ 0.0 0

Index Scan using contacts_pkey on contacts contacts_6 (cost=0.44..2.78 rows=1 width=0) (never executed)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • 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))) AND ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && read_for_groups))
13. 198.451 1,599.216 ↓ 0.0 0 1

Gather (cost=28,296.60..110,953.52 rows=5,245 width=13) (actual time=1,596.356..1,599.216 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
14. 1,356.449 1,400.765 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on contacts contacts_7 (cost=8,296.60..90,429.02 rows=2,185 width=13) (actual time=1,400.765..1,400.765 rows=0 loops=3)

  • Recheck Cond: (company_id = (current_setting('nimble.company_id'::text))::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))) AND ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && read_for_groups))
  • Rows Removed by Filter: 350,723
  • Heap Blocks: exact=6,647
15. 44.316 44.316 ↓ 1.0 1,052,168 1 / 3

Bitmap Index Scan on ix_rls_permissions (cost=0.00..8,295.29 rows=1,048,984 width=0) (actual time=132.949..132.949 rows=1,052,168 loops=1)

  • Index Cond: (company_id = (current_setting('nimble.company_id'::text))::bytea)
16. 81.232 81.232 ↓ 0.0 0 20,308

Index Scan using contacts_pkey on contacts contacts_8 (cost=0.44..2.77 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=20,308)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • Filter: ((edit_for_users IS NULL) AND ((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: 1
17. 0.000 0.000 ↓ 0.0 0

Index Scan using contacts_pkey on contacts contacts_9 (cost=0.44..2.78 rows=1 width=0) (never executed)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • 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))) AND ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && edit_for_users))
18. 193.974 1,672.649 ↓ 0.0 0 1

Gather (cost=28,296.60..110,953.52 rows=5,245 width=13) (actual time=1,668.752..1,672.649 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
19. 1,409.891 1,478.675 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on contacts contacts_10 (cost=8,296.60..90,429.02 rows=2,185 width=13) (actual time=1,478.675..1,478.675 rows=0 loops=3)

  • Recheck Cond: (company_id = (current_setting('nimble.company_id'::text))::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))) AND ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && edit_for_users))
  • Rows Removed by Filter: 350,723
  • Heap Blocks: exact=6,009
20. 68.784 68.784 ↓ 1.0 1,052,168 1 / 3

Bitmap Index Scan on ix_rls_permissions (cost=0.00..8,295.29 rows=1,048,984 width=0) (actual time=206.351..206.351 rows=1,052,168 loops=1)

  • Index Cond: (company_id = (current_setting('nimble.company_id'::text))::bytea)
21. 81.232 81.232 ↓ 0.0 0 20,308

Index Scan using contacts_pkey on contacts contacts_11 (cost=0.44..2.77 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=20,308)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • Filter: ((edit_for_groups IS NULL) AND ((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: 1
22. 0.000 0.000 ↓ 0.0 0

Index Scan using contacts_pkey on contacts contacts_12 (cost=0.44..2.78 rows=1 width=0) (never executed)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (contacts_tags_associations.contact_id = id))
  • 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))) AND ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && edit_for_groups))
23. 189.850 1,664.126 ↓ 0.0 0 1

Gather (cost=28,296.60..110,953.52 rows=5,245 width=13) (actual time=1,660.648..1,664.126 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
24. 1,409.112 1,474.276 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on contacts contacts_13 (cost=8,296.60..90,429.02 rows=2,185 width=13) (actual time=1,474.276..1,474.276 rows=0 loops=3)

  • Recheck Cond: (company_id = (current_setting('nimble.company_id'::text))::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))) AND ((string_to_array(current_setting('nimble.user_id'::text), ','::text))::bytea[] && edit_for_groups))
  • Rows Removed by Filter: 350,723
  • Heap Blocks: exact=6,192
25. 65.164 65.164 ↓ 1.0 1,052,168 1 / 3

Bitmap Index Scan on ix_rls_permissions (cost=0.00..8,295.29 rows=1,048,984 width=0) (actual time=195.493..195.493 rows=1,052,168 loops=1)

  • Index Cond: (company_id = (current_setting('nimble.company_id'::text))::bytea)
Planning time : 5.121 ms
Execution time : 42,322.153 ms