explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TYJz

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.023 ↓ 0.0 0 1

Delete on contacts (cost=0.44..2.75 rows=1 width=6) (actual time=0.023..0.023 rows=0 loops=1)

2. 0.022 0.022 ↓ 0.0 0 1

Index Scan using contacts_pkey on contacts (cost=0.44..2.75 rows=1 width=6) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: ((company_id = (current_setting('nimble.company_id'::text))::bytea) AND (id = '\x56b1303eb2a6bd497256f7f1'::bytea))
  • Filter: ((((owner_id IS NOT NULL) AND (owner_id = (current_setting('nimble.user_id'::text))::bytea)) OR (edit_for_users && '{""\\x00""}'::bytea[]) OR (edit_for_users && ARRAY[(current_setting('nimble.user_id'::text))::bytea]) OR (edit_for_groups && (string_to_array(current_setting('nimble.group_ids'::text), ','::text))::bytea[])) AND (((owner_id IS NOT NULL) AND (owner_id = (current_setting('nimble.user_id'::text))::bytea)) OR (read_for_users && '{""\\x00""}'::bytea[]) OR (read_for_users && ARRAY[(current_setting('nimble.user_id'::text))::bytea]) OR (read_for_groups && (string_to_array(current_setting('nimble.group_ids'::text), ','::text))::bytea[]) OR (edit_for_users && ARRAY[(current_setting('nimble.user_id'::text))::bytea]) OR (edit_for_groups && (string_to_array(current_setting('nimble.group_ids'::text), ','::text))::bytea[])))
Planning time : 0.492 ms
Execution time : 0.091 ms