1 個回答
- 最新
- 最多得票
- 最多評論
1
That is a simple catalog query that shows information about a column in a table.
SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%'
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid)
JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid)
JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid)
LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum)
JOIN (SELECT 3285788 AS oid , 2 AS attnum) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)
JOIN (SELECT 3285788 AS oid , 2 AS attnum) vals
is the critical piece here.
3285788
is the unique OID for a table (pg_class).2
is the column number for table (pg_attribute).- It is an equal join so it only retrieves data for this one column.
So the query is getting the column name, nullable, and default value if any from that particular column. If you are seeing it a lot, QuickSight might be executing this for every column.
I would expect this is being done by QuickSight in order to build queries needed for reports.
相關內容
- 已提問 6 個月前
- 已提問 10 個月前
- AWS 官方已更新 5 個月前
- AWS 官方已更新 1 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 1 年前