pg_slow
application/octet-stream
Oct 23 08:16:03 pg_ctl[1958363]: 2023-10-23 08:16:03.845 EDT [1958363] LOG: execute <unnamed>: SELECT count(*)
Oct 23 08:16:03 pg_ctl[1958363]: FROM public.ncvoter_2022_12_03
Oct 23 08:16:03 pg_ctl[1958363]:
Oct 23 08:16:05 pg_ctl[1958363]: 2023-10-23 08:16:05.318 EDT [1958363] LOG: execute <unnamed>: SELECT result.TABLE_CAT, result.TABLE_SCHEM, result.TABLE_NAME, result.COLUMN_NAME, result.KEY_SEQ, result.PK_NAME FROM (SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (information_schema._pg_expandarray(i.indkey)).n AS KEY_SEQ, ci.relname AS PK_NAME, information_schema._pg_expandarray(i.indkey) AS KEYS, a.attnum AS A_ATTNUM FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN pg_catalog.pg_index i ON ( a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true AND n.nspname = 'public' AND ct.relname = 'ncvoter_2022_12_03' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq
Oct 23 08:16:05 pg_ctl[1958363]: 2023-10-23 08:16:05.319 EDT [1958363] LOG: execute <unnamed>: SELECT * FROM (SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen,t.typtypmod,row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif(a.attidentity, '') as attidentity,nullif(a.attgenerated, '') as attgenerated,pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE c.relkind in ('r','p','v','f','m') and a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'ncvoter\_2022\_12\_03') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum
Oct 23 08:16:05 pg_ctl[1958363]: 2023-10-23 08:16:05.320 EDT [1958363] LOG: execute S_1: select att.attname,
Oct 23 08:16:05 pg_ctl[1958363]: col.collcollate,
Oct 23 08:16:05 pg_ctl[1958363]: case
Oct 23 08:16:05 pg_ctl[1958363]: when att.attlen = -1 then att.attstorage
Oct 23 08:16:05 pg_ctl[1958363]: else null
Oct 23 08:16:05 pg_ctl[1958363]: end as attstorage,
Oct 23 08:16:05 pg_ctl[1958363]: att.atttypmod,
Oct 23 08:16:05 pg_ctl[1958363]: att.attinhcount,
Oct 23 08:16:05 pg_ctl[1958363]: att.attndims,
Oct 23 08:16:05 pg_ctl[1958363]: att.atthasdef,
Oct 23 08:16:05 pg_ctl[1958363]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type,
Oct 23 08:16:05 pg_ctl[1958363]: nullif(att.attidentity, '') as attidentity,
Oct 23 08:16:05 pg_ctl[1958363]: pg_get_expr(d.adbin, d.adrelid) as generated_expr,
Oct 23 08:16:05 pg_ctl[1958363]: att.attgenerated as attgenerated,
Oct 23 08:16:05 pg_ctl[1958363]: att.attcompression as attcompression
Oct 23 08:16:05 pg_ctl[1958363]: from pg_catalog.pg_attribute att
Oct 23 08:16:05 pg_ctl[1958363]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid
Oct 23 08:16:05 pg_ctl[1958363]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid
Oct 23 08:16:05 pg_ctl[1958363]: left join pg_catalog.pg_collation col on att.attcollation = col.oid
Oct 23 08:16:05 pg_ctl[1958363]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum
Oct 23 08:16:05 pg_ctl[1958363]: where tbl.relname = $1
Oct 23 08:16:05 pg_ctl[1958363]: and ns.nspname = $2
Oct 23 08:16:05 pg_ctl[1958363]: and not att.attisdropped
Oct 23 08:16:05 pg_ctl[1958363]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid')
Oct 23 08:16:05 pg_ctl[1958363]: 2023-10-23 08:16:05.320 EDT [1958363] DETAIL: parameters: $1 = 'ncvoter_2022_12_03', $2 = 'public'
Oct 23 08:16:05 pg_ctl[1958363]: 2023-10-23 08:16:05.321 EDT [1958363] LOG: execute <unnamed>: SELECT county_id,
Oct 23 08:16:05 pg_ctl[1958363]: county_desc,
#
# smipped column names to reduce visual clutter
#
Oct 23 08:16:05 pg_ctl[1958363]: vtd_desc
Oct 23 08:16:05 pg_ctl[1958363]: FROM public.ncvoter_2022_12_03
Oct 23 08:16:05 pg_ctl[1958363]: LIMIT 10
Oct 23 08:16:05 pg_ctl[1958363]: 2023-10-23 08:16:05.324 EDT [1958363] LOG: execute <unnamed>: SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 40039 AS oid , 1 AS attnum UNION ALL SELECT 40039, 2 UNION ALL SELECT 40039, 3 UNION ALL SELECT 40039, 4 UNION ALL SELECT 40039, 5 UNION ALL SELECT 40039, 6 UNION ALL SELECT 40039, 7 UNION ALL SELECT 40039, 8 UNION ALL SELECT 40039, 9 UNION ALL SELECT 40039, 10 UNION ALL SELECT 40039, 11 UNION ALL SELECT 40039, 12 UNION ALL SELECT 40039, 13 UNION ALL SELECT 40039, 14 UNION ALL SELECT 40039, 15 UNION ALL SELECT 40039, 16 UNION ALL SELECT 40039, 17 UNION ALL SELECT 40039, 18 UNION ALL SELECT 40039, 19 UNION ALL SELECT 40039, 20 UNION ALL SELECT 40039, 21 UNION ALL SELECT 40039, 22 UNION ALL SELECT 40039, 23 UNION ALL SELECT 40039, 24 UNION ALL SELECT 40039, 25 UNION ALL SELECT 40039, 26 UNION ALL SELECT 40039, 27 UNION ALL SELECT 40039, 28 UNION ALL SELECT 40039, 29 UNION ALL SELECT 40039, 30 UNION ALL SELECT 40039, 31 UNION ALL SELECT 40039, 32 UNION ALL SELECT 40039, 33 UNION ALL SELECT 40039, 34 UNION ALL SELECT 40039, 35 UNION ALL SELECT 40039, 36 UNION ALL SELECT 40039, 37 UNION ALL SELECT 40039, 38 UNION ALL SELECT 40039, 39 UNION ALL SELECT 40039, 40 UNION ALL SELECT 40039, 41 UNION ALL SELECT 40039, 42 UNION ALL SELECT 40039, 43 UNION ALL SELECT 40039, 44 UNION ALL SELECT 40039, 45 UNION ALL SELECT 40039, 46 UNION ALL SELECT 40039, 47 UNION ALL SELECT 40039, 48 UNION ALL SELECT 40039, 49 UNION ALL SELECT 40039, 50 UNION ALL SELECT 40039, 51 UNION ALL SELECT 40039, 52 UNION ALL SELECT 40039, 53 UNION ALL SELECT 40039, 54 UNION ALL SELECT 40039, 55 UNION ALL SELECT 40039, 56 UNION ALL SELECT 40039, 57 UNION ALL SELECT 40039, 58 UNION ALL SELECT 40039, 59 UNION ALL SELECT 40039, 60 UNION ALL SELECT 40039, 61 UNION ALL SELECT 40039, 62 UNION ALL SELECT 40039, 63 UNION ALL SELECT 40039, 64 UNION ALL SELECT 40039, 65 UNION ALL SELECT 40039, 66 UNION ALL SELECT 40039, 67) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)
#
# The next entry is SQL-workbench/J keeping the connection alive:
#
# The above only took 2 seconds to display from a 8,322,235 row table
#
Oct 23 08:16:18 pg_ctl[1931492]: 2023-10-23 08:16:18.768 EDT [1931492] LOG: execute <unnamed>: Select 1
#######################################################
#
# arrow down to another table
#
Oct 23 08:16:38 pg_ctl[1958363]: 2023-10-23 08:16:38.206 EDT [1958363] LOG: execute <unnamed>: SELECT count(*)
Oct 23 08:16:38 pg_ctl[1958363]: FROM public.ncvoter_2022_12_10
Oct 23 08:16:38 pg_ctl[1958363]:
#
# 30 second delay
#
Oct 23 08:17:18 pg_ctl[1931492]: 2023-10-23 08:17:18.773 EDT [1931492] LOG: execute <unnamed>: Select 1
#
# another 8 seconds
#
Oct 23 08:17:26 systemd[1]: NetworkManager.service: start operation timed out. Terminating.
#
# 14 seconds
#
Oct 23 08:17:40 pg_ctl[1958363]: 2023-10-23 08:17:40.339 EDT [1958363] LOG: execute <unnamed>: SELECT result.TABLE_CAT, result.TABLE_SCHEM, result.TABLE_NAME, result.COLUMN_NAME, result.KEY_SEQ, result.PK_NAME FROM (SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (information_schema._pg_expandarray(i.indkey)).n AS KEY_SEQ, ci.relname AS PK_NAME, information_schema._pg_expandarray(i.indkey) AS KEYS, a.attnum AS A_ATTNUM FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN pg_catalog.pg_index i ON ( a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true AND n.nspname = 'public' AND ct.relname = 'ncvoter_2022_12_10' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq
Oct 23 08:17:40 pg_ctl[1958363]: 2023-10-23 08:17:40.341 EDT [1958363] LOG: execute <unnamed>: SELECT * FROM (SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen,t.typtypmod,row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif(a.attidentity, '') as attidentity,nullif(a.attgenerated, '') as attgenerated,pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE c.relkind in ('r','p','v','f','m') and a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'ncvoter\_2022\_12\_10') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum
Oct 23 08:17:40 pg_ctl[1958363]: 2023-10-23 08:17:40.342 EDT [1958363] LOG: execute S_1: select att.attname,
Oct 23 08:17:40 pg_ctl[1958363]: col.collcollate,
Oct 23 08:17:40 pg_ctl[1958363]: case
Oct 23 08:17:40 pg_ctl[1958363]: when att.attlen = -1 then att.attstorage
Oct 23 08:17:40 pg_ctl[1958363]: else null
Oct 23 08:17:40 pg_ctl[1958363]: end as attstorage,
Oct 23 08:17:40 pg_ctl[1958363]: att.atttypmod,
Oct 23 08:17:40 pg_ctl[1958363]: att.attinhcount,
Oct 23 08:17:40 pg_ctl[1958363]: att.attndims,
Oct 23 08:17:40 pg_ctl[1958363]: att.atthasdef,
Oct 23 08:17:40 pg_ctl[1958363]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type,
Oct 23 08:17:40 pg_ctl[1958363]: nullif(att.attidentity, '') as attidentity,
Oct 23 08:17:40 pg_ctl[1958363]: pg_get_expr(d.adbin, d.adrelid) as generated_expr,
Oct 23 08:17:40 pg_ctl[1958363]: att.attgenerated as attgenerated,
Oct 23 08:17:40 pg_ctl[1958363]: att.attcompression as attcompression
Oct 23 08:17:40 pg_ctl[1958363]: from pg_catalog.pg_attribute att
Oct 23 08:17:40 pg_ctl[1958363]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid
Oct 23 08:17:40 pg_ctl[1958363]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid
Oct 23 08:17:40 pg_ctl[1958363]: left join pg_catalog.pg_collation col on att.attcollation = col.oid
Oct 23 08:17:40 pg_ctl[1958363]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum
Oct 23 08:17:40 pg_ctl[1958363]: where tbl.relname = $1
Oct 23 08:17:40 pg_ctl[1958363]: and ns.nspname = $2
Oct 23 08:17:40 pg_ctl[1958363]: and not att.attisdropped
Oct 23 08:17:40 pg_ctl[1958363]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid')
Oct 23 08:17:40 pg_ctl[1958363]: 2023-10-23 08:17:40.342 EDT [1958363] DETAIL: parameters: $1 = 'ncvoter_2022_12_10', $2 = 'public'
Oct 23 08:17:40 pg_ctl[1958363]: 2023-10-23 08:17:40.344 EDT [1958363] LOG: execute <unnamed>: SELECT county_id,
Oct 23 08:17:40 pg_ctl[1958363]: county_desc,
#
# smipped column names to reduce visual clutter
#
Oct 23 08:17:40 pg_ctl[1958363]: FROM public.ncvoter_2022_12_10
Oct 23 08:17:40 pg_ctl[1958363]: LIMIT 10
Oct 23 08:17:40 pg_ctl[1958363]: 2023-10-23 08:17:40.347 EDT [1958363] LOG: execute <unnamed>: SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR 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 43998 AS oid , 1 AS attnum UNION ALL SELECT 43998, 2 UNION ALL SELECT 43998, 3 UNION ALL SELECT 43998, 4 UNION ALL SELECT 43998, 5 UNION ALL SELECT 43998, 6 UNION ALL SELECT 43998, 7 UNION ALL SELECT 43998, 8 UNION ALL SELECT 43998, 9 UNION ALL SELECT 43998, 10 UNION ALL SELECT 43998, 11 UNION ALL SELECT 43998, 12 UNION ALL SELECT 43998, 13 UNION ALL SELECT 43998, 14 UNION ALL SELECT 43998, 15 UNION ALL SELECT 43998, 16 UNION ALL SELECT 43998, 17 UNION ALL SELECT 43998, 18 UNION ALL SELECT 43998, 19 UNION ALL SELECT 43998, 20 UNION ALL SELECT 43998, 21 UNION ALL SELECT 43998, 22 UNION ALL SELECT 43998, 23 UNION ALL SELECT 43998, 24 UNION ALL SELECT 43998, 25 UNION ALL SELECT 43998, 26 UNION ALL SELECT 43998, 27 UNION ALL SELECT 43998, 28 UNION ALL SELECT 43998, 29 UNION ALL SELECT 43998, 30 UNION ALL SELECT 43998, 31 UNION ALL SELECT 43998, 32 UNION ALL SELECT 43998, 33 UNION ALL SELECT 43998, 34 UNION ALL SELECT 43998, 35 UNION ALL SELECT 43998, 36 UNION ALL SELECT 43998, 37 UNION ALL SELECT 43998, 38 UNION ALL SELECT 43998, 39 UNION ALL SELECT 43998, 40 UNION ALL SELECT 43998, 41 UNION ALL SELECT 43998, 42 UNION ALL SELECT 43998, 43 UNION ALL SELECT 43998, 44 UNION ALL SELECT 43998, 45 UNION ALL SELECT 43998, 46 UNION ALL SELECT 43998, 47 UNION ALL SELECT 43998, 48 UNION ALL SELECT 43998, 49 UNION ALL SELECT 43998, 50 UNION ALL SELECT 43998, 51 UNION ALL SELECT 43998, 52 UNION ALL SELECT 43998, 53 UNION ALL SELECT 43998, 54 UNION ALL SELECT 43998, 55 UNION ALL SELECT 43998, 56 UNION ALL SELECT 43998, 57 UNION ALL SELECT 43998, 58 UNION ALL SELECT 43998, 59 UNION ALL SELECT 43998, 60 UNION ALL SELECT 43998, 61 UNION ALL SELECT 43998, 62 UNION ALL SELECT 43998, 63 UNION ALL SELECT 43998, 64 UNION ALL SELECT 43998, 65 UNION ALL SELECT 43998, 66 UNION ALL SELECT 43998, 67) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)
#
# Here SQL-workbench/J displays the result.
#
# The above took 62 seconds to display from a 8,334,596 row table
#
#################################### arrow down to another table...
Oct 23 09:06:39 pg_ctl[1958363]: 2023-10-23 09:06:39.097 EDT [1958363] LOG: execute <unnamed>: SELECT count(*)
Oct 23 09:06:39 pg_ctl[1958363]: FROM public.ncvoter_2022_12_24
Oct 23 09:06:39 pg_ctl[1958363]:
#
# 20 seconds...
#
Oct 23 09:07:19 pg_ctl[1931492]: 2023-10-23 09:07:19.052 EDT [1931492] LOG: execute <unnamed>: Select 1
#
# 2 seconds...
#
Oct 23 09:07:31 pg_ctl[1958363]: 2023-10-23 09:07:31.026 EDT [1958363] LOG: execute <unnamed>: SELECT result.TABLE_CAT, result.TABLE_SCHEM, result.TABLE_NAME, result.COLUMN_NAME, result.KEY_SEQ, result.PK_NAME FROM (SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (information_schema._pg_expandarray(i.indkey)).n AS KEY_SEQ, ci.relname AS PK_NAME, information_schema._pg_expandarray(i.indkey) AS KEYS, a.attnum AS A_ATTNUM FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN pg_catalog.pg_index i ON ( a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true AND n.nspname = 'public' AND ct.relname = 'ncvoter_2022_12_24' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq
Oct 23 09:07:31 pg_ctl[1958363]: 2023-10-23 09:07:31.028 EDT [1958363] LOG: execute <unnamed>: SELECT * FROM (SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen,t.typtypmod,row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif(a.attidentity, '') as attidentity,nullif(a.attgenerated, '') as attgenerated,pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE c.relkind in ('r','p','v','f','m') and a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'ncvoter\_2022\_12\_24') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum
Oct 23 09:07:31 pg_ctl[1958363]: 2023-10-23 09:07:31.029 EDT [1958363] LOG: execute S_1: select att.attname,
Oct 23 09:07:31 pg_ctl[1958363]: col.collcollate,
Oct 23 09:07:31 pg_ctl[1958363]: case
Oct 23 09:07:31 pg_ctl[1958363]: when att.attlen = -1 then att.attstorage
Oct 23 09:07:31 pg_ctl[1958363]: else null
Oct 23 09:07:31 pg_ctl[1958363]: end as attstorage,
Oct 23 09:07:31 pg_ctl[1958363]: att.atttypmod,
Oct 23 09:07:31 pg_ctl[1958363]: att.attinhcount,
Oct 23 09:07:31 pg_ctl[1958363]: att.attndims,
Oct 23 09:07:31 pg_ctl[1958363]: att.atthasdef,
Oct 23 09:07:31 pg_ctl[1958363]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type,
Oct 23 09:07:31 pg_ctl[1958363]: nullif(att.attidentity, '') as attidentity,
Oct 23 09:07:31 pg_ctl[1958363]: pg_get_expr(d.adbin, d.adrelid) as generated_expr,
Oct 23 09:07:31 pg_ctl[1958363]: att.attgenerated as attgenerated,
Oct 23 09:07:31 pg_ctl[1958363]: att.attcompression as attcompression
Oct 23 09:07:31 pg_ctl[1958363]: from pg_catalog.pg_attribute att
Oct 23 09:07:31 pg_ctl[1958363]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid
Oct 23 09:07:31 pg_ctl[1958363]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid
Oct 23 09:07:31 pg_ctl[1958363]: left join pg_catalog.pg_collation col on att.attcollation = col.oid
Oct 23 09:07:31 pg_ctl[1958363]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum
Oct 23 09:07:31 pg_ctl[1958363]: where tbl.relname = $1
Oct 23 09:07:31 pg_ctl[1958363]: and ns.nspname = $2
Oct 23 09:07:31 pg_ctl[1958363]: and not att.attisdropped
Oct 23 09:07:31 pg_ctl[1958363]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid')
Oct 23 09:07:31 pg_ctl[1958363]: 2023-10-23 09:07:31.029 EDT [1958363] DETAIL: parameters: $1 = 'ncvoter_2022_12_24', $2 = 'public'
Oct 23 09:07:31 pg_ctl[1958363]: 2023-10-23 09:07:31.030 EDT [1958363] LOG: execute <unnamed>: SELECT county_id,
Oct 23 09:07:31 pg_ctl[1958363]: county_desc,
#
# smipped column names to reduce visual clutter
#
Oct 23 09:07:31 pg_ctl[1958363]: FROM public.ncvoter_2022_12_24
Oct 23 09:07:31 pg_ctl[1958363]: LIMIT 10
#
# The above took 52 seconds to display from a 8,334,596 row table
#