When integration is monitoring a PostgreSQL 12.2 installation, the monitoring query fails.
My understanding is that this bug impacts monitoring of any PostgreSQL 12 due to OID changes in PG 12.
Error below is from the PostgreSQL logs.
2020-04-24 17:23:29.786 UTC [8288] ERROR: column tbl.relhasoids does not exist at character 1941
2020-04-24 17:23:29.786 UTC [8288] STATEMENT: SELECT -- BLOATQUERY
current_database() as database,
schemaname as schema_name, tblname as table_name, bs*tblpages AS real_size,
(tblpages-est_tblpages_ff)*bs AS bloat_size,
CASE WHEN tblpages - est_tblpages_ff > 0
THEN 100 * (tblpages - est_tblpages_ff)/tblpages::float
ELSE 0
END AS bloat_ratio
-- , (pst).free_percent + (pst).dead_tuple_percent AS real_frag
FROM (
SELECT ceil( reltuples / ( (bs-page_hdr)/tpl_size ) ) + ceil( toasttuples / 4 ) AS est_tblpages,
ceil( reltuples / ( (bs-page_hdr)*fillfactor/(tpl_size*100) ) ) + ceil( toasttuples / 4 ) AS est_tblpages_ff,
tblpages, fillfactor, bs, tblid, schemaname, tblname, heappages, toastpages, is_na
-- , stattuple.pgstattuple(tblid) AS pst
FROM (
SELECT
( 4 + tpl_hdr_size + tpl_data_size + (2*ma)
- CASE WHEN tpl_hdr_size%ma = 0 THEN ma ELSE tpl_hdr_size%ma END
- CASE WHEN ceil(tpl_data_size)::int%ma = 0 THEN ma ELSE ceil(tpl_data_size)::int%ma END
) AS tpl_size, bs - page_hdr AS size_per_block, (heappages + toastpages) AS tblpages, heappages,
toastpages, reltuples, toasttuples, bs, page_hdr, tblid, schemaname, tblname, fillfactor, is_na
FROM (
SELECT
tbl.oid AS tblid, ns.nspname AS schemaname, tbl.relname AS tblname, tbl.reltuples,
tbl.relpages AS heappages, coalesce(toast.relpages, 0) AS toastpages,
coalesce(toast.reltuples, 0) AS toasttuples,
coalesce(substring(
array_to_string(tbl.reloptions, ' ')
FROM 'fillfactor=([0-9]+)')::smallint, 100) AS fillfactor,
current_setting('block_size')::numeric AS bs,
CASE WHEN version()~'mingw32' OR version()~'64-bit|x86_64|ppc64|ia64|amd64' THEN 8 ELSE 4 END AS ma,
24 AS page_hdr,
CASE WHEN current_setting('server_version_num')::integer < 80300 THEN 27 ELSE 23 END
+ CASE WHEN MAX(coalesce(null_frac,0)) > 0 THEN ( 7 + count(*) ) / 8 ELSE 0::int END
+ CASE WHEN tbl.relhasoids THEN 4 ELSE 0 END AS tpl_hdr_size,
sum( (1-coalesce(s.null_frac, 0)) * coalesce(s.avg_width, 1024) ) AS tpl_data_size,
bool_or(att.atttypid = 'pg_catalog.name'::regtype)
OR count(att.attname) <> count(s.attname) AS is_na
FROM pg_attribute AS att
JOIN pg_class AS tbl ON att.attrelid = tbl.oid
JOIN pg_namespace AS ns ON ns.oid = tbl.relnamespace
LEFT JOIN pg_stats AS s ON s.schemaname=ns.nspname
AND s.tablename = tbl.relname AND s.attname=att.attname
LEFT JOIN pg_class AS toast ON tbl.reltoastrelid = toast.oid
WHERE att.attnum > 0 AND NOT att.attisdropped
AND tbl.relkind = 'r'
GROUP BY 1,2,3,4,5,6,7,8,9,10, tbl.relhasoids
ORDER BY 2,3
) AS s
) AS s2
) AS s3
where not is_na
and schemaname || '.' || tblname in ('pg_catalog.pg_ts_dict','pg_catalog.pg_transform','pg_catalog.pg_stat_replication','pg_catalog.pg_stat_progress_vacuum','pg_catalog.pg_depend','pg_catalog.pg_publication','pg_catalog.pg_indexes','pg_catalog.pg_statio_all_tables','pg_catalog.pg_attribute','pg_catalog.pg_seclabels','pg_catalog.pg_statio_sys_indexes','pg_catalog.pg_stat_progress_create_index','pg_catalog.pg_partitioned_table','pg_catalog.pg_stat_wal_receiver','pg_catalog.pg_tablespace','pg_catalog.pg_rules','pg_catalog.pg_locks','pg_catalog.pg_available_extension_versions','pg_catalog.pg_stat_user_indexes','pg_catalog.pg_statio_user_indexes','pg_catalog.pg_stat_archiver','pg_catalog.pg_cursors','pg_catalog.pg_auth_members','pg_catalog.pg_replication_origin','pg_catalog.pg_init_privs','pg_catalog.pg_shseclabel','pg_catalog.pg_policies','pg_catalog.pg_stat_user_tables','pg_catalog.pg_opfamily','pg_catalog.pg_stat_sys_tables','pg_catalog.pg_attrdef','pg_catalog.pg_seclabel','pg_catalog.pg_user_mappings','pg_catalog.pg_views','pg_catalog.pg_class','pg_catalog.pg_publication_rel','pg_catalog.pg_stats','pg_catalog.pg_am','pg_catalog.pg_amproc','pg_catalog.pg_matviews','pg_catalog.pg_event_trigger','pg_catalog.pg_ts_config','pg_catalog.pg_subscription_rel','pg_catalog.pg_stat_all_indexes','pg_catalog.pg_operator','pg_catalog.pg_default_acl','pg_catalog.pg_statio_user_tables','pg_catalog.pg_stat_bgwriter','pg_catalog.pg_database','pg_catalog.pg_timezone_names','pg_catalog.pg_stat_subscription','pg_catalog.pg_stat_database_conflicts','pg_catalog.pg_statio_sys_tables','pg_catalog.pg_stat_xact_all_tables','pg_catalog.pg_statio_sys_sequences','pg_catalog.pg_stat_sys_indexes','pg_catalog.pg_amop','pg_catalog.pg_prepared_xacts','pg_catalog.pg_largeobject_metadata','pg_catalog.pg_namespace','pg_catalog.pg_collation','pg_catalog.pg_proc','pg_catalog.pg_stat_user_functions','pg_catalog.pg_stat_database','pg_catalog.pg_ts_config_map','pg_catalog.pg_enum','pg_catalog.pg_policy','pg_catalog.pg_type','pg_catalog.pg_roles','pg_catalog.pg_shdescription','pg_catalog.pg_tables','pg_catalog.pg_stat_progress_cluster','pg_catalog.pg_range','pg_catalog.pg_stat_xact_user_functions','pg_catalog.pg_shdepend','pg_catalog.pg_foreign_table','pg_catalog.pg_sequence','pg_catalog.pg_group','pg_catalog.pg_stats_ext','pg_catalog.pg_stat_xact_sys_tables','pg_catalog.pg_statio_all_indexes','pg_catalog.pg_stat_ssl','pg_catalog.pg_inherits','pg_catalog.pg_opclass','pg_catalog.pg_aggregate','pg_catalog.pg_statistic_ext','pg_catalog.pg_trigger','pg_catalog.pg_stat_xact_user_tables','pg_catalog.pg_index','pg_catalog.pg_language','pg_catalog.pg_extension','pg_catalog.pg_available_extensions','pg_catalog.pg_timezone_abbrevs','pg_catalog.pg_stat_all_tables','pg_catalog.pg_settings','pg_catalog.pg_constraint','pg_catalog.pg_rewrite','pg_catalog.pg_cast','pg_catalog.pg_ts_template','pg_catalog.pg_description','pg_catalog.pg_db_role_setting','pg_catalog.pg_ts_parser','pg_catalog.pg_statio_all_sequences','pg_catalog.pg_foreign_server','pg_catalog.pg_conversion','pg_catalog.pg_pltemplate','pg_catalog.pg_stat_activity','pg_catalog.pg_user','pg_catalog.pg_publication_tables','pg_catalog.pg_subscription','pg_catalog.pg_foreign_data_wrapper','pg_catalog.pg_sequences','pg_catalog.pg_prepared_statements','pg_catalog.pg_statio_user_sequences','pg_catalog.pg_stat_gssapi','pg_catalog.pg_replication_slots','information_schema.column_privileges','information_schema.sequences','information_schema.sql_features','information_schema.routine_privileges','information_schema.view_routine_usage','information_schema.character_sets','information_schema.collations','information_schema.foreign_tables','information_schema.table_privileges','information_schema.role_usage_grants','information_schema.role_udt_grants','information_schema.view_column_usage','information_schema.column_options','information_schema.columns','information_schema.views','information_schema.check_constraint_routine_usage','information_schema.foreign_table_options','information_schema.sql_packages','information_schema.sql_implementation_info','information_schema.usage_privileges','information_schema.user_defined_types','information_schema.attributes','information_schema.column_udt_usage','information_schema.column_column_usage','information_schema.constraint_column_usage','information_schema.constraint_table_usage','information_schema.domains','information_schema.foreign_server_options','information_schema.information_schema_catalog_name','information_schema.collation_character_set_applicability','information_schema.sql_sizing_profiles','information_schema.foreign_servers','information_schema.domain_udt_usage','information_schema.parameters','information_schema.role_table_grants','information_schema.element_types','information_schema.user_mappings','information_schema.check_constraints','information_schema.domain_constraints','information_schema.foreign_data_wrappers','information_schema.triggered_update_columns','information_schema.view_table_usage','information_schema.sql_languages','information_schema.table_constraints','information_schema.udt_privileges','information_schema.foreign_data_wrapper_options','information_schema.applicable_roles','information_schema.enabled_roles','information_schema.routines','information_schema.user_mapping_options','information_schema.referential_constraints','information_schema.role_routine_grants','information_schema.triggers','information_schema.schemata','information_schema.key_column_usage','information_schema.tables','information_schema.data_type_privileges','information_schema.administrable_role_authorizations','information_schema.role_column_grants','information_schema.column_domain_usage','information_schema.sql_sizing')
My understanding is that this breakage affects PostgreSQL 12 on all operating systems.
![renovate[bot] avatar](https://avatars.githubusercontent.com/in/2740?v=4 "renovate[bot]")
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent