# THis file contains iostat results polled once per second via: # $ while true; do echo -n "$(date +%H:%M:%S) "; iostat /dev/nvme1n1 | grep nvme1n1; sleep 1; done # and that output is merged with journal log entries. # It appears all the queries are identical; but the iostat output tells a different story. 1: ################################################################################ Under 1 second # this iostate header is not repeated below. Time Device tps kB_read/s kB_wrtn/s kB_dscd/s kB_read kB_wrtn kB_dscd ByteDelta Total 09:59:49 nvme1n1 30.82 1289.21 2505.22 0.00 871525257 1693560848 0 09:59:50 nvme1n1 30.82 1289.54 2505.22 0.00 871749805 1693560848 0 224548 Oct 26 09:59:50 pg_ctl[1977002]: 2023-10-26 09:59:50.252 EDT [1977002] LOG: execute : SELECT count(*) Oct 26 09:59:50 pg_ctl[1977002]: FROM public.ncvhis_2023_08_26 Oct 26 09:59:50 pg_ctl[1977002]: Oct 26 09:59:50 pg_ctl[1977002]: 2023-10-26 09:59:50.623 EDT [1977002] LOG: execute : 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 = 'ncvhis_2023_08_26' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq Oct 26 09:59:50 pg_ctl[1977002]: 2023-10-26 09:59:50.624 EDT [1977002] LOG: execute : 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 'ncvhis\_2023\_08\_26') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum Oct 26 09:59:50 pg_ctl[1977002]: 2023-10-26 09:59:50.625 EDT [1977002] LOG: execute S_1: select att.attname, Oct 26 09:59:50 pg_ctl[1977002]: col.collcollate, Oct 26 09:59:50 pg_ctl[1977002]: case Oct 26 09:59:50 pg_ctl[1977002]: when att.attlen = -1 then att.attstorage Oct 26 09:59:50 pg_ctl[1977002]: else null Oct 26 09:59:50 pg_ctl[1977002]: end as attstorage, Oct 26 09:59:50 pg_ctl[1977002]: att.atttypmod, Oct 26 09:59:50 pg_ctl[1977002]: att.attinhcount, Oct 26 09:59:50 pg_ctl[1977002]: att.attndims, Oct 26 09:59:50 pg_ctl[1977002]: att.atthasdef, Oct 26 09:59:50 pg_ctl[1977002]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type, Oct 26 09:59:50 pg_ctl[1977002]: nullif(att.attidentity, '') as attidentity, Oct 26 09:59:50 pg_ctl[1977002]: pg_get_expr(d.adbin, d.adrelid) as generated_expr, Oct 26 09:59:50 pg_ctl[1977002]: att.attgenerated as attgenerated, Oct 26 09:59:50 pg_ctl[1977002]: att.attcompression as attcompression Oct 26 09:59:50 pg_ctl[1977002]: from pg_catalog.pg_attribute att Oct 26 09:59:50 pg_ctl[1977002]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid Oct 26 09:59:50 pg_ctl[1977002]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid Oct 26 09:59:50 pg_ctl[1977002]: left join pg_catalog.pg_collation col on att.attcollation = col.oid Oct 26 09:59:50 pg_ctl[1977002]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum Oct 26 09:59:50 pg_ctl[1977002]: where tbl.relname = $1 Oct 26 09:59:50 pg_ctl[1977002]: and ns.nspname = $2 Oct 26 09:59:50 pg_ctl[1977002]: and not att.attisdropped Oct 26 09:59:50 pg_ctl[1977002]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid') Oct 26 09:59:50 pg_ctl[1977002]: 2023-10-26 09:59:50.625 EDT [1977002] DETAIL: parameters: $1 = 'ncvhis_2023_08_26', $2 = 'public' Oct 26 09:59:50 pg_ctl[1977002]: 2023-10-26 09:59:50.625 EDT [1977002] LOG: execute : SELECT county_id, Oct 26 09:59:50 pg_ctl[1977002]: county_desc, Oct 26 09:59:50 pg_ctl[1977002]: voter_reg_num, Oct 26 09:59:50 pg_ctl[1977002]: election_lbl, Oct 26 09:59:50 pg_ctl[1977002]: election_desc, Oct 26 09:59:50 pg_ctl[1977002]: voting_method, Oct 26 09:59:50 pg_ctl[1977002]: voted_party_cd, Oct 26 09:59:50 pg_ctl[1977002]: voted_party_desc, Oct 26 09:59:50 pg_ctl[1977002]: pct_label, Oct 26 09:59:50 pg_ctl[1977002]: pct_description, Oct 26 09:59:50 pg_ctl[1977002]: ncid, Oct 26 09:59:50 pg_ctl[1977002]: voted_county_id, Oct 26 09:59:50 pg_ctl[1977002]: voted_county_desc, Oct 26 09:59:50 pg_ctl[1977002]: vtd_label, Oct 26 09:59:50 pg_ctl[1977002]: vtd_description Oct 26 09:59:50 pg_ctl[1977002]: FROM public.ncvhis_2023_08_26 Oct 26 09:59:50 pg_ctl[1977002]: LIMIT 10 Oct 26 09:59:50 pg_ctl[1977002]: 2023-10-26 09:59:50.627 EDT [1977002] LOG: execute : 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 4383925 AS oid , 1 AS attnum UNION ALL SELECT 4383925, 2 UNION ALL SELECT 4383925, 3 UNION ALL SELECT 4383925, 4 UNION ALL SELECT 4383925, 5 UNION ALL SELECT 4383925, 6 UNION ALL SELECT 4383925, 7 UNION ALL SELECT 4383925, 8 UNION ALL SELECT 4383925, 9 UNION ALL SELECT 4383925, 10 UNION ALL SELECT 4383925, 11 UNION ALL SELECT 4383925, 12 UNION ALL SELECT 4383925, 13 UNION ALL SELECT 4383925, 14 UNION ALL SELECT 4383925, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) 2: ################################################################################ Under 1 second 09:59:51 nvme1n1 30.82 1289.54 2505.21 0.00 871749805 1693560848 0 09:59:52 nvme1n1 30.83 1289.87 2505.21 0.00 871974333 1693560848 0 224528 Oct 26 09:59:52 pg_ctl[1977002]: 2023-10-26 09:59:52.228 EDT [1977002] LOG: execute : SELECT count(*) Oct 26 09:59:52 pg_ctl[1977002]: FROM public.ncvhis_2023_09_02 Oct 26 09:59:52 pg_ctl[1977002]: Oct 26 09:59:52 pg_ctl[1977002]: 2023-10-26 09:59:52.605 EDT [1977002] LOG: execute : 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 = 'ncvhis_2023_09_02' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq Oct 26 09:59:52 pg_ctl[1977002]: 2023-10-26 09:59:52.606 EDT [1977002] LOG: execute : 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 'ncvhis\_2023\_09\_02') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum Oct 26 09:59:52 pg_ctl[1977002]: 2023-10-26 09:59:52.606 EDT [1977002] LOG: execute S_1: select att.attname, Oct 26 09:59:52 pg_ctl[1977002]: col.collcollate, Oct 26 09:59:52 pg_ctl[1977002]: case Oct 26 09:59:52 pg_ctl[1977002]: when att.attlen = -1 then att.attstorage Oct 26 09:59:52 pg_ctl[1977002]: else null Oct 26 09:59:52 pg_ctl[1977002]: end as attstorage, Oct 26 09:59:52 pg_ctl[1977002]: att.atttypmod, Oct 26 09:59:52 pg_ctl[1977002]: att.attinhcount, Oct 26 09:59:52 pg_ctl[1977002]: att.attndims, Oct 26 09:59:52 pg_ctl[1977002]: att.atthasdef, Oct 26 09:59:52 pg_ctl[1977002]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type, Oct 26 09:59:52 pg_ctl[1977002]: nullif(att.attidentity, '') as attidentity, Oct 26 09:59:52 pg_ctl[1977002]: pg_get_expr(d.adbin, d.adrelid) as generated_expr, Oct 26 09:59:52 pg_ctl[1977002]: att.attgenerated as attgenerated, Oct 26 09:59:52 pg_ctl[1977002]: att.attcompression as attcompression Oct 26 09:59:52 pg_ctl[1977002]: from pg_catalog.pg_attribute att Oct 26 09:59:52 pg_ctl[1977002]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid Oct 26 09:59:52 pg_ctl[1977002]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid Oct 26 09:59:52 pg_ctl[1977002]: left join pg_catalog.pg_collation col on att.attcollation = col.oid Oct 26 09:59:52 pg_ctl[1977002]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum Oct 26 09:59:52 pg_ctl[1977002]: where tbl.relname = $1 Oct 26 09:59:52 pg_ctl[1977002]: and ns.nspname = $2 Oct 26 09:59:52 pg_ctl[1977002]: and not att.attisdropped Oct 26 09:59:52 pg_ctl[1977002]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid') Oct 26 09:59:52 pg_ctl[1977002]: 2023-10-26 09:59:52.606 EDT [1977002] DETAIL: parameters: $1 = 'ncvhis_2023_09_02', $2 = 'public' Oct 26 09:59:52 pg_ctl[1977002]: 2023-10-26 09:59:52.607 EDT [1977002] LOG: execute : SELECT county_id, Oct 26 09:59:52 pg_ctl[1977002]: county_desc, Oct 26 09:59:52 pg_ctl[1977002]: voter_reg_num, Oct 26 09:59:52 pg_ctl[1977002]: election_lbl, Oct 26 09:59:52 pg_ctl[1977002]: election_desc, Oct 26 09:59:52 pg_ctl[1977002]: voting_method, Oct 26 09:59:52 pg_ctl[1977002]: voted_party_cd, Oct 26 09:59:52 pg_ctl[1977002]: voted_party_desc, Oct 26 09:59:52 pg_ctl[1977002]: pct_label, Oct 26 09:59:52 pg_ctl[1977002]: pct_description, Oct 26 09:59:52 pg_ctl[1977002]: ncid, Oct 26 09:59:52 pg_ctl[1977002]: voted_county_id, Oct 26 09:59:52 pg_ctl[1977002]: voted_county_desc, Oct 26 09:59:52 pg_ctl[1977002]: vtd_label, Oct 26 09:59:52 pg_ctl[1977002]: vtd_description Oct 26 09:59:52 pg_ctl[1977002]: FROM public.ncvhis_2023_09_02 Oct 26 09:59:52 pg_ctl[1977002]: LIMIT 10 Oct 26 09:59:52 pg_ctl[1977002]: 2023-10-26 09:59:52.609 EDT [1977002] LOG: execute : 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 4384156 AS oid , 1 AS attnum UNION ALL SELECT 4384156, 2 UNION ALL SELECT 4384156, 3 UNION ALL SELECT 4384156, 4 UNION ALL SELECT 4384156, 5 UNION ALL SELECT 4384156, 6 UNION ALL SELECT 4384156, 7 UNION ALL SELECT 4384156, 8 UNION ALL SELECT 4384156, 9 UNION ALL SELECT 4384156, 10 UNION ALL SELECT 4384156, 11 UNION ALL SELECT 4384156, 12 UNION ALL SELECT 4384156, 13 UNION ALL SELECT 4384156, 14 UNION ALL SELECT 4384156, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) 3: ################################################################################ Under 1 second 09:59:53 nvme1n1 30.83 1289.87 2505.21 0.00 871974333 1693560848 0 0 09:59:54 nvme1n1 30.83 1290.13 2505.20 0.00 872150185 1693560848 0 175852 09:59:55 nvme1n1 30.83 1290.20 2505.20 0.00 872198941 1693560848 0 +48756 =224608 09:59:56 nvme1n1 30.83 1290.20 2505.19 0.00 872198941 1693560848 0 0 Oct 26 09:59:54 pg_ctl[1977002]: 2023-10-26 09:59:54.565 EDT [1977002] LOG: execute : SELECT count(*) Oct 26 09:59:54 pg_ctl[1977002]: FROM public.ncvhis_2023_09_09 Oct 26 09:59:54 pg_ctl[1977002]: Oct 26 09:59:54 pg_ctl[1977002]: 2023-10-26 09:59:54.965 EDT [1977002] LOG: execute : 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 = 'ncvhis_2023_09_09' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq Oct 26 09:59:54 pg_ctl[1977002]: 2023-10-26 09:59:54.966 EDT [1977002] LOG: execute : 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 'ncvhis\_2023\_09\_09') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum Oct 26 09:59:54 pg_ctl[1977002]: 2023-10-26 09:59:54.966 EDT [1977002] LOG: execute S_1: select att.attname, Oct 26 09:59:54 pg_ctl[1977002]: col.collcollate, Oct 26 09:59:54 pg_ctl[1977002]: case Oct 26 09:59:54 pg_ctl[1977002]: when att.attlen = -1 then att.attstorage Oct 26 09:59:54 pg_ctl[1977002]: else null Oct 26 09:59:54 pg_ctl[1977002]: end as attstorage, Oct 26 09:59:54 pg_ctl[1977002]: att.atttypmod, Oct 26 09:59:54 pg_ctl[1977002]: att.attinhcount, Oct 26 09:59:54 pg_ctl[1977002]: att.attndims, Oct 26 09:59:54 pg_ctl[1977002]: att.atthasdef, Oct 26 09:59:54 pg_ctl[1977002]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type, Oct 26 09:59:54 pg_ctl[1977002]: nullif(att.attidentity, '') as attidentity, Oct 26 09:59:54 pg_ctl[1977002]: pg_get_expr(d.adbin, d.adrelid) as generated_expr, Oct 26 09:59:54 pg_ctl[1977002]: att.attgenerated as attgenerated, Oct 26 09:59:54 pg_ctl[1977002]: att.attcompression as attcompression Oct 26 09:59:54 pg_ctl[1977002]: from pg_catalog.pg_attribute att Oct 26 09:59:54 pg_ctl[1977002]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid Oct 26 09:59:54 pg_ctl[1977002]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid Oct 26 09:59:54 pg_ctl[1977002]: left join pg_catalog.pg_collation col on att.attcollation = col.oid Oct 26 09:59:54 pg_ctl[1977002]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum Oct 26 09:59:54 pg_ctl[1977002]: where tbl.relname = $1 Oct 26 09:59:54 pg_ctl[1977002]: and ns.nspname = $2 Oct 26 09:59:54 pg_ctl[1977002]: and not att.attisdropped Oct 26 09:59:54 pg_ctl[1977002]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid') Oct 26 09:59:54 pg_ctl[1977002]: 2023-10-26 09:59:54.966 EDT [1977002] DETAIL: parameters: $1 = 'ncvhis_2023_09_09', $2 = 'public' Oct 26 09:59:54 pg_ctl[1977002]: 2023-10-26 09:59:54.967 EDT [1977002] LOG: execute : SELECT county_id, Oct 26 09:59:54 pg_ctl[1977002]: county_desc, Oct 26 09:59:54 pg_ctl[1977002]: voter_reg_num, Oct 26 09:59:54 pg_ctl[1977002]: election_lbl, Oct 26 09:59:54 pg_ctl[1977002]: election_desc, Oct 26 09:59:54 pg_ctl[1977002]: voting_method, Oct 26 09:59:54 pg_ctl[1977002]: voted_party_cd, Oct 26 09:59:54 pg_ctl[1977002]: voted_party_desc, Oct 26 09:59:54 pg_ctl[1977002]: pct_label, Oct 26 09:59:54 pg_ctl[1977002]: pct_description, Oct 26 09:59:54 pg_ctl[1977002]: ncid, Oct 26 09:59:54 pg_ctl[1977002]: voted_county_id, Oct 26 09:59:54 pg_ctl[1977002]: voted_county_desc, Oct 26 09:59:54 pg_ctl[1977002]: vtd_label, Oct 26 09:59:54 pg_ctl[1977002]: vtd_description Oct 26 09:59:54 pg_ctl[1977002]: FROM public.ncvhis_2023_09_09 Oct 26 09:59:54 pg_ctl[1977002]: LIMIT 10 Oct 26 09:59:54 pg_ctl[1977002]: 2023-10-26 09:59:54.969 EDT [1977002] LOG: execute : 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 4388978 AS oid , 1 AS attnum UNION ALL SELECT 4388978, 2 UNION ALL SELECT 4388978, 3 UNION ALL SELECT 4388978, 4 UNION ALL SELECT 4388978, 5 UNION ALL SELECT 4388978, 6 UNION ALL SELECT 4388978, 7 UNION ALL SELECT 4388978, 8 UNION ALL SELECT 4388978, 9 UNION ALL SELECT 4388978, 10 UNION ALL SELECT 4388978, 11 UNION ALL SELECT 4388978, 12 UNION ALL SELECT 4388978, 13 UNION ALL SELECT 4388978, 14 UNION ALL SELECT 4388978, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) 4: ################################################################################ Under 1 second 09:59:59 nvme1n1 30.83 1290.19 2505.18 0.00 872198941 1693560848 0 10:00:00 nvme1n1 30.83 1290.19 2505.18 0.00 872198941 1693560848 0 0 10:00:01 nvme1n1 30.83 1290.19 2505.18 0.00 872198945 1693560848 0 4 10:00:02 nvme1n1 30.83 1290.52 2505.17 0.00 872423109 1693560848 0 224164 10:00:03 nvme1n1 30.83 1290.52 2505.17 0.00 872424285 1693560848 0 1176 =225344 Oct 26 10:00:02 pg_ctl[1977002]: 2023-10-26 10:00:02.097 EDT [1977002] LOG: execute : SELECT count(*) Oct 26 10:00:02 pg_ctl[1977002]: FROM public.ncvhis_2023_09_16 Oct 26 10:00:02 pg_ctl[1977002]: Oct 26 10:00:02 pg_ctl[1977002]: 2023-10-26 10:00:02.481 EDT [1977002] LOG: execute : 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 = 'ncvhis_2023_09_16' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq Oct 26 10:00:02 pg_ctl[1977002]: 2023-10-26 10:00:02.482 EDT [1977002] LOG: execute : 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 'ncvhis\_2023\_09\_16') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum Oct 26 10:00:02 pg_ctl[1977002]: 2023-10-26 10:00:02.482 EDT [1977002] LOG: execute S_1: select att.attname, Oct 26 10:00:02 pg_ctl[1977002]: col.collcollate, Oct 26 10:00:02 pg_ctl[1977002]: case Oct 26 10:00:02 pg_ctl[1977002]: when att.attlen = -1 then att.attstorage Oct 26 10:00:02 pg_ctl[1977002]: else null Oct 26 10:00:02 pg_ctl[1977002]: end as attstorage, Oct 26 10:00:02 pg_ctl[1977002]: att.atttypmod, Oct 26 10:00:02 pg_ctl[1977002]: att.attinhcount, Oct 26 10:00:02 pg_ctl[1977002]: att.attndims, Oct 26 10:00:02 pg_ctl[1977002]: att.atthasdef, Oct 26 10:00:02 pg_ctl[1977002]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type, Oct 26 10:00:02 pg_ctl[1977002]: nullif(att.attidentity, '') as attidentity, Oct 26 10:00:02 pg_ctl[1977002]: pg_get_expr(d.adbin, d.adrelid) as generated_expr, Oct 26 10:00:02 pg_ctl[1977002]: att.attgenerated as attgenerated, Oct 26 10:00:02 pg_ctl[1977002]: att.attcompression as attcompression Oct 26 10:00:02 pg_ctl[1977002]: from pg_catalog.pg_attribute att Oct 26 10:00:02 pg_ctl[1977002]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid Oct 26 10:00:02 pg_ctl[1977002]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid Oct 26 10:00:02 pg_ctl[1977002]: left join pg_catalog.pg_collation col on att.attcollation = col.oid Oct 26 10:00:02 pg_ctl[1977002]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum Oct 26 10:00:02 pg_ctl[1977002]: where tbl.relname = $1 Oct 26 10:00:02 pg_ctl[1977002]: and ns.nspname = $2 Oct 26 10:00:02 pg_ctl[1977002]: and not att.attisdropped Oct 26 10:00:02 pg_ctl[1977002]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid') Oct 26 10:00:02 pg_ctl[1977002]: 2023-10-26 10:00:02.482 EDT [1977002] DETAIL: parameters: $1 = 'ncvhis_2023_09_16', $2 = 'public' Oct 26 10:00:02 pg_ctl[1977002]: 2023-10-26 10:00:02.483 EDT [1977002] LOG: execute : SELECT county_id, Oct 26 10:00:02 pg_ctl[1977002]: county_desc, Oct 26 10:00:02 pg_ctl[1977002]: voter_reg_num, Oct 26 10:00:02 pg_ctl[1977002]: election_lbl, Oct 26 10:00:02 pg_ctl[1977002]: election_desc, Oct 26 10:00:02 pg_ctl[1977002]: voting_method, Oct 26 10:00:02 pg_ctl[1977002]: voted_party_cd, Oct 26 10:00:02 pg_ctl[1977002]: voted_party_desc, Oct 26 10:00:02 pg_ctl[1977002]: pct_label, Oct 26 10:00:02 pg_ctl[1977002]: pct_description, Oct 26 10:00:02 pg_ctl[1977002]: ncid, Oct 26 10:00:02 pg_ctl[1977002]: voted_county_id, Oct 26 10:00:02 pg_ctl[1977002]: voted_county_desc, Oct 26 10:00:02 pg_ctl[1977002]: vtd_label, Oct 26 10:00:02 pg_ctl[1977002]: vtd_description Oct 26 10:00:02 pg_ctl[1977002]: FROM public.ncvhis_2023_09_16 Oct 26 10:00:02 pg_ctl[1977002]: LIMIT 10 Oct 26 10:00:02 pg_ctl[1977002]: 2023-10-26 10:00:02.485 EDT [1977002] LOG: execute : 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 4698216 AS oid , 1 AS attnum UNION ALL SELECT 4698216, 2 UNION ALL SELECT 4698216, 3 UNION ALL SELECT 4698216, 4 UNION ALL SELECT 4698216, 5 UNION ALL SELECT 4698216, 6 UNION ALL SELECT 4698216, 7 UNION ALL SELECT 4698216, 8 UNION ALL SELECT 4698216, 9 UNION ALL SELECT 4698216, 10 UNION ALL SELECT 4698216, 11 UNION ALL SELECT 4698216, 12 UNION ALL SELECT 4698216, 13 UNION ALL SELECT 4698216, 14 UNION ALL SELECT 4698216, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) 5: ################################################################################ Under 1 second 10:00:00 nvme1n1 30.83 1290.19 2505.18 0.00 872198941 1693560848 0 10:00:01 nvme1n1 30.83 1290.19 2505.18 0.00 872198945 1693560848 0 0 10:00:02 nvme1n1 30.83 1290.52 2505.17 0.00 872423109 1693560848 0 224164 =224164 10:00:03 nvme1n1 30.83 1290.52 2505.17 0.00 872424285 1693560848 0 1176 10:00:04 nvme1n1 30.83 1290.85 2505.16 0.00 872647433 1693560848 0 223148 =224164 # was this a re-read? Oct 26 10:00:03 pg_ctl[1977002]: 2023-10-26 10:00:03.909 EDT [1977002] LOG: execute : SELECT count(*) Oct 26 10:00:03 pg_ctl[1977002]: FROM public.ncvhis_2023_09_23 Oct 26 10:00:03 pg_ctl[1977002]: Oct 26 10:00:04 pg_ctl[1977002]: 2023-10-26 10:00:04.286 EDT [1977002] LOG: execute : 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 = 'ncvhis_2023_09_23' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq Oct 26 10:00:04 pg_ctl[1977002]: 2023-10-26 10:00:04.287 EDT [1977002] LOG: execute : 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 'ncvhis\_2023\_09\_23') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum Oct 26 10:00:04 pg_ctl[1977002]: 2023-10-26 10:00:04.287 EDT [1977002] LOG: execute S_1: select att.attname, Oct 26 10:00:04 pg_ctl[1977002]: col.collcollate, Oct 26 10:00:04 pg_ctl[1977002]: case Oct 26 10:00:04 pg_ctl[1977002]: when att.attlen = -1 then att.attstorage Oct 26 10:00:04 pg_ctl[1977002]: else null Oct 26 10:00:04 pg_ctl[1977002]: end as attstorage, Oct 26 10:00:04 pg_ctl[1977002]: att.atttypmod, Oct 26 10:00:04 pg_ctl[1977002]: att.attinhcount, Oct 26 10:00:04 pg_ctl[1977002]: att.attndims, Oct 26 10:00:04 pg_ctl[1977002]: att.atthasdef, Oct 26 10:00:04 pg_ctl[1977002]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type, Oct 26 10:00:04 pg_ctl[1977002]: nullif(att.attidentity, '') as attidentity, Oct 26 10:00:04 pg_ctl[1977002]: pg_get_expr(d.adbin, d.adrelid) as generated_expr, Oct 26 10:00:04 pg_ctl[1977002]: att.attgenerated as attgenerated, Oct 26 10:00:04 pg_ctl[1977002]: att.attcompression as attcompression Oct 26 10:00:04 pg_ctl[1977002]: from pg_catalog.pg_attribute att Oct 26 10:00:04 pg_ctl[1977002]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid Oct 26 10:00:04 pg_ctl[1977002]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid Oct 26 10:00:04 pg_ctl[1977002]: left join pg_catalog.pg_collation col on att.attcollation = col.oid Oct 26 10:00:04 pg_ctl[1977002]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum Oct 26 10:00:04 pg_ctl[1977002]: where tbl.relname = $1 Oct 26 10:00:04 pg_ctl[1977002]: and ns.nspname = $2 Oct 26 10:00:04 pg_ctl[1977002]: and not att.attisdropped Oct 26 10:00:04 pg_ctl[1977002]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid') Oct 26 10:00:04 pg_ctl[1977002]: 2023-10-26 10:00:04.287 EDT [1977002] DETAIL: parameters: $1 = 'ncvhis_2023_09_23', $2 = 'public' Oct 26 10:00:04 pg_ctl[1977002]: 2023-10-26 10:00:04.288 EDT [1977002] LOG: execute : SELECT county_id, Oct 26 10:00:04 pg_ctl[1977002]: county_desc, Oct 26 10:00:04 pg_ctl[1977002]: voter_reg_num, Oct 26 10:00:04 pg_ctl[1977002]: election_lbl, Oct 26 10:00:04 pg_ctl[1977002]: election_desc, Oct 26 10:00:04 pg_ctl[1977002]: voting_method, Oct 26 10:00:04 pg_ctl[1977002]: voted_party_cd, Oct 26 10:00:04 pg_ctl[1977002]: voted_party_desc, Oct 26 10:00:04 pg_ctl[1977002]: pct_label, Oct 26 10:00:04 pg_ctl[1977002]: pct_description, Oct 26 10:00:04 pg_ctl[1977002]: ncid, Oct 26 10:00:04 pg_ctl[1977002]: voted_county_id, Oct 26 10:00:04 pg_ctl[1977002]: voted_county_desc, Oct 26 10:00:04 pg_ctl[1977002]: vtd_label, Oct 26 10:00:04 pg_ctl[1977002]: vtd_description Oct 26 10:00:04 pg_ctl[1977002]: FROM public.ncvhis_2023_09_23 Oct 26 10:00:04 pg_ctl[1977002]: LIMIT 10 Oct 26 10:00:04 pg_ctl[1977002]: 2023-10-26 10:00:04.289 EDT [1977002] LOG: execute : 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 4707735 AS oid , 1 AS attnum UNION ALL SELECT 4707735, 2 UNION ALL SELECT 4707735, 3 UNION ALL SELECT 4707735, 4 UNION ALL SELECT 4707735, 5 UNION ALL SELECT 4707735, 6 UNION ALL SELECT 4707735, 7 UNION ALL SELECT 4707735, 8 UNION ALL SELECT 4707735, 9 UNION ALL SELECT 4707735, 10 UNION ALL SELECT 4707735, 11 UNION ALL SELECT 4707735, 12 UNION ALL SELECT 4707735, 13 UNION ALL SELECT 4707735, 14 UNION ALL SELECT 4707735, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) 6: ################################################################################ Under 1 second 10:00:05 nvme1n1 30.83 1290.84 2505.16 0.00 872647433 1693560848 0 10:00:06 nvme1n1 30.84 1291.17 2505.16 0.00 872871949 1693560848 0 224516 = 224516 Oct 26 10:00:06 pg_ctl[1977002]: 2023-10-26 10:00:06.459 EDT [1977002] LOG: execute : SELECT count(*) Oct 26 10:00:06 pg_ctl[1977002]: FROM public.ncvhis_2023_09_30 Oct 26 10:00:06 pg_ctl[1977002]: Oct 26 10:00:06 pg_ctl[1977002]: 2023-10-26 10:00:06.838 EDT [1977002] LOG: execute : 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 = 'ncvhis_2023_09_30' AND i.indisprimary ) result where result.A_ATTNUM = (result.KEYS).x ORDER BY result.table_name, result.pk_name, result.key_seq Oct 26 10:00:06 pg_ctl[1977002]: 2023-10-26 10:00:06.839 EDT [1977002] LOG: execute : 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 'ncvhis\_2023\_09\_30') c WHERE true AND attname LIKE '%' ORDER BY nspname,c.relname,attnum Oct 26 10:00:06 pg_ctl[1977002]: 2023-10-26 10:00:06.840 EDT [1977002] LOG: execute S_1: select att.attname, Oct 26 10:00:06 pg_ctl[1977002]: col.collcollate, Oct 26 10:00:06 pg_ctl[1977002]: case Oct 26 10:00:06 pg_ctl[1977002]: when att.attlen = -1 then att.attstorage Oct 26 10:00:06 pg_ctl[1977002]: else null Oct 26 10:00:06 pg_ctl[1977002]: end as attstorage, Oct 26 10:00:06 pg_ctl[1977002]: att.atttypmod, Oct 26 10:00:06 pg_ctl[1977002]: att.attinhcount, Oct 26 10:00:06 pg_ctl[1977002]: att.attndims, Oct 26 10:00:06 pg_ctl[1977002]: att.atthasdef, Oct 26 10:00:06 pg_ctl[1977002]: pg_catalog.format_type(att.atttypid, att.atttypmod) as display_type, Oct 26 10:00:06 pg_ctl[1977002]: nullif(att.attidentity, '') as attidentity, Oct 26 10:00:06 pg_ctl[1977002]: pg_get_expr(d.adbin, d.adrelid) as generated_expr, Oct 26 10:00:06 pg_ctl[1977002]: att.attgenerated as attgenerated, Oct 26 10:00:06 pg_ctl[1977002]: att.attcompression as attcompression Oct 26 10:00:06 pg_ctl[1977002]: from pg_catalog.pg_attribute att Oct 26 10:00:06 pg_ctl[1977002]: join pg_catalog.pg_class tbl on tbl.oid = att.attrelid Oct 26 10:00:06 pg_ctl[1977002]: join pg_catalog.pg_namespace ns on tbl.relnamespace = ns.oid Oct 26 10:00:06 pg_ctl[1977002]: left join pg_catalog.pg_collation col on att.attcollation = col.oid Oct 26 10:00:06 pg_ctl[1977002]: left join pg_catalog.pg_attrdef d on d.adrelid = att.attrelid and d.adnum = att.attnum Oct 26 10:00:06 pg_ctl[1977002]: where tbl.relname = $1 Oct 26 10:00:06 pg_ctl[1977002]: and ns.nspname = $2 Oct 26 10:00:06 pg_ctl[1977002]: and not att.attisdropped Oct 26 10:00:06 pg_ctl[1977002]: and att.attname not in ('tableoid', 'cmax', 'xmax', 'cmin', 'xmin', 'ctid') Oct 26 10:00:06 pg_ctl[1977002]: 2023-10-26 10:00:06.840 EDT [1977002] DETAIL: parameters: $1 = 'ncvhis_2023_09_30', $2 = 'public' Oct 26 10:00:06 pg_ctl[1977002]: 2023-10-26 10:00:06.841 EDT [1977002] LOG: execute : SELECT county_id, Oct 26 10:00:06 pg_ctl[1977002]: county_desc, Oct 26 10:00:06 pg_ctl[1977002]: voter_reg_num, Oct 26 10:00:06 pg_ctl[1977002]: election_lbl, Oct 26 10:00:06 pg_ctl[1977002]: election_desc, Oct 26 10:00:06 pg_ctl[1977002]: voting_method, Oct 26 10:00:06 pg_ctl[1977002]: voted_party_cd, Oct 26 10:00:06 pg_ctl[1977002]: voted_party_desc, Oct 26 10:00:06 pg_ctl[1977002]: pct_label, Oct 26 10:00:06 pg_ctl[1977002]: pct_description, Oct 26 10:00:06 pg_ctl[1977002]: ncid, Oct 26 10:00:06 pg_ctl[1977002]: voted_county_id, Oct 26 10:00:06 pg_ctl[1977002]: voted_county_desc, Oct 26 10:00:06 pg_ctl[1977002]: vtd_label, Oct 26 10:00:06 pg_ctl[1977002]: vtd_description Oct 26 10:00:06 pg_ctl[1977002]: FROM public.ncvhis_2023_09_30 Oct 26 10:00:06 pg_ctl[1977002]: LIMIT 10 Oct 26 10:00:06 pg_ctl[1977002]: 2023-10-26 10:00:06.842 EDT [1977002] LOG: execute : 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 4707755 AS oid , 1 AS attnum UNION ALL SELECT 4707755, 2 UNION ALL SELECT 4707755, 3 UNION ALL SELECT 4707755, 4 UNION ALL SELECT 4707755, 5 UNION ALL SELECT 4707755, 6 UNION ALL SELECT 4707755, 7 UNION ALL SELECT 4707755, 8 UNION ALL SELECT 4707755, 9 UNION ALL SELECT 4707755, 10 UNION ALL SELECT 4707755, 11 UNION ALL SELECT 4707755, 12 UNION ALL SELECT 4707755, 13 UNION ALL SELECT 4707755, 14 UNION ALL SELECT 4707755, 15) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum)