| Nested Loop Left Join (cost=0.41..261.69 rows=2 width=63) |
| Join Filter: (((nc.nspname)::information_schema.sql_identifier)::text = (e.schema_id)::text) |
| -> Nested Loop Left Join (cost=0.41..260.62 rows=2 width=64) |
| -> Nested Loop (cost=0.00..243.69 rows=2 width=68) |
| Join Filter: (nc.oid = c.relnamespace) |
| -> Seq Scan on pg_namespace nc (cost=0.00..1.10 rows=5 width=68) |
| Filter: (NOT pg_is_other_temp_schema(oid)) |
| -> Materialize (cost=0.00..242.38 rows=3 width=8) |
| -> Seq Scan on pg_class c (cost=0.00..242.36 rows=3 width=8) |
| Filter: ((relkind = ANY ('{r,v,f,p}'::"char"[])) AND (((relname)::information_schema.sql_identifier)::text = 'tbl_clients'::text) AND (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(oid, 'SELECT, INSERT, UPDATE, REFERENCES'::text))) |
| -> Nested Loop (cost=0.41..8.46 rows=1 width=4) |
| -> Index Scan using pg_type_oid_index on pg_type t (cost=0.28..8.30 rows=1 width=8) |
| Index Cond: (c.reloftype = oid) |
| -> Index Only Scan using pg_namespace_oid_index on pg_namespace nt (cost=0.13..0.15 rows=1 width=4) |
| Index Cond: (oid = t.typnamespace) |
| -> Materialize (cost=0.00..1.01 rows=1 width=46) |
| -> Seq Scan on tbl_enterprises e (cost=0.00..1.01 rows=1 width=46) |