UPDATE "bus_presence" SET "last_poll" = '2024-06-22 11:33:26', "last_presence" = '2024-06-22 11:32:35.448095' WHERE id IN (246);

Date: 2024-06-22 11:33:44

x Hide

update product_warehouse_inventory set qty_shipped_not_invoiced = CASE WHEN 0.0 IS NOT NULL THEN GREATEST ((0.0 - 0.0) + (0.0 - 0.0), 0) ELSE GREATEST ((0.0 - 0.0), 0) END where product_id = 231176 and warehouse_id = 38 and company_id = 1;

Date: 2024-06-22 11:27:10

update product_warehouse_inventory set qty_shipped_not_invoiced = CASE WHEN 0.0 IS NOT NULL THEN GREATEST ((0.0 - 0.0) + (0.0 - 0.0), 0) ELSE GREATEST ((0.0 - 0.0), 0) END where product_id = 213480 and warehouse_id = 38 and company_id = 1;

Date: 2024-06-22 11:28:18

update product_warehouse_inventory set qty_shipped_not_invoiced = CASE WHEN 0.0 IS NOT NULL THEN GREATEST ((0.0 - 0.0) + (0.0 - 0.0), 0) ELSE GREATEST ((0.0 - 0.0), 0) END where product_id = 229781 and warehouse_id = 38 and company_id = 1;

Date: 2024-06-22 11:30:22

x Hide

Times Reported Time consuming queries #1

x Hide

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-06-22 06:34:04') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_965"'))) ORDER BY "bus_bus"."id";

Date: 2024-06-22 06:34:56
Duration: 2s168ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-06-22 06:34:04') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19585]', '["pointspring_master","mail.channel",572]', '["pointspring_master","res.partner",19585]', '["pointspring_master","ir.needaction",19585]'))) ORDER BY "bus_bus"."id";

Date: 2024-06-22 06:34:56
Duration: 1s950ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-06-22 17:34:28') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1021"', '["pointspring_master","calendar.alarm",19559]', '["pointspring_master","mail.channel",132]', '["pointspring_master","mail.channel",133]', '["pointspring_master","mail.channel",134]', '["pointspring_master","mail.channel",135]', '["pointspring_master","mail.channel",499]', '["pointspring_master","res.partner",19559]', '["pointspring_master","ir.needaction",19559]'))) ORDER BY "bus_bus"."id";

Date: 2024-06-22 17:35:18
Duration: 779ms

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

Date: 2024-06-22 09:01:06
Duration: 233ms

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

Date: 2024-06-22 10:13:36
Duration: 220ms

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

Date: 2024-06-22 13:04:51
Duration: 215ms

x Hide

Times Reported Time consuming queries #3

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-22 09:09:48
Duration: 3m52s

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-22 05:09:06
Duration: 3m52s

x Hide

Times Reported Time consuming queries #4

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-22 05:05:13
Duration: 2m15s

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-22 09:05:54
Duration: 1m48s

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-22 09:03:54
Duration: 1m58s

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-22 05:02:46
Duration: 1m58s