| Nested Loop Left Join (cost=0.42..1957.65 rows=6 width=306) |
| Join Filter: (((nc.nspname)::information_schema.sql_identifier)::text = (e.schema_id)::text) |
| -> Nested Loop Left Join (cost=0.42..1955.68 rows=6 width=64) |
| -> Nested Loop (cost=0.00..1906.20 rows=6 width=68) |
| Join Filter: (nc.oid = c.relnamespace) |
| -> Seq Scan on pg_class c (cost=0.00..1903.79 rows=18 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))) |
| -> Materialize (cost=0.00..1.12 rows=5 width=68) |
| -> Seq Scan on pg_namespace nc (cost=0.00..1.10 rows=5 width=68) |
| Filter: (NOT pg_is_other_temp_schema(oid)) |
| -> Nested Loop (cost=0.42..8.24 rows=1 width=4) |
| -> Index Scan using pg_type_oid_index on pg_type t (cost=0.29..8.08 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.12 rows=8 width=324) |
| -> Seq Scan on tbl_enterprises e (cost=0.00..1.08 rows=8 width=324) |