Под капотом Чтобы видеть какие запросы формируются для метакоманд psql, надо выполнить psql -E : To see what queries are generated for psql meta-commands, you need to run psql -E : $ psql -E postgres postgres=# \dE gp_toolkit. QUERY select pg_catalog.version() * QUERY SELECT n.nspname as "Schema", c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' END as "Type", pg_catalog.pg_get_userbyid(c.relowner) as "Owner" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r','s','f','') AND c.relstorage IN ('x','f','') AND n.nspname !~ '^pg_toast' AND n.nspname OPERATOR(pg_catalog.~) '^(gp_toolkit)$' ORDER BY 1,2; List of relations Schema | Name | Type | Owner ------------+----------------------+-------+--------- gp_toolkit | __gp_log_master_ext | table | gpadmin gp_toolkit | __gp_log_segment_ext | table | gpadmin gp_toolkit | gp_disk_free | table | gpadmin (3 rows)