Times Reported Time consuming queries #1

x Hide

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-10-26 07:50:23') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1025"', '["pointspring_master","calendar.alarm",19563]', '["pointspring_master","mail.channel",249]', '["pointspring_master","mail.channel",250]', '["pointspring_master","mail.channel",251]', '["pointspring_master","mail.channel",451]', '["pointspring_master","mail.channel",460]', '["pointspring_master","mail.channel",513]', '["pointspring_master","mail.channel",624]', '["pointspring_master","res.partner",19563]', '["pointspring_master","ir.needaction",19563]'))) ORDER BY "bus_bus"."id";

Date: 2024-10-26 07:51:14
Duration: 919ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-10-26 18:17:11') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_974"', '["pointspring_master","calendar.alarm",19512]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",489]', '["pointspring_master","mail.channel",557]', '["pointspring_master","res.partner",19512]', '["pointspring_master","ir.needaction",19512]'))) ORDER BY "bus_bus"."id";

Date: 2024-10-26 18:18:02
Duration: 914ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-10-26 18:17:11') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",53355]', '["pointspring_master","res.partner",53355]', '["pointspring_master","ir.needaction",53355]'))) ORDER BY "bus_bus"."id";

Date: 2024-10-26 18:18:02
Duration: 889ms

x Hide

Times Reported Time consuming queries #2

x Hide

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 +0 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 ORDER BY 2, 3) AS s) AS s2) AS s3 where not is_na and schemaname || '.' || tblname in ('information_schema.applicable_roles', 'information_schema.column_column_usage', 'information_schema.referential_constraints', 'information_schema.constraint_column_usage', 'information_schema.sql_sizing', 'information_schema.usage_privileges', 'information_schema.routines', 'information_schema.views', 'information_schema.foreign_data_wrappers', 'information_schema.character_sets', 'information_schema.routine_routine_usage', 'information_schema.triggered_update_columns', 'information_schema.role_column_grants', 'information_schema.routine_column_usage', 'information_schema.domain_constraints', 'information_schema.sequences', 'information_schema.table_privileges', 'information_schema.role_udt_grants', 'information_schema.foreign_data_wrapper_options', 'information_schema.information_schema_catalog_name', 'information_schema.domain_udt_usage', 'information_schema.schemata', 'information_schema.sql_features', 'information_schema.triggers', 'information_schema.user_defined_types', 'information_schema.foreign_table_options', 'information_schema.column_udt_usage', 'information_schema.routine_privileges', 'information_schema.domains', 'information_schema.user_mappings', 'information_schema.foreign_tables', 'information_schema.column_domain_usage', 'information_schema.enabled_roles', 'information_schema.view_routine_usage', 'information_schema.key_column_usage', 'information_schema.routine_sequence_usage', 'information_schema.view_column_usage', 'information_schema.foreign_servers', 'information_schema.columns', 'information_schema.sql_implementation_info', 'information_schema.data_type_privileges', 'information_schema.foreign_server_options', 'information_schema.check_constraints', 'information_schema.collation_character_set_applicability', 'information_schema.parameters', 'information_schema.routine_table_usage', 'information_schema.role_table_grants', 'information_schema.constraint_table_usage', 'information_schema.view_table_usage', 'information_schema.check_constraint_routine_usage', 'information_schema.column_privileges', 'information_schema.udt_privileges', 'information_schema.user_mapping_options', 'information_schema.attributes', 'information_schema.collations', 'information_schema.role_routine_grants', 'information_schema.tables', 'information_schema.column_options', 'information_schema.administrable_role_authorizations', 'information_schema.table_constraints', 'information_schema.role_usage_grants', 'information_schema.element_types', 'public.pg_stat_statements_info', 'public.pg_stat_statements', 'pg_catalog.pg_statio_all_tables', 'pg_catalog.pg_ts_config_map', 'pg_catalog.pg_default_acl', 'pg_catalog.pg_stat_all_indexes', 'pg_catalog.pg_statio_user_indexes', 'pg_catalog.pg_available_extension_versions', 'pg_catalog.pg_operator', 'pg_catalog.pg_publication', 'pg_catalog.pg_stat_xact_all_tables', 'pg_catalog.pg_db_role_setting', 'pg_catalog.pg_ts_template', 'pg_catalog.pg_stat_gssapi', 'pg_catalog.pg_inherits', 'pg_catalog.pg_views', 'pg_catalog.pg_prepared_xacts', 'pg_catalog.pg_statio_all_indexes', 'pg_catalog.pg_stat_subscription', 'pg_catalog.pg_tablespace', 'pg_catalog.pg_attribute', 'pg_catalog.pg_stat_archiver', 'pg_catalog.pg_init_privs', 'pg_catalog.pg_range', 'pg_catalog.pg_stat_database', 'pg_catalog.pg_stat_database_conflicts', 'pg_catalog.pg_stat_progress_analyze', 'pg_catalog.pg_largeobject_metadata', 'pg_catalog.pg_collation', 'pg_catalog.pg_sequences', 'pg_catalog.pg_publication_tables', 'pg_catalog.pg_stat_user_tables', 'pg_catalog.pg_stat_wal_receiver', 'pg_catalog.pg_transform', 'pg_catalog.pg_proc', 'pg_catalog.pg_shdescription', 'pg_catalog.pg_policies', 'pg_catalog.pg_stats', 'pg_catalog.pg_seclabels', 'pg_catalog.pg_statio_sys_sequences', 'pg_catalog.pg_stat_wal', 'pg_catalog.pg_ts_parser', 'pg_catalog.pg_stat_sys_tables', 'pg_catalog.pg_language', 'pg_catalog.pg_index', 'pg_catalog.pg_stat_bgwriter', 'pg_catalog.pg_stat_xact_user_tables', 'pg_catalog.pg_shdepend', 'pg_catalog.pg_replication_origin', 'pg_catalog.pg_publication_rel', 'pg_catalog.pg_type', 'pg_catalog.pg_enum', 'pg_catalog.pg_statio_sys_indexes', 'pg_catalog.pg_auth_members', 'pg_catalog.pg_stat_replication_slots', 'pg_catalog.pg_namespace', 'pg_catalog.pg_foreign_data_wrapper', 'pg_catalog.pg_tables', 'pg_catalog.pg_timezone_abbrevs', 'pg_catalog.pg_statio_sys_tables', 'pg_catalog.pg_statio_all_sequences', 'pg_catalog.pg_statio_user_sequences', 'pg_catalog.pg_rewrite', 'pg_catalog.pg_sequence', 'pg_catalog.pg_indexes', 'pg_catalog.pg_locks', 'pg_catalog.pg_cursors', 'pg_catalog.pg_foreign_table', 'pg_catalog.pg_class', 'pg_catalog.pg_opclass', 'pg_catalog.pg_extension', 'pg_catalog.pg_subscription', 'pg_catalog.pg_stat_progress_cluster', 'pg_catalog.pg_event_trigger', 'pg_catalog.pg_policy', 'pg_catalog.pg_rules', 'pg_catalog.pg_stats_ext', 'pg_catalog.pg_stat_xact_user_functions', 'pg_catalog.pg_amop', 'pg_catalog.pg_trigger', 'pg_catalog.pg_constraint', 'pg_catalog.pg_stat_progress_create_index', 'pg_catalog.pg_cast', 'pg_catalog.pg_timezone_names', 'pg_catalog.pg_stat_user_functions', 'pg_catalog.pg_aggregate', 'pg_catalog.pg_description', 'pg_catalog.pg_database', 'pg_catalog.pg_user', 'pg_catalog.pg_user_mappings', 'pg_catalog.pg_amproc', 'pg_catalog.pg_stat_progress_copy', 'pg_catalog.pg_ts_config', 'pg_catalog.pg_matviews', 'pg_catalog.pg_stat_ssl', 'pg_catalog.pg_group', 'pg_catalog.pg_prepared_statements', 'pg_catalog.pg_stat_sys_indexes', 'pg_catalog.pg_settings', 'pg_catalog.pg_available_extensions', 'pg_catalog.pg_stat_xact_sys_tables', 'pg_catalog.pg_attrdef', 'pg_catalog.pg_opfamily', 'pg_catalog.pg_seclabel', 'pg_catalog.pg_stat_user_indexes', 'pg_catalog.pg_stat_activity', 'pg_catalog.pg_stat_progress_basebackup', 'pg_catalog.pg_statistic_ext', 'pg_catalog.pg_conversion', 'pg_catalog.pg_stat_slru', 'pg_catalog.pg_roles', 'pg_catalog.pg_stat_progress_vacuum', 'pg_catalog.pg_foreign_server', 'pg_catalog.pg_shseclabel', 'pg_catalog.pg_subscription_rel', 'pg_catalog.pg_stats_ext_exprs', 'pg_catalog.pg_replication_slots', 'pg_catalog.pg_depend', 'pg_catalog.pg_ts_dict', 'pg_catalog.pg_am', 'pg_catalog.pg_partitioned_table', 'pg_catalog.pg_stat_all_tables', 'pg_catalog.pg_statio_user_tables', 'pg_catalog.pg_stat_replication');

Date: 2024-10-26 07:55:10
Duration: 258ms

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 +0 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 ORDER BY 2, 3) AS s) AS s2) AS s3 where not is_na and schemaname || '.' || tblname in ('pg_catalog.pg_ts_config', 'pg_catalog.pg_database', 'pg_catalog.pg_stat_bgwriter', 'pg_catalog.pg_stat_wal', 'pg_catalog.pg_enum', 'pg_catalog.pg_stats', 'pg_catalog.pg_statio_user_sequences', 'pg_catalog.pg_operator', 'pg_catalog.pg_trigger', 'pg_catalog.pg_cursors', 'pg_catalog.pg_attrdef', 'pg_catalog.pg_depend', 'pg_catalog.pg_seclabels', 'pg_catalog.pg_statio_sys_tables', 'pg_catalog.pg_stat_database_conflicts', 'pg_catalog.pg_subscription', 'pg_catalog.pg_foreign_data_wrapper', 'pg_catalog.pg_subscription_rel', 'pg_catalog.pg_stat_all_indexes', 'pg_catalog.pg_shdescription', 'pg_catalog.pg_stat_all_tables', 'pg_catalog.pg_policies', 'pg_catalog.pg_views', 'pg_catalog.pg_stat_xact_user_tables', 'pg_catalog.pg_inherits', 'pg_catalog.pg_init_privs', 'pg_catalog.pg_transform', 'pg_catalog.pg_rules', 'pg_catalog.pg_stats_ext_exprs', 'pg_catalog.pg_user_mappings', 'pg_catalog.pg_amproc', 'pg_catalog.pg_ts_config_map', 'pg_catalog.pg_statio_user_tables', 'pg_catalog.pg_statio_all_indexes', 'pg_catalog.pg_stat_replication', 'pg_catalog.pg_constraint', 'pg_catalog.pg_language', 'pg_catalog.pg_user', 'pg_catalog.pg_attribute', 'pg_catalog.pg_ts_template', 'pg_catalog.pg_timezone_names', 'pg_catalog.pg_stat_xact_user_functions', 'pg_catalog.pg_range', 'pg_catalog.pg_ts_dict', 'pg_catalog.pg_statio_sys_sequences', 'pg_catalog.pg_am', 'pg_catalog.pg_largeobject_metadata', 'pg_catalog.pg_statio_all_tables', 'pg_catalog.pg_rewrite', 'pg_catalog.pg_namespace', 'pg_catalog.pg_auth_members', 'pg_catalog.pg_publication', 'pg_catalog.pg_available_extensions', 'pg_catalog.pg_proc', 'pg_catalog.pg_stat_progress_copy', 'pg_catalog.pg_partitioned_table', 'pg_catalog.pg_sequences', 'pg_catalog.pg_replication_slots', 'pg_catalog.pg_class', 'pg_catalog.pg_opclass', 'pg_catalog.pg_description', 'pg_catalog.pg_shdepend', 'pg_catalog.pg_ts_parser', 'pg_catalog.pg_publication_tables', 'pg_catalog.pg_stat_user_indexes', 'pg_catalog.pg_index', 'pg_catalog.pg_statistic_ext', 'pg_catalog.pg_settings', 'pg_catalog.pg_stat_progress_vacuum', 'pg_catalog.pg_statio_sys_indexes', 'pg_catalog.pg_opfamily', 'pg_catalog.pg_event_trigger', 'pg_catalog.pg_stat_gssapi', 'pg_catalog.pg_stat_progress_create_index', 'pg_catalog.pg_stat_xact_sys_tables', 'pg_catalog.pg_available_extension_versions', 'pg_catalog.pg_indexes', 'pg_catalog.pg_stat_sys_tables', 'pg_catalog.pg_foreign_table', 'pg_catalog.pg_roles', 'pg_catalog.pg_stat_slru', 'pg_catalog.pg_db_role_setting', 'pg_catalog.pg_prepared_xacts', 'pg_catalog.pg_prepared_statements', 'pg_catalog.pg_stat_activity', 'pg_catalog.pg_stat_subscription', 'pg_catalog.pg_stat_user_functions', 'pg_catalog.pg_group', 'pg_catalog.pg_seclabel', 'pg_catalog.pg_tables', 'pg_catalog.pg_stat_xact_all_tables', 'pg_catalog.pg_extension', 'pg_catalog.pg_foreign_server', 'pg_catalog.pg_matviews', 'pg_catalog.pg_stats_ext', 'pg_catalog.pg_type', 'pg_catalog.pg_stat_progress_analyze', 'pg_catalog.pg_conversion', 'pg_catalog.pg_stat_replication_slots', 'pg_catalog.pg_amop', 'pg_catalog.pg_stat_archiver', 'pg_catalog.pg_sequence', 'pg_catalog.pg_shseclabel', 'pg_catalog.pg_publication_rel', 'pg_catalog.pg_locks', 'pg_catalog.pg_stat_sys_indexes', 'pg_catalog.pg_replication_origin', 'pg_catalog.pg_default_acl', 'pg_catalog.pg_stat_user_tables', 'pg_catalog.pg_statio_all_sequences', 'pg_catalog.pg_stat_database', 'pg_catalog.pg_aggregate', 'pg_catalog.pg_policy', 'pg_catalog.pg_timezone_abbrevs', 'pg_catalog.pg_stat_wal_receiver', 'pg_catalog.pg_tablespace', 'pg_catalog.pg_stat_progress_basebackup', 'pg_catalog.pg_collation', 'pg_catalog.pg_statio_user_indexes', 'pg_catalog.pg_stat_ssl', 'pg_catalog.pg_stat_progress_cluster', 'pg_catalog.pg_cast', 'information_schema.data_type_privileges', 'information_schema.check_constraint_routine_usage', 'information_schema.column_column_usage', 'information_schema.domain_udt_usage', 'information_schema.referential_constraints', 'information_schema.administrable_role_authorizations', 'information_schema.role_table_grants', 'information_schema.user_mappings', 'information_schema.user_mapping_options', 'information_schema.information_schema_catalog_name', 'information_schema.view_table_usage', 'information_schema.routine_routine_usage', 'information_schema.sql_features', 'information_schema.usage_privileges', 'information_schema.foreign_servers', 'information_schema.sql_sizing', 'information_schema.routine_privileges', 'information_schema.domains', 'information_schema.column_options', 'information_schema.check_constraints', 'information_schema.foreign_data_wrappers', 'information_schema.foreign_table_options', 'information_schema.foreign_tables', 'information_schema.columns', 'information_schema.sequences', 'information_schema.user_defined_types', 'information_schema.triggered_update_columns', 'information_schema.column_domain_usage', 'information_schema.column_udt_usage', 'information_schema.schemata', 'information_schema.table_constraints', 'information_schema.parameters', 'information_schema.sql_implementation_info', 'information_schema.udt_privileges', 'information_schema.column_privileges', 'information_schema.constraint_column_usage', 'information_schema.constraint_table_usage', 'information_schema.tables', 'information_schema.collations', 'information_schema.role_usage_grants', 'information_schema.view_routine_usage', 'information_schema.applicable_roles', 'information_schema.role_routine_grants', 'information_schema.routine_table_usage', 'information_schema.triggers', 'information_schema.routine_sequence_usage', 'information_schema.views', 'information_schema.foreign_data_wrapper_options', 'information_schema.attributes', 'information_schema.collation_character_set_applicability', 'information_schema.routine_column_usage', 'information_schema.enabled_roles', 'information_schema.role_udt_grants', 'information_schema.element_types', 'information_schema.character_sets', 'information_schema.role_column_grants', 'information_schema.domain_constraints', 'information_schema.table_privileges', 'information_schema.routines', 'information_schema.key_column_usage', 'information_schema.view_column_usage', 'information_schema.foreign_server_options', 'public.pg_stat_statements_info', 'public.pg_stat_statements');

Date: 2024-10-26 08:43:55
Duration: 243ms

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 +0 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 ORDER BY 2, 3) AS s) AS s2) AS s3 where not is_na and schemaname || '.' || tblname in ('information_schema.element_types', 'information_schema.view_column_usage', 'information_schema.column_udt_usage', 'information_schema.routine_privileges', 'information_schema.referential_constraints', 'information_schema.view_table_usage', 'information_schema.information_schema_catalog_name', 'information_schema.sql_features', 'information_schema.column_options', 'information_schema.user_mapping_options', 'information_schema.constraint_column_usage', 'information_schema.routine_column_usage', 'information_schema.parameters', 'information_schema.role_udt_grants', 'information_schema.foreign_data_wrapper_options', 'information_schema.routines', 'information_schema.table_privileges', 'information_schema.usage_privileges', 'information_schema.character_sets', 'information_schema.domains', 'information_schema.role_usage_grants', 'information_schema.administrable_role_authorizations', 'information_schema.column_column_usage', 'information_schema.schemata', 'information_schema.view_routine_usage', 'information_schema.applicable_roles', 'information_schema.user_mappings', 'information_schema.foreign_servers', 'information_schema.foreign_tables', 'information_schema.enabled_roles', 'information_schema.triggers', 'information_schema.user_defined_types', 'information_schema.foreign_table_options', 'information_schema.foreign_server_options', 'information_schema.attributes', 'information_schema.domain_constraints', 'information_schema.routine_routine_usage', 'information_schema.role_column_grants', 'information_schema.sql_sizing', 'information_schema.foreign_data_wrappers', 'information_schema.tables', 'information_schema.data_type_privileges', 'information_schema.collations', 'information_schema.collation_character_set_applicability', 'information_schema.column_domain_usage', 'information_schema.key_column_usage', 'information_schema.routine_sequence_usage', 'information_schema.columns', 'information_schema.constraint_table_usage', 'information_schema.domain_udt_usage', 'information_schema.sequences', 'information_schema.role_routine_grants', 'information_schema.sql_implementation_info', 'information_schema.udt_privileges', 'information_schema.check_constraints', 'information_schema.column_privileges', 'information_schema.role_table_grants', 'information_schema.views', 'information_schema.check_constraint_routine_usage', 'information_schema.routine_table_usage', 'information_schema.table_constraints', 'information_schema.triggered_update_columns', 'public.pg_stat_statements_info', 'public.pg_stat_statements', 'pg_catalog.pg_stat_replication_slots', 'pg_catalog.pg_stat_sys_tables', 'pg_catalog.pg_timezone_names', 'pg_catalog.pg_user_mappings', 'pg_catalog.pg_trigger', 'pg_catalog.pg_sequences', 'pg_catalog.pg_cursors', 'pg_catalog.pg_stats_ext', 'pg_catalog.pg_roles', 'pg_catalog.pg_opclass', 'pg_catalog.pg_depend', 'pg_catalog.pg_proc', 'pg_catalog.pg_init_privs', 'pg_catalog.pg_stat_sys_indexes', 'pg_catalog.pg_constraint', 'pg_catalog.pg_sequence', 'pg_catalog.pg_statio_all_indexes', 'pg_catalog.pg_foreign_server', 'pg_catalog.pg_stat_replication', 'pg_catalog.pg_stat_subscription', 'pg_catalog.pg_settings', 'pg_catalog.pg_operator', 'pg_catalog.pg_description', 'pg_catalog.pg_stat_user_tables', 'pg_catalog.pg_replication_slots', 'pg_catalog.pg_subscription', 'pg_catalog.pg_database', 'pg_catalog.pg_subscription_rel', 'pg_catalog.pg_locks', 'pg_catalog.pg_inherits', 'pg_catalog.pg_ts_parser', 'pg_catalog.pg_stats', 'pg_catalog.pg_stat_xact_user_tables', 'pg_catalog.pg_db_role_setting', 'pg_catalog.pg_matviews', 'pg_catalog.pg_rules', 'pg_catalog.pg_attrdef', 'pg_catalog.pg_stat_archiver', 'pg_catalog.pg_stats_ext_exprs', 'pg_catalog.pg_stat_xact_sys_tables', 'pg_catalog.pg_auth_members', 'pg_catalog.pg_range', 'pg_catalog.pg_policies', 'pg_catalog.pg_amop', 'pg_catalog.pg_stat_activity', 'pg_catalog.pg_views', 'pg_catalog.pg_foreign_table', 'pg_catalog.pg_language', 'pg_catalog.pg_rewrite', 'pg_catalog.pg_stat_all_indexes', 'pg_catalog.pg_foreign_data_wrapper', 'pg_catalog.pg_prepared_statements', 'pg_catalog.pg_statio_user_tables', 'pg_catalog.pg_available_extensions', 'pg_catalog.pg_statistic_ext', 'pg_catalog.pg_conversion', 'pg_catalog.pg_shdescription', 'pg_catalog.pg_largeobject_metadata', 'pg_catalog.pg_shdepend', 'pg_catalog.pg_publication', 'pg_catalog.pg_class', 'pg_catalog.pg_cast', 'pg_catalog.pg_statio_sys_indexes', 'pg_catalog.pg_stat_database_conflicts', 'pg_catalog.pg_group', 'pg_catalog.pg_extension', 'pg_catalog.pg_transform', 'pg_catalog.pg_statio_sys_sequences', 'pg_catalog.pg_policy', 'pg_catalog.pg_publication_tables', 'pg_catalog.pg_statio_all_tables', 'pg_catalog.pg_stat_user_indexes', 'pg_catalog.pg_stat_bgwriter', 'pg_catalog.pg_stat_progress_create_index', 'pg_catalog.pg_aggregate', 'pg_catalog.pg_stat_wal_receiver', 'pg_catalog.pg_stat_wal', 'pg_catalog.pg_stat_progress_analyze', 'pg_catalog.pg_ts_config_map', 'pg_catalog.pg_ts_dict', 'pg_catalog.pg_indexes', 'pg_catalog.pg_stat_slru', 'pg_catalog.pg_publication_rel', 'pg_catalog.pg_stat_progress_basebackup', 'pg_catalog.pg_stat_progress_copy', 'pg_catalog.pg_collation', 'pg_catalog.pg_stat_xact_all_tables', 'pg_catalog.pg_index', 'pg_catalog.pg_ts_template', 'pg_catalog.pg_prepared_xacts', 'pg_catalog.pg_partitioned_table', 'pg_catalog.pg_stat_all_tables', 'pg_catalog.pg_opfamily', 'pg_catalog.pg_seclabel', 'pg_catalog.pg_shseclabel', 'pg_catalog.pg_stat_ssl', 'pg_catalog.pg_am', 'pg_catalog.pg_enum', 'pg_catalog.pg_namespace', 'pg_catalog.pg_ts_config', 'pg_catalog.pg_user', 'pg_catalog.pg_statio_all_sequences', 'pg_catalog.pg_attribute', 'pg_catalog.pg_amproc', 'pg_catalog.pg_timezone_abbrevs', 'pg_catalog.pg_statio_user_indexes', 'pg_catalog.pg_type', 'pg_catalog.pg_available_extension_versions', 'pg_catalog.pg_seclabels', 'pg_catalog.pg_default_acl', 'pg_catalog.pg_stat_user_functions', 'pg_catalog.pg_stat_progress_vacuum', 'pg_catalog.pg_event_trigger', 'pg_catalog.pg_replication_origin', 'pg_catalog.pg_statio_sys_tables', 'pg_catalog.pg_statio_user_sequences', 'pg_catalog.pg_stat_gssapi', 'pg_catalog.pg_stat_database', 'pg_catalog.pg_tablespace', 'pg_catalog.pg_stat_xact_user_functions', 'pg_catalog.pg_stat_progress_cluster', 'pg_catalog.pg_tables');

Date: 2024-10-26 10:28:55
Duration: 238ms

x Hide

Times Reported Time consuming queries #3

x Hide

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;

Date: 2024-10-26 06:27:13
Duration: 715ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;

Date: 2024-10-26 13:04:20
Duration: 690ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;

Date: 2024-10-26 10:24:45
Duration: 526ms

x Hide

Times Reported Time consuming queries #4