Times Reported Time consuming queries #1

x Hide

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-06-29 01:26:15') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","mail.channel",594]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";

Date: 2024-06-29 01:27:06
Duration: 835ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-06-29 17:30:40') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","mail.channel",553]', '["pointspring_master","mail.channel",617]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";

Date: 2024-06-29 17:31:30
Duration: 789ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-06-29 17:30:40') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19558]', '["pointspring_master","mail.channel",191]', '["pointspring_master","mail.channel",361]', '["pointspring_master","mail.channel",468]', '["pointspring_master","mail.channel",488]', '["pointspring_master","mail.channel",539]', '["pointspring_master","mail.channel",601]', '["pointspring_master","res.partner",19558]', '["pointspring_master","ir.needaction",19558]'))) ORDER BY "bus_bus"."id";

Date: 2024-06-29 17:31:30
Duration: 787ms

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

Date: 2024-06-29 17:31:30
Duration: 386ms

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

Date: 2024-06-29 04:10:58
Duration: 358ms

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

Date: 2024-06-29 00:37:13
Duration: 321ms

x Hide

Times Reported Time consuming queries #3

x Hide

select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2024-06-29 09:32:22
Duration: 2m21s

select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2024-06-29 09:32:22
Duration: 2m20s

select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2024-06-29 01:00:03
Duration: 1s183ms

x Hide

Times Reported Time consuming queries #4

x Hide

COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;

Date: 2024-06-29 09:10:31
Duration: 4m29s

x Hide

Times Reported Time consuming queries #5

x Hide

COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;

Date: 2024-06-29 09:03:55
Duration: 1m58s

x Hide

Times Reported Time consuming queries #6

x Hide

COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;

Date: 2024-06-29 09:06:00
Duration: 1m54s

x Hide

Times Reported Time consuming queries #7

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") DESC, "product_template"."id" DESC;

Date: 2024-06-29 21:46:15
Duration: 387ms

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") DESC, "product_template"."id" DESC;

Date: 2024-06-29 15:13:30
Duration: 360ms

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") DESC, "product_template"."id" DESC;

Date: 2024-06-29 16:12:24
Duration: 351ms