pgBadger-
Global information
- Generated on Thu Oct 24 13:28:01 2024
- Log file: out/error/postgresql.log.2024-10-24-0000, ..., out/error/postgresql.log.2024-10-24-1700
- Parsed 21,759 log entries in 38s
- Log start from 2024-10-24 00:00:23 to 2024-10-24 17:25:23
-
Overview
Global Stats
- 38 Number of unique normalized queries
- 36 Number of queries
- 5h8m43s Total query duration
- 2024-10-24 00:05:57 First query
- 2024-10-24 16:29:42 Last query
- 2 queries/s at 2024-10-24 11:20:03 Query peak
- 5h8m43s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h8m43s Execute total duration
- 6,321 Number of events
- 3 Number of unique normalized events
- 6,313 Max number of times the same event was reported
- 0 Number of cancellation
- 4 Total number of automatic vacuums
- 16 Total number of automatic analyzes
- 103 Number temporary file
- 188.16 MiB Max size of temporary file
- 130.86 MiB Average size of temporary file
- 0 Total number of sessions
- 0 sessions at Session peak
- 0ms Total duration of sessions
- 0ms Average duration of sessions
- 36 Average queries per session
- 5h8m43s Average queries duration per session
- n/a Average idle time per session
- 0 Total number of connections
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2024-10-24 11:20:03 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2024-10-24 11:16:10 Date
Queries duration
Key values
- 5h8m43s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 24 00 1 0ms 7m5s 7m5s 0ms 7m5s 7m5s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 1 0ms 13m4s 13m4s 0ms 0ms 13m4s 08 1 0ms 13m7s 13m7s 0ms 0ms 13m7s 09 1 0ms 14m20s 14m20s 0ms 0ms 14m20s 10 9 0ms 10m43s 7m1s 10m9s 11m53s 15m56s 11 16 0ms 26m22s 9m27s 11m52s 12m33s 26m22s 12 2 0ms 7m2s 6m58s 0ms 6m54s 7m2s 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 3 0ms 7m8s 6m38s 0ms 7m 7m8s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 2 0ms 7m 6m17s 0ms 5m33s 7m 17 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 24 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 24 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 2 0 0 0 5m20s 0ms 0ms 5m 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 24 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% Day Hour Count Average / Second Oct 24 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s Day Hour Count Average Duration Average idle time Oct 24 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 24 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 17 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 24 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Oct 24 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s Day Hour Mean distance Mean estimate Oct 24 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 752.66 MiB Temp Files size Peak
- 2024-10-24 09:40:50 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2024-10-24 09:40:50 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 24 00 0 0 0 01 0 0 0 02 3 396.96 MiB 132.32 MiB 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 33 3.60 GiB 111.84 MiB 08 43 5.01 GiB 119.35 MiB 09 24 4.16 GiB 177.47 MiB 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 45 4.91 GiB 111.52 MiB 112.33 MiB 111.77 MiB set local work_mem = ?; with deleted_maps as ( delete from api_data_custom_platform_info_to_custom_platform_info maps using api_data_customplatforminfoscratch_0 info_scratch where maps.main_platform_info_id = info_scratch.info_id returning maps.id), deleted_rules as ( delete from api_data_custom_platform_info_to_custom_platform_info_conne8ea3 rules_rel using deleted_maps where rules_rel.customplatforminfotocustomplatforminfo_id = deleted_maps.id returning rules_rel.id ) select ( select count(*) from deleted_maps) as deleted_maps_count, ( select count(*) from deleted_rules) as deleted_rules_count;-
SET LOCAL work_mem = '200.00MB'; WITH deleted_maps AS ( DELETE FROM api_data_custom_platform_info_to_custom_platform_info maps USING api_data_customplatforminfoscratch_0 info_scratch WHERE maps.main_platform_info_id = info_scratch.info_id RETURNING maps.id), deleted_rules AS ( DELETE FROM api_data_custom_platform_info_to_custom_platform_info_conne8ea3 rules_rel USING deleted_maps WHERE rules_rel.customplatforminfotocustomplatforminfo_id = deleted_maps.id RETURNING rules_rel.id ) SELECT ( SELECT COUNT(*) FROM deleted_maps) as deleted_maps_count, ( SELECT COUNT(*) FROM deleted_rules) AS deleted_rules_count;
Date: 2024-10-24 08:17:12 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.16
2 31 3.70 GiB 120.80 MiB 123.70 MiB 122.36 MiB set local work_mem = ?; with dropped_stats as ( delete from api_data_customplatformstats stats where stats.custom_platform_info_id in ( select info.id from api_data_customplatforminfo info inner join api_data_customplatforminfotoaccount info2account on info2account.custom_platform_info_id = info.id where info2account.account_id = ? and info.platform_id = ?) and stats.date in (...) returning stats.custom_platform_info_id, stats.id ) select distinct droppable_info.id from api_data_customplatforminfo droppable_info join dropped_stats on droppable_info.id = dropped_stats.custom_platform_info_id where not exists ( select ? from api_data_customplatformstats stats where stats.custom_platform_info_id = dropped_stats.custom_platform_info_id and stats.id <> dropped_stats.id);-
SET LOCAL work_mem = '200.00MB'; WITH dropped_stats AS ( DELETE from api_data_customplatformstats stats WHERE stats.custom_platform_info_id IN ( SELECT info.id from api_data_customplatforminfo info INNER JOIN api_data_customplatforminfotoaccount info2account on info2account.custom_platform_info_id = info.id WHERE info2account.account_id = 14285525 AND info.platform_id = 1277) AND stats.date in ('2024-10-17', '2024-10-18', '2024-10-19', '2024-10-20', '2024-10-21', '2024-10-22', '2024-10-23') RETURNING stats.custom_platform_info_id, stats.id ) SELECT DISTINCT droppable_info.id FROM api_data_customplatforminfo droppable_info JOIN dropped_stats ON droppable_info.id = dropped_stats.custom_platform_info_id WHERE NOT EXISTS ( SELECT 1 FROM api_data_customplatformstats stats WHERE stats.custom_platform_info_id = dropped_stats.custom_platform_info_id AND stats.id <> dropped_stats.id);
Date: 2024-10-24 08:03:15 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.16
3 10 1.84 GiB 188.16 MiB 188.16 MiB 188.16 MiB select count(*) from ( select case when "data_sets_datasettocolumn"."platform_breakdown_id" is not null then true else false end AS "has_platform_breakdown" from "data_sets_dataset" inner join "api_data_datasettoplatform" on ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") left outer join "data_sets_datasettocolumn" on ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") left outer join "data_sets_datasetsourcetoportfolio" on ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") left outer join "vayner_portfolio" on ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") left outer join "clients_account" on ("vayner_portfolio"."id" = "clients_account"."portfolio_id") left outer join "clients_campaign" on ("clients_account"."id" = "clients_campaign"."account_id") left outer join "campaign_daily_spend" on ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") where (not ("data_sets_dataset"."data_status" = ?) and not ("data_sets_dataset"."_cached_lifetime_end_date" <= ?::date and "data_sets_dataset"."_cached_lifetime_end_date" is not null and "data_sets_dataset"."date_range_source" = ?) and "api_data_datasettoplatform"."platform_id" = ? and "data_sets_dataset"."data_source_type" = ? and "data_sets_dataset"."data_status" = ? and not case when ("data_sets_datasettocolumn"."platform_breakdown_id" is not null) then true else false end) group by "data_sets_dataset"."id", ?, "data_sets_dataset"."last_refreshed" having "data_sets_dataset"."last_refreshed" < (max("campaign_daily_spend"."db_spend_last_updated"))) subquery;-
SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;
Date: 2024-10-24 09:39:11 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.102.130
4 10 1.84 GiB 188.16 MiB 188.16 MiB 188.16 MiB select "data_sets_dataset"."id" from "data_sets_dataset" inner join "api_data_datasettoplatform" on ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") left outer join "data_sets_datasettocolumn" on ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") left outer join "data_sets_datasetsourcetoportfolio" on ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") left outer join "vayner_portfolio" on ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") left outer join "clients_account" on ("vayner_portfolio"."id" = "clients_account"."portfolio_id") left outer join "clients_campaign" on ("clients_account"."id" = "clients_campaign"."account_id") left outer join "campaign_daily_spend" on ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") where (not ("data_sets_dataset"."data_status" = ?) and not ("data_sets_dataset"."_cached_lifetime_end_date" <= ?::date and "data_sets_dataset"."_cached_lifetime_end_date" is not null and "data_sets_dataset"."date_range_source" = ?) and "api_data_datasettoplatform"."platform_id" = ? and "data_sets_dataset"."data_source_type" = ? and "data_sets_dataset"."data_status" = ? and not case when ("data_sets_datasettocolumn"."platform_breakdown_id" is not null) then true else false end) group by "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" having "data_sets_dataset"."last_refreshed" < (max("campaign_daily_spend"."db_spend_last_updated"));-
SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));
Date: 2024-10-24 09:39:36 Duration: 0ms
5 6 793.92 MiB 122.89 MiB 141.23 MiB 132.32 MiB with camps_with_created as ( select camp.id, camp.account_id, max(map.created) as most_recent_map_created from clients_campaign camp join api_data_ga_platformobject po on po.gid = camp.gid join api_data_ga_map map on map.level_2_id = po.id where camp.platform_id = ? group by camp.id, camp.account_id ), untagged_most_recent_updated as ( select tag.tag_set_id, cache.updated as latest_untagged from buckets_tagtoplatformcache cache join buckets_tag tag on cache.tag_id = tag.id and tag.designation = ? where cache.platform_id = ? ) select distinct ts_pl_rel.id as tag_set_to_platform_level_id from buckets_tagsettoplatformlevel ts_pl_rel join platforms_platformlevel pl on pl.id = ts_pl_rel.platform_level_id and pl.platform_id = ? join (( select tag_set_id, most_recent_map_created from buckets_tagsettocampaign rel join camps_with_created camp on camp.id = rel.source_id) union all ( select tag_set_id, most_recent_map_created from buckets_tagsettoaccount rel join camps_with_created camp on camp.account_id = rel.source_id) union all ( select tagset.id as tag_set_id, most_recent_map_created from buckets_tagset tagset join vayner_portfolio port on tagset.portfolio_id = port.id join clients_account acc on acc.portfolio_id = port.id join camps_with_created camp on camp.account_id = acc.id where tagset.source_type = ?)) source_rel on source_rel.tag_set_id = ts_pl_rel.tag_set_id left join untagged_most_recent_updated untagged on untagged.tag_set_id = ts_pl_rel.tag_set_id where (source_rel.most_recent_map_created >= untagged.latest_untagged or untagged.latest_untagged is null);-
WITH camps_with_created AS ( SELECT camp.id, camp.account_id, MAX(map.created) AS most_recent_map_created FROM clients_campaign camp JOIN api_data_ga_platformobject po ON po.gid = camp.gid JOIN api_data_ga_map map ON map.level_2_id = po.id WHERE camp.platform_id = 18 GROUP BY camp.id, camp.account_id ), untagged_most_recent_updated AS ( SELECT tag.tag_set_id, cache.updated AS latest_untagged FROM buckets_tagtoplatformcache cache JOIN buckets_tag tag ON cache.tag_id = tag.id AND tag.designation = 2 WHERE cache.platform_id = 18 ) SELECT DISTINCT ts_pl_rel.id AS tag_set_to_platform_level_id FROM buckets_tagsettoplatformlevel ts_pl_rel JOIN platforms_platformlevel pl ON pl.id = ts_pl_rel.platform_level_id AND pl.platform_id = 18 JOIN (( SELECT tag_set_id, most_recent_map_created FROM buckets_tagsettocampaign rel JOIN camps_with_created camp ON camp.id = rel.source_id) UNION ALL ( SELECT tag_set_id, most_recent_map_created FROM buckets_tagsettoaccount rel JOIN camps_with_created camp ON camp.account_id = rel.source_id) UNION ALL ( SELECT tagset.id AS tag_set_id, most_recent_map_created FROM buckets_tagset tagset JOIN vayner_portfolio port ON tagset.portfolio_id = port.id JOIN clients_account acc ON acc.portfolio_id = port.id JOIN camps_with_created camp ON camp.account_id = acc.id WHERE tagset.source_type = 4)) source_rel ON source_rel.tag_set_id = ts_pl_rel.tag_set_id LEFT JOIN untagged_most_recent_updated untagged ON untagged.tag_set_id = ts_pl_rel.tag_set_id WHERE (source_rel.most_recent_map_created >= untagged.latest_untagged OR untagged.latest_untagged IS NULL);
Date: 2024-10-24 09:24:27 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.106.53
6 1 99.05 MiB 99.05 MiB 99.05 MiB 99.05 MiB with custom_platform_info as ( select id from "api_data_customplatforminfo" where "portfolio_id" = ? and "platform_id" = ? ) select distinct "api_data_customplatformstats"."custom_platform_info_id" from "api_data_customplatformstats" where ("api_data_customplatformstats"."platform_id" = ? and "api_data_customplatformstats"."date" >= ? and "api_data_customplatformstats"."date" <= ? and "api_data_customplatformstats"."custom_platform_info_id" in ( select id from custom_platform_info));-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-24 09:58:21 Duration: 14m20s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-24 09:58:21 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
Queries generating the largest temporary files
Rank Size Query 1 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:39:11 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.130 ]
2 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:39:12 ]
3 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:39:36 ]
4 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:39:36 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.130 ]
5 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 77 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:40:15 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.130 ]
6 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 77 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:40:23 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.130 ]
7 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 1 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:40:27 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.100.48 ]
8 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 1 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:40:28 ]
9 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 1 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:40:50 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.100.48 ]
10 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 1 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:40:50 ]
11 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:39:12 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.130 ]
12 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:39:37 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.130 ]
13 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 77 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:40:16 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.130 ]
14 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 77 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:40:24 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.130 ]
15 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 1 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:40:28 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.100.48 ]
16 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 1 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:40:50 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.100.48 ]
17 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:39:37 ]
18 188.16 MiB SELECT "data_sets_dataset"."id" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 1 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"));[ Date: 2024-10-24 09:40:50 ]
19 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 1 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:40:28 ]
20 188.16 MiB SELECT COUNT(*) FROM ( SELECT CASE WHEN "data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL THEN true ELSE false END AS "has_platform_breakdown" FROM "data_sets_dataset" INNER JOIN "api_data_datasettoplatform" ON ("data_sets_dataset"."id" = "api_data_datasettoplatform"."data_set_id") LEFT OUTER JOIN "data_sets_datasettocolumn" ON ("data_sets_dataset"."id" = "data_sets_datasettocolumn"."data_set_id") LEFT OUTER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") LEFT OUTER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") LEFT OUTER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") LEFT OUTER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") LEFT OUTER JOIN "campaign_daily_spend" ON ("clients_campaign"."id" = "campaign_daily_spend"."campaign_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-23'::date AND "data_sets_dataset"."_cached_lifetime_end_date" IS NOT NULL AND "data_sets_dataset"."date_range_source" = 2) AND "api_data_datasettoplatform"."platform_id" = 17 AND "data_sets_dataset"."data_source_type" = 4 AND "data_sets_dataset"."data_status" = 0 AND NOT CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_spend"."db_spend_last_updated"))) subquery;[ Date: 2024-10-24 09:39:12 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1361.01 sec Highest CPU-cost vacuum
Table public.api_data_customplatforminfo
Database sanofi_de84s4qcbsdrds - 2024-10-24 08:19:06 Date
- 0 sec Highest CPU-cost analyze
Table
Database sanofi_de84s4qcbsdrds - Date
Average Autovacuum Duration
Key values
- 1361.01 sec Highest CPU-cost vacuum
Table public.api_data_customplatforminfo
Database sanofi_de84s4qcbsdrds - 2024-10-24 08:19:06 Date
Analyzes per table
Key values
- public.data_sets_dataset (5) Main table analyzed (database sanofi_de84s4qcbsdrds)
- 16 analyzes Total
Table Number of analyzes sanofi_de84s4qcbsdrds.public.data_sets_dataset 5 sanofi_de84s4qcbsdrds.public.api_data_am_keyword_stats 4 sanofi_de84s4qcbsdrds.public.api_data_dcmfloodlightactivity 2 sanofi_de84s4qcbsdrds.public.api_data_am_campaign_stats 1 sanofi_de84s4qcbsdrds.public.buckets_tagtocustomplatforminfo_part_3052_1172 1 sanofi_de84s4qcbsdrds.public.api_data_fb_campaign_stats_platformbreakdown_placement 1 sanofi_de84s4qcbsdrds.public.api_data_customplatforminfo 1 sanofi_de84s4qcbsdrds.public.api_data_customplatformstats 1 Total 16 Vacuums per table
Key values
- public.api_data_am_keyword_stats (2) Main table vacuumed on database sanofi_de84s4qcbsdrds
- 4 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes sanofi_de84s4qcbsdrds.public.api_data_am_keyword_stats 2 2 1,902,003 0 0 2 42,970 0 0 0 sanofi_de84s4qcbsdrds.public.api_data_go_stats_platformbreakdown_conversion_name 1 1 925,996 0 0 0 401,617 0 0 0 sanofi_de84s4qcbsdrds.public.api_data_customplatforminfo 1 1 7,822,587 0 0 2 4,761,448 0 0 0 Total 4 4 10,650,586 1,304,821 0 4 5,206,035 0 0 0 Tuples removed per table
Key values
- public.api_data_am_keyword_stats (540638) Main table with removed tuples on database sanofi_de84s4qcbsdrds
- 786139 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain sanofi_de84s4qcbsdrds.public.api_data_am_keyword_stats 2 2 540,638 5,439,599 4,054 293 1,565,715 sanofi_de84s4qcbsdrds.public.api_data_customplatforminfo 1 1 156,933 35,922,438 0 0 9,162,767 sanofi_de84s4qcbsdrds.public.api_data_go_stats_platformbreakdown_conversion_name 1 1 88,568 7,334,313 15,011 0 637,425 Total 4 4 786,139 48,696,350 19,065 293 11,365,907 Pages removed per table
Key values
- public.api_data_am_keyword_stats (293) Main table with removed pages on database sanofi_de84s4qcbsdrds
- 293 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed sanofi_de84s4qcbsdrds.public.api_data_am_keyword_stats 2 2 540638 293 sanofi_de84s4qcbsdrds.public.api_data_go_stats_platformbreakdown_conversion_name 1 1 88568 0 sanofi_de84s4qcbsdrds.public.api_data_customplatforminfo 1 1 156933 0 Total 4 4 786,139 293 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 24 00 0 0 01 0 0 02 0 0 03 0 0 04 0 3 05 2 5 06 0 0 07 1 0 08 1 1 09 0 0 10 0 2 11 0 3 12 0 0 13 0 2 14 0 0 15 0 0 16 0 0 17 0 0 - 1361.01 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 0 Total read queries
- 3 Total write queries
Queries by database
Key values
- sanofi_de84s4qcbsdrds Main database
- 36 Requests
- 5h8m43s (sanofi_de84s4qcbsdrds)
- Main time consuming database
Queries by user
Key values
- u3m4c4715a71na Main user
- 36 Requests
User Request type Count Duration u3m4c4715a71na Total 36 5h8m43s cte 1 14m20s insert 2 10m40s others 33 4h43m43s Duration by user
Key values
- 5h8m43s (u3m4c4715a71na) Main time consuming user
User Request type Count Duration u3m4c4715a71na Total 36 5h8m43s cte 1 14m20s insert 2 10m40s others 33 4h43m43s Queries by host
Key values
- 10.24.99.232 Main host
- 6 Requests
- 1h6m55s (10.24.126.204)
- Main time consuming host
Host Request type Count Duration 10.24.100.162 Total 1 7m5s others 1 7m5s 10.24.102.202 Total 2 12m35s others 2 12m35s 10.24.105.153 Total 1 5m45s others 1 5m45s 10.24.110.202 Total 2 10m40s insert 2 10m40s 10.24.110.214 Total 1 9m53s others 1 9m53s 10.24.113.58 Total 1 5m58s others 1 5m58s 10.24.114.19 Total 1 7m8s others 1 7m8s 10.24.118.188 Total 2 14m59s others 2 14m59s 10.24.120.94 Total 4 26m18s others 4 26m18s 10.24.121.47 Total 1 7m others 1 7m 10.24.124.132 Total 4 30m3s others 4 30m3s 10.24.126.204 Total 3 1h6m55s cte 1 14m20s others 2 52m34s 10.24.164.107 Total 1 5m33s others 1 5m33s 10.24.180.221 Total 1 7m others 1 7m 10.24.188.16 Total 2 26m12s others 2 26m12s 10.24.96.137 Total 2 13m1s others 2 13m1s 10.24.99.173 Total 1 6m54s others 1 6m54s 10.24.99.232 Total 6 45m37s others 6 45m37s Queries by application
Key values
- unknown Main application
- 36 Requests
- 5h8m43s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-10-24 16:23:33 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 36 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 26m22s SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_20 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-12-31', 'YYYY-MM-DD') AND date <= to_date('2024-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 11:37:53 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.126.204 ]
2 26m12s SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 11:04:38 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.126.204 ]
3 14m20s WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));[ Date: 2024-10-24 09:58:21 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.126.204 ]
4 13m7s SET LOCAL work_mem = '200.00MB'; WITH deleted_infos AS ( DELETE FROM api_data_customplatforminfo info USING api_data_customplatforminfoscratch_0 info_to_delete WHERE info.id = info_to_delete.info_id RETURNING info.id, info.new_unique_field_key_id), inserted_infos AS ( INSERT INTO one_bigint_scratch_0 SELECT new_unique_field_key_id FROM deleted_infos ) SELECT COUNT(*) FROM deleted_infos;[ Date: 2024-10-24 08:16:49 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.188.16 ]
5 13m4s SET LOCAL work_mem = '200.00MB'; WITH deleted_infos AS ( DELETE FROM api_data_customplatforminfo info USING api_data_customplatforminfoscratch_0 info_to_delete WHERE info.id = info_to_delete.info_id RETURNING info.id, info.new_unique_field_key_id), inserted_infos AS ( INSERT INTO one_bigint_scratch_0 SELECT new_unique_field_key_id FROM deleted_infos ) SELECT COUNT(*) FROM deleted_infos;[ Date: 2024-10-24 07:56:22 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.188.16 ]
6 12m33s SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1", data ->> 'utid' AS "~PS2:utid:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = main.id;[ Date: 2024-10-24 11:22:07 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.99.232 ]
7 10m43s SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'full_page_url' AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> 'page_title' AS "~GA4-U13:page_title:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;[ Date: 2024-10-24 10:47:46 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.124.132 ]
8 10m19s SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'seller_name' AS "~PS2:seller_name:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_22 scratch ON scratch.object_id = main.id;[ Date: 2024-10-24 10:48:51 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.99.232 ]
9 9m53s SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_19 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 11:23:09 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.110.214 ]
10 8m25s SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'event_count' AS "~GA4-U7:event_count:custom_platform_stats:1", data ->> 'total_users' AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> 'screen_page_views' AS "~GA4-U7:screen_page_views:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');[ Date: 2024-10-24 11:17:38 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.120.94 ]
11 8m24s SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "GO:spend:stats:1", data ->> 'impressions' AS "GO:impressions:stats:1", data ->> 'total_video_quartile_p_100_views' AS "GO:total_video_quartile_p_100_views:stats:1", data ->> 'video_views' AS "GO:video_views:stats:1" FROM api_data_go_stats stats JOIN api_data_datasetfetchscratch_3 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');[ Date: 2024-10-24 11:19:20 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.118.188 ]
12 7m30s SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'page_title' AS "~GA4-U15:page_title:custom_platform_info:1", data ->> 'full_page_url' AS "~GA4-U15:full_page_url:custom_platform_info:1", data ->> 'event_name' AS "~GA4-U15:event_name:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U15:session_default_channel_group:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_20 scratch ON scratch.object_id = main.id;[ Date: 2024-10-24 10:46:11 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.102.202 ]
13 7m23s SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-24 10:24:28 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.120.94 ]
14 7m8s SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 14:45:34 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.114.19 ]
15 7m5s SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 00:05:57 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.100.162 ]
16 7m2s SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 12:13:34 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.96.137 ]
17 7m SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 16:29:42 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.180.221 ]
18 7m SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 14:08:51 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.121.47 ]
19 6m54s SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-24 12:51:52 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.99.173 ]
20 6m51s SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');[ Date: 2024-10-24 11:28:59 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.99.232 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 26m22s 1 26m22s 26m22s 26m22s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_20 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 24 11 1 26m22s 26m22s [ User: u3m4c4715a71na - Total duration: 26m22s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_20 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-12-31', 'YYYY-MM-DD') AND date <= to_date('2024-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:37:53 Duration: 26m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
2 26m12s 1 26m12s 26m12s 26m12s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_21 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 24 11 1 26m12s 26m12s [ User: u3m4c4715a71na - Total duration: 26m12s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:04:38 Duration: 26m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
3 26m12s 2 13m4s 13m7s 13m6s set local work_mem = ?; with deleted_infos as ( delete from api_data_customplatforminfo info using api_data_customplatforminfoscratch_0 info_to_delete where info.id = info_to_delete.info_id returning info.id, info.new_unique_field_key_id), inserted_infos as ( insert into one_bigint_scratch_0 select new_unique_field_key_id from deleted_infos ) select count(*) from deleted_infos;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 24 07 1 13m4s 13m4s 08 1 13m7s 13m7s [ User: u3m4c4715a71na - Total duration: 26m12s - Times executed: 2 ]
-
SET LOCAL work_mem = '200.00MB'; WITH deleted_infos AS ( DELETE FROM api_data_customplatforminfo info USING api_data_customplatforminfoscratch_0 info_to_delete WHERE info.id = info_to_delete.info_id RETURNING info.id, info.new_unique_field_key_id), inserted_infos AS ( INSERT INTO one_bigint_scratch_0 SELECT new_unique_field_key_id FROM deleted_infos ) SELECT COUNT(*) FROM deleted_infos;
Date: 2024-10-24 08:16:49 Duration: 13m7s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.16
-
SET LOCAL work_mem = '200.00MB'; WITH deleted_infos AS ( DELETE FROM api_data_customplatforminfo info USING api_data_customplatforminfoscratch_0 info_to_delete WHERE info.id = info_to_delete.info_id RETURNING info.id, info.new_unique_field_key_id), inserted_infos AS ( INSERT INTO one_bigint_scratch_0 SELECT new_unique_field_key_id FROM deleted_infos ) SELECT COUNT(*) FROM deleted_infos;
Date: 2024-10-24 07:56:22 Duration: 13m4s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.16
4 14m20s 1 14m20s 14m20s 14m20s with custom_platform_info as ( select id from "api_data_customplatforminfo" where "portfolio_id" = ? and "platform_id" = ? ) select distinct "api_data_customplatformstats"."custom_platform_info_id" from "api_data_customplatformstats" where ("api_data_customplatformstats"."platform_id" = ? and "api_data_customplatformstats"."date" >= ? and "api_data_customplatformstats"."date" <= ? and "api_data_customplatformstats"."custom_platform_info_id" in ( select id from custom_platform_info));Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 24 09 1 14m20s 14m20s [ User: u3m4c4715a71na - Total duration: 14m20s - Times executed: 1 ]
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-24 09:58:21 Duration: 14m20s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-24 09:58:21 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
5 14m8s 2 7m 7m8s 7m4s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 24 14 2 14m8s 7m4s [ User: u3m4c4715a71na - Total duration: 14m8s - Times executed: 2 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 14:45:34 Duration: 7m8s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.114.19
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 14:08:51 Duration: 7m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.121.47
6 12m33s 1 12m33s 12m33s 12m33s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1", data ->> ? AS "~PS2:utid:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_21 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 24 11 1 12m33s 12m33s [ User: u3m4c4715a71na - Total duration: 12m33s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1", data ->> 'utid' AS "~PS2:utid:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 11:22:07 Duration: 12m33s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
7 10m43s 1 10m43s 10m43s 10m43s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U13:session_default_channel_group:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_24 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 24 10 1 10m43s 10m43s [ User: u3m4c4715a71na - Total duration: 10m43s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'full_page_url' AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> 'page_title' AS "~GA4-U13:page_title:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:47:46 Duration: 10m43s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.124.132
8 10m28s 2 5m12s 5m16s 5m14s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 24 10 1 5m12s 5m12s 11 1 5m16s 5m16s [ User: u3m4c4715a71na - Total duration: 10m28s - Times executed: 2 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:09:05 Duration: 5m16s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 10:47:00 Duration: 5m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
9 10m19s 1 10m19s 10m19s 10m19s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:seller_name:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_22 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 24 10 1 10m19s 10m19s [ User: u3m4c4715a71na - Total duration: 10m19s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'seller_name' AS "~PS2:seller_name:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_22 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:48:51 Duration: 10m19s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
10 9m53s 1 9m53s 9m53s 9m53s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_19 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 24 11 1 9m53s 9m53s [ User: u3m4c4715a71na - Total duration: 9m53s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_19 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:23:09 Duration: 9m53s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.110.214
11 8m25s 1 8m25s 8m25s 8m25s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~GA4-U7:event_count:custom_platform_stats:1", data ->> ? AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:screen_page_views:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 24 11 1 8m25s 8m25s [ User: u3m4c4715a71na - Total duration: 8m25s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'event_count' AS "~GA4-U7:event_count:custom_platform_stats:1", data ->> 'total_users' AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> 'screen_page_views' AS "~GA4-U7:screen_page_views:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:17:38 Duration: 8m25s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
12 8m24s 1 8m24s 8m24s 8m24s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "GO:spend:stats:1", data ->> ? AS "GO:impressions:stats:1", data ->> ? AS "GO:total_video_quartile_p_100_views:stats:1", data ->> ? AS "GO:video_views:stats:1" from api_data_go_stats stats join api_data_datasetfetchscratch_3 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 24 11 1 8m24s 8m24s [ User: u3m4c4715a71na - Total duration: 8m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "GO:spend:stats:1", data ->> 'impressions' AS "GO:impressions:stats:1", data ->> 'total_video_quartile_p_100_views' AS "GO:total_video_quartile_p_100_views:stats:1", data ->> 'video_views' AS "GO:video_views:stats:1" FROM api_data_go_stats stats JOIN api_data_datasetfetchscratch_3 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:19:20 Duration: 8m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.118.188
13 7m30s 1 7m30s 7m30s 7m30s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U15:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U15:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U15:event_name:custom_platform_info:1", data ->> ? AS "~GA4-U15:session_default_channel_group:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_20 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 24 10 1 7m30s 7m30s [ User: u3m4c4715a71na - Total duration: 7m30s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'page_title' AS "~GA4-U15:page_title:custom_platform_info:1", data ->> 'full_page_url' AS "~GA4-U15:full_page_url:custom_platform_info:1", data ->> 'event_name' AS "~GA4-U15:event_name:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U15:session_default_channel_group:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_20 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:46:11 Duration: 7m30s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.102.202
14 7m23s 1 7m23s 7m23s 7m23s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_24 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 24 10 1 7m23s 7m23s [ User: u3m4c4715a71na - Total duration: 7m23s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-24 10:24:28 Duration: 7m23s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
15 7m5s 1 7m5s 7m5s 7m5s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_18 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 24 00 1 7m5s 7m5s [ User: u3m4c4715a71na - Total duration: 7m5s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 00:05:57 Duration: 7m5s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.100.162
16 7m2s 1 7m2s 7m2s 7m2s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 24 12 1 7m2s 7m2s [ User: u3m4c4715a71na - Total duration: 7m2s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 12:13:34 Duration: 7m2s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.96.137
17 7m 1 7m 7m 7m set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 24 16 1 7m 7m [ User: u3m4c4715a71na - Total duration: 7m - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 16:29:42 Duration: 7m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.180.221
18 6m54s 1 6m54s 6m54s 6m54s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 24 12 1 6m54s 6m54s [ User: u3m4c4715a71na - Total duration: 6m54s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 12:51:52 Duration: 6m54s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.173
19 6m51s 1 6m51s 6m51s 6m51s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_21 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 24 11 1 6m51s 6m51s [ User: u3m4c4715a71na - Total duration: 6m51s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:28:59 Duration: 6m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
20 6m48s 1 6m48s 6m48s 6m48s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 24 11 1 6m48s 6m48s [ User: u3m4c4715a71na - Total duration: 6m48s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:14:07 Duration: 6m48s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.124.132
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 26m12s 13m4s 13m7s 13m6s set local work_mem = ?; with deleted_infos as ( delete from api_data_customplatforminfo info using api_data_customplatforminfoscratch_0 info_to_delete where info.id = info_to_delete.info_id returning info.id, info.new_unique_field_key_id), inserted_infos as ( insert into one_bigint_scratch_0 select new_unique_field_key_id from deleted_infos ) select count(*) from deleted_infos;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 24 07 1 13m4s 13m4s 08 1 13m7s 13m7s [ User: u3m4c4715a71na - Total duration: 26m12s - Times executed: 2 ]
-
SET LOCAL work_mem = '200.00MB'; WITH deleted_infos AS ( DELETE FROM api_data_customplatforminfo info USING api_data_customplatforminfoscratch_0 info_to_delete WHERE info.id = info_to_delete.info_id RETURNING info.id, info.new_unique_field_key_id), inserted_infos AS ( INSERT INTO one_bigint_scratch_0 SELECT new_unique_field_key_id FROM deleted_infos ) SELECT COUNT(*) FROM deleted_infos;
Date: 2024-10-24 08:16:49 Duration: 13m7s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.16
-
SET LOCAL work_mem = '200.00MB'; WITH deleted_infos AS ( DELETE FROM api_data_customplatforminfo info USING api_data_customplatforminfoscratch_0 info_to_delete WHERE info.id = info_to_delete.info_id RETURNING info.id, info.new_unique_field_key_id), inserted_infos AS ( INSERT INTO one_bigint_scratch_0 SELECT new_unique_field_key_id FROM deleted_infos ) SELECT COUNT(*) FROM deleted_infos;
Date: 2024-10-24 07:56:22 Duration: 13m4s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.16
2 2 14m8s 7m 7m8s 7m4s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 24 14 2 14m8s 7m4s [ User: u3m4c4715a71na - Total duration: 14m8s - Times executed: 2 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 14:45:34 Duration: 7m8s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.114.19
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 14:08:51 Duration: 7m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.121.47
3 2 10m28s 5m12s 5m16s 5m14s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 24 10 1 5m12s 5m12s 11 1 5m16s 5m16s [ User: u3m4c4715a71na - Total duration: 10m28s - Times executed: 2 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:09:05 Duration: 5m16s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 10:47:00 Duration: 5m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
4 1 26m22s 26m22s 26m22s 26m22s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_20 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 24 11 1 26m22s 26m22s [ User: u3m4c4715a71na - Total duration: 26m22s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_20 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-12-31', 'YYYY-MM-DD') AND date <= to_date('2024-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:37:53 Duration: 26m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
5 1 26m12s 26m12s 26m12s 26m12s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_21 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 24 11 1 26m12s 26m12s [ User: u3m4c4715a71na - Total duration: 26m12s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:04:38 Duration: 26m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
6 1 14m20s 14m20s 14m20s 14m20s with custom_platform_info as ( select id from "api_data_customplatforminfo" where "portfolio_id" = ? and "platform_id" = ? ) select distinct "api_data_customplatformstats"."custom_platform_info_id" from "api_data_customplatformstats" where ("api_data_customplatformstats"."platform_id" = ? and "api_data_customplatformstats"."date" >= ? and "api_data_customplatformstats"."date" <= ? and "api_data_customplatformstats"."custom_platform_info_id" in ( select id from custom_platform_info));Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 24 09 1 14m20s 14m20s [ User: u3m4c4715a71na - Total duration: 14m20s - Times executed: 1 ]
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-24 09:58:21 Duration: 14m20s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-24 09:58:21 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
7 1 12m33s 12m33s 12m33s 12m33s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1", data ->> ? AS "~PS2:utid:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_21 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 24 11 1 12m33s 12m33s [ User: u3m4c4715a71na - Total duration: 12m33s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1", data ->> 'utid' AS "~PS2:utid:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 11:22:07 Duration: 12m33s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
8 1 10m43s 10m43s 10m43s 10m43s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U13:session_default_channel_group:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_24 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 24 10 1 10m43s 10m43s [ User: u3m4c4715a71na - Total duration: 10m43s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'full_page_url' AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> 'page_title' AS "~GA4-U13:page_title:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:47:46 Duration: 10m43s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.124.132
9 1 10m19s 10m19s 10m19s 10m19s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:seller_name:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_22 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 24 10 1 10m19s 10m19s [ User: u3m4c4715a71na - Total duration: 10m19s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'seller_name' AS "~PS2:seller_name:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_22 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:48:51 Duration: 10m19s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
10 1 9m53s 9m53s 9m53s 9m53s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_19 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 24 11 1 9m53s 9m53s [ User: u3m4c4715a71na - Total duration: 9m53s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_19 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:23:09 Duration: 9m53s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.110.214
11 1 8m25s 8m25s 8m25s 8m25s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~GA4-U7:event_count:custom_platform_stats:1", data ->> ? AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:screen_page_views:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 24 11 1 8m25s 8m25s [ User: u3m4c4715a71na - Total duration: 8m25s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'event_count' AS "~GA4-U7:event_count:custom_platform_stats:1", data ->> 'total_users' AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> 'screen_page_views' AS "~GA4-U7:screen_page_views:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:17:38 Duration: 8m25s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
12 1 8m24s 8m24s 8m24s 8m24s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "GO:spend:stats:1", data ->> ? AS "GO:impressions:stats:1", data ->> ? AS "GO:total_video_quartile_p_100_views:stats:1", data ->> ? AS "GO:video_views:stats:1" from api_data_go_stats stats join api_data_datasetfetchscratch_3 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 24 11 1 8m24s 8m24s [ User: u3m4c4715a71na - Total duration: 8m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "GO:spend:stats:1", data ->> 'impressions' AS "GO:impressions:stats:1", data ->> 'total_video_quartile_p_100_views' AS "GO:total_video_quartile_p_100_views:stats:1", data ->> 'video_views' AS "GO:video_views:stats:1" FROM api_data_go_stats stats JOIN api_data_datasetfetchscratch_3 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:19:20 Duration: 8m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.118.188
13 1 7m30s 7m30s 7m30s 7m30s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U15:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U15:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U15:event_name:custom_platform_info:1", data ->> ? AS "~GA4-U15:session_default_channel_group:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_20 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 24 10 1 7m30s 7m30s [ User: u3m4c4715a71na - Total duration: 7m30s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'page_title' AS "~GA4-U15:page_title:custom_platform_info:1", data ->> 'full_page_url' AS "~GA4-U15:full_page_url:custom_platform_info:1", data ->> 'event_name' AS "~GA4-U15:event_name:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U15:session_default_channel_group:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_20 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:46:11 Duration: 7m30s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.102.202
14 1 7m23s 7m23s 7m23s 7m23s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_24 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 24 10 1 7m23s 7m23s [ User: u3m4c4715a71na - Total duration: 7m23s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-24 10:24:28 Duration: 7m23s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
15 1 7m5s 7m5s 7m5s 7m5s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_18 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 24 00 1 7m5s 7m5s [ User: u3m4c4715a71na - Total duration: 7m5s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 00:05:57 Duration: 7m5s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.100.162
16 1 7m2s 7m2s 7m2s 7m2s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 24 12 1 7m2s 7m2s [ User: u3m4c4715a71na - Total duration: 7m2s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 12:13:34 Duration: 7m2s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.96.137
17 1 7m 7m 7m 7m set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 24 16 1 7m 7m [ User: u3m4c4715a71na - Total duration: 7m - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 16:29:42 Duration: 7m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.180.221
18 1 6m54s 6m54s 6m54s 6m54s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 24 12 1 6m54s 6m54s [ User: u3m4c4715a71na - Total duration: 6m54s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 12:51:52 Duration: 6m54s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.173
19 1 6m51s 6m51s 6m51s 6m51s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_21 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 24 11 1 6m51s 6m51s [ User: u3m4c4715a71na - Total duration: 6m51s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:28:59 Duration: 6m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
20 1 6m48s 6m48s 6m48s 6m48s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 24 11 1 6m48s 6m48s [ User: u3m4c4715a71na - Total duration: 6m48s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:14:07 Duration: 6m48s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.124.132
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 26m22s 26m22s 26m22s 1 26m22s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_20 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 24 11 1 26m22s 26m22s [ User: u3m4c4715a71na - Total duration: 26m22s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_20 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-12-31', 'YYYY-MM-DD') AND date <= to_date('2024-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:37:53 Duration: 26m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
2 26m12s 26m12s 26m12s 1 26m12s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_21 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 24 11 1 26m12s 26m12s [ User: u3m4c4715a71na - Total duration: 26m12s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:04:38 Duration: 26m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
3 14m20s 14m20s 14m20s 1 14m20s with custom_platform_info as ( select id from "api_data_customplatforminfo" where "portfolio_id" = ? and "platform_id" = ? ) select distinct "api_data_customplatformstats"."custom_platform_info_id" from "api_data_customplatformstats" where ("api_data_customplatformstats"."platform_id" = ? and "api_data_customplatformstats"."date" >= ? and "api_data_customplatformstats"."date" <= ? and "api_data_customplatformstats"."custom_platform_info_id" in ( select id from custom_platform_info));Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 24 09 1 14m20s 14m20s [ User: u3m4c4715a71na - Total duration: 14m20s - Times executed: 1 ]
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-24 09:58:21 Duration: 14m20s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-24 09:58:21 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.126.204
4 13m4s 13m7s 13m6s 2 26m12s set local work_mem = ?; with deleted_infos as ( delete from api_data_customplatforminfo info using api_data_customplatforminfoscratch_0 info_to_delete where info.id = info_to_delete.info_id returning info.id, info.new_unique_field_key_id), inserted_infos as ( insert into one_bigint_scratch_0 select new_unique_field_key_id from deleted_infos ) select count(*) from deleted_infos;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 24 07 1 13m4s 13m4s 08 1 13m7s 13m7s [ User: u3m4c4715a71na - Total duration: 26m12s - Times executed: 2 ]
-
SET LOCAL work_mem = '200.00MB'; WITH deleted_infos AS ( DELETE FROM api_data_customplatforminfo info USING api_data_customplatforminfoscratch_0 info_to_delete WHERE info.id = info_to_delete.info_id RETURNING info.id, info.new_unique_field_key_id), inserted_infos AS ( INSERT INTO one_bigint_scratch_0 SELECT new_unique_field_key_id FROM deleted_infos ) SELECT COUNT(*) FROM deleted_infos;
Date: 2024-10-24 08:16:49 Duration: 13m7s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.16
-
SET LOCAL work_mem = '200.00MB'; WITH deleted_infos AS ( DELETE FROM api_data_customplatforminfo info USING api_data_customplatforminfoscratch_0 info_to_delete WHERE info.id = info_to_delete.info_id RETURNING info.id, info.new_unique_field_key_id), inserted_infos AS ( INSERT INTO one_bigint_scratch_0 SELECT new_unique_field_key_id FROM deleted_infos ) SELECT COUNT(*) FROM deleted_infos;
Date: 2024-10-24 07:56:22 Duration: 13m4s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.16
5 12m33s 12m33s 12m33s 1 12m33s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1", data ->> ? AS "~PS2:utid:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_21 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 24 11 1 12m33s 12m33s [ User: u3m4c4715a71na - Total duration: 12m33s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1", data ->> 'utid' AS "~PS2:utid:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 11:22:07 Duration: 12m33s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
6 10m43s 10m43s 10m43s 1 10m43s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U13:session_default_channel_group:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_24 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 24 10 1 10m43s 10m43s [ User: u3m4c4715a71na - Total duration: 10m43s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'full_page_url' AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> 'page_title' AS "~GA4-U13:page_title:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:47:46 Duration: 10m43s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.124.132
7 10m19s 10m19s 10m19s 1 10m19s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:seller_name:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_22 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 24 10 1 10m19s 10m19s [ User: u3m4c4715a71na - Total duration: 10m19s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'seller_name' AS "~PS2:seller_name:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_22 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:48:51 Duration: 10m19s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
8 9m53s 9m53s 9m53s 1 9m53s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_19 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 24 11 1 9m53s 9m53s [ User: u3m4c4715a71na - Total duration: 9m53s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_19 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 11:23:09 Duration: 9m53s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.110.214
9 8m25s 8m25s 8m25s 1 8m25s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~GA4-U7:event_count:custom_platform_stats:1", data ->> ? AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:screen_page_views:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 24 11 1 8m25s 8m25s [ User: u3m4c4715a71na - Total duration: 8m25s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'event_count' AS "~GA4-U7:event_count:custom_platform_stats:1", data ->> 'total_users' AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> 'screen_page_views' AS "~GA4-U7:screen_page_views:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:17:38 Duration: 8m25s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
10 8m24s 8m24s 8m24s 1 8m24s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "GO:spend:stats:1", data ->> ? AS "GO:impressions:stats:1", data ->> ? AS "GO:total_video_quartile_p_100_views:stats:1", data ->> ? AS "GO:video_views:stats:1" from api_data_go_stats stats join api_data_datasetfetchscratch_3 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 24 11 1 8m24s 8m24s [ User: u3m4c4715a71na - Total duration: 8m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "GO:spend:stats:1", data ->> 'impressions' AS "GO:impressions:stats:1", data ->> 'total_video_quartile_p_100_views' AS "GO:total_video_quartile_p_100_views:stats:1", data ->> 'video_views' AS "GO:video_views:stats:1" FROM api_data_go_stats stats JOIN api_data_datasetfetchscratch_3 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:19:20 Duration: 8m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.118.188
11 7m30s 7m30s 7m30s 1 7m30s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U15:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U15:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U15:event_name:custom_platform_info:1", data ->> ? AS "~GA4-U15:session_default_channel_group:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_20 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 24 10 1 7m30s 7m30s [ User: u3m4c4715a71na - Total duration: 7m30s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'page_title' AS "~GA4-U15:page_title:custom_platform_info:1", data ->> 'full_page_url' AS "~GA4-U15:full_page_url:custom_platform_info:1", data ->> 'event_name' AS "~GA4-U15:event_name:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U15:session_default_channel_group:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_20 scratch ON scratch.object_id = main.id;
Date: 2024-10-24 10:46:11 Duration: 7m30s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.102.202
12 7m23s 7m23s 7m23s 1 7m23s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_24 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 24 10 1 7m23s 7m23s [ User: u3m4c4715a71na - Total duration: 7m23s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-24 10:24:28 Duration: 7m23s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
13 7m5s 7m5s 7m5s 1 7m5s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_18 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 24 00 1 7m5s 7m5s [ User: u3m4c4715a71na - Total duration: 7m5s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 00:05:57 Duration: 7m5s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.100.162
14 7m 7m8s 7m4s 2 14m8s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 24 14 2 14m8s 7m4s [ User: u3m4c4715a71na - Total duration: 14m8s - Times executed: 2 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 14:45:34 Duration: 7m8s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.114.19
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 14:08:51 Duration: 7m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.121.47
15 7m2s 7m2s 7m2s 1 7m2s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 24 12 1 7m2s 7m2s [ User: u3m4c4715a71na - Total duration: 7m2s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 12:13:34 Duration: 7m2s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.96.137
16 7m 7m 7m 1 7m set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 24 16 1 7m 7m [ User: u3m4c4715a71na - Total duration: 7m - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 16:29:42 Duration: 7m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.180.221
17 6m54s 6m54s 6m54s 1 6m54s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 24 12 1 6m54s 6m54s [ User: u3m4c4715a71na - Total duration: 6m54s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 12:51:52 Duration: 6m54s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.173
18 6m51s 6m51s 6m51s 1 6m51s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_21 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 24 11 1 6m51s 6m51s [ User: u3m4c4715a71na - Total duration: 6m51s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:28:59 Duration: 6m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.99.232
19 6m48s 6m48s 6m48s 1 6m48s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 24 11 1 6m48s 6m48s [ User: u3m4c4715a71na - Total duration: 6m48s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:14:07 Duration: 6m48s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.124.132
20 5m12s 5m16s 5m14s 2 10m28s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal" from api_data_customplatformstats stats join api_data_datasetfetchscratch_10 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 24 10 1 5m12s 5m12s 11 1 5m16s 5m16s [ User: u3m4c4715a71na - Total duration: 10m28s - Times executed: 2 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-24', 'YYYY-MM-DD');
Date: 2024-10-24 11:09:05 Duration: 5m16s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_10 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-24 10:47:00 Duration: 5m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.120.94
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 6,600 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
- 6320 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 6,313 Max number of times the same event was reported
- 6,321 Total events found
Rank Times reported Error 1 6,313 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 24 00 18 01 6 02 1,579 03 8 04 674 05 39 06 23 07 281 08 583 09 2,010 10 205 11 223 12 117 13 170 14 137 15 7 16 230 17 3 2 7 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 24 09 1 10 3 11 3 3 1 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 24 08 1 - ERROR: duplicate key value violates unique constraint "api_data_worker_scheduler_date_name_request_id_df285f03_uniq"
Detail: Key (scheduler, date, name, request_id)=(4, 2024-10-24, CUSTOM_PLATFORM_UPLOAD_APPLY_RULES, 552893) already exists.
Statement: INSERT INTO "api_data_worker" ("created", "updated", "scheduler", "date", "request_id", "queued_at", "work_start_at", "work_last_at", "work_stop_at", "is_rerunning", "name", "job_count", "status", "error_data", "finishing_kwargs", "scheduler_unique_id", "platform_short_name") VALUES ('2024-10-24T08:25:52.790262+00:00'::timestamptz, '2024-10-24T08:25:52.790277+00:00'::timestamptz, 4, '2024-10-24'::date, '552893', NULL, NULL, NULL, NULL, false, 'CUSTOM_PLATFORM_UPLOAD_APPLY_RULES', 0, 0, NULL, NULL, 'UserTaskScheduler:2024-10-24', NULL) RETURNING "api_data_worker"."id"Date: 2024-10-24 08:25:52 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.178.116