pgBadger-
Global information
- Generated on Wed Oct 30 14:37:26 2024
- Log file: out/error/postgresql.log.2024-10-30-0000, ..., out/error/postgresql.log.2024-10-30-1800
- Parsed 22,016 log entries in 38s
- Log start from 2024-10-30 00:00:34 to 2024-10-30 18:34:22
-
Overview
Global Stats
- 26 Number of unique normalized queries
- 22 Number of queries
- 3h30m19s Total query duration
- 2024-10-30 00:05:07 First query
- 2024-10-30 18:05:52 Last query
- 1 queries/s at 2024-10-30 10:41:32 Query peak
- 3h30m19s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h30m19s Execute total duration
- 6,396 Number of events
- 4 Number of unique normalized events
- 6,388 Max number of times the same event was reported
- 0 Number of cancellation
- 4 Total number of automatic vacuums
- 19 Total number of automatic analyzes
- 105 Number temporary file
- 188.28 MiB Max size of temporary file
- 131.50 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
- 22 Average queries per session
- 3h30m19s 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
- 1 queries/s Query Peak
- 2024-10-30 10:41:32 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 3h30m19s 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 30 00 1 0ms 6m17s 6m17s 0ms 6m17s 6m17s 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 11m53s 11m53s 0ms 0ms 11m53s 08 1 0ms 13m41s 13m41s 0ms 0ms 13m41s 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 11 0ms 14m37s 7m13s 7m12s 8m5s 14m37s 11 1 0ms 5m38s 5m38s 0ms 0ms 5m38s 12 1 0ms 7m13s 7m13s 0ms 0ms 7m13s 13 1 0ms 16m52s 16m52s 0ms 16m52s 16m52s 14 2 0ms 41m50s 24m6s 0ms 0ms 41m50s 15 1 0ms 6m45s 6m45s 0ms 6m45s 6m45s 16 1 0ms 6m51s 6m51s 0ms 0ms 6m51s 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 7m20s 7m20s 7m20s 7m20s 7m20s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 30 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 18 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 30 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 0 0 0 0 0ms 0ms 0ms 0ms 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 18 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 30 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% 18 0 0 0.00 0.00% Day Hour Count Average / Second Oct 30 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 18 0 0.00/s Day Hour Count Average Duration Average idle time Oct 30 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 18 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 30 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 18 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 30 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 18 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Oct 30 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 18 0 0s Day Hour Mean distance Mean estimate Oct 30 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 18 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 753.12 MiB Temp Files size Peak
- 2024-10-30 09:25:39 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2024-10-30 09:25:39 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 30 00 0 0 0 01 0 0 0 02 0 0 0 03 3 396.96 MiB 132.32 MiB 04 0 0 0 05 0 0 0 06 0 0 0 07 64 7.38 GiB 118.03 MiB 08 15 1.65 GiB 112.93 MiB 09 23 4.06 GiB 180.98 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 18 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 48 5.31 GiB 112.88 MiB 113.98 MiB 113.18 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-30 08:09:25 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.78
2 31 3.73 GiB 121.52 MiB 124.44 MiB 123.08 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-23', '2024-10-24', '2024-10-25', '2024-10-26', '2024-10-27', '2024-10-28', '2024-10-29') 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-30 07:54:55 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.78
3 10 1.84 GiB 188.28 MiB 188.28 MiB 188.28 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-29'::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-30 09:23:52 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.183.127
4 10 1.84 GiB 188.28 MiB 188.28 MiB 188.28 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-29'::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-30 09:23:44 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.183.127
5 6 793.91 MiB 129.78 MiB 135.91 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-30 09:11:25 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.97
Queries generating the largest temporary files
Rank Size Query 1 188.28 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-29'::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-30 09:23:44 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.127 ]
2 188.28 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-29'::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-30 09:23:52 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.127 ]
3 188.28 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-29'::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-30 09:24:06 ]
4 188.28 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-29'::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-30 09:24:05 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.127 ]
5 188.28 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-29'::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-30 09:24:27 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.127 ]
6 188.28 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-29'::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-30 09:24:27 ]
7 188.28 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-29'::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-30 09:25:17 ]
8 188.28 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-29'::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-30 09:25:17 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.162.119 ]
9 188.28 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-29'::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-30 09:25:39 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.162.119 ]
10 188.28 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-29'::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-30 09:25:39 ]
11 188.28 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-29'::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-30 09:23:45 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.127 ]
12 188.28 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-29'::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-30 09:23:53 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.127 ]
13 188.28 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-29'::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-30 09:24:06 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.127 ]
14 188.28 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-29'::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-30 09:24:27 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.127 ]
15 188.28 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-29'::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-30 09:25:17 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.162.119 ]
16 188.28 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-29'::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-30 09:25:39 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.162.119 ]
17 188.28 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-29'::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-30 09:24:28 ]
18 188.28 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-29'::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-30 09:25:39 ]
19 188.28 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-29'::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-30 09:25:17 ]
20 188.28 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-29'::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-30 09:24:06 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 21.39 sec Highest CPU-cost vacuum
Table public.api_data_am_keyword_stats
Database sanofi_de84s4qcbsdrds - 2024-10-30 05:52:03 Date
- 0 sec Highest CPU-cost analyze
Table
Database sanofi_de84s4qcbsdrds - Date
Average Autovacuum Duration
Key values
- 21.39 sec Highest CPU-cost vacuum
Table public.api_data_am_keyword_stats
Database sanofi_de84s4qcbsdrds - 2024-10-30 05:52:03 Date
Analyzes per table
Key values
- public.data_sets_dataset (6) Main table analyzed (database sanofi_de84s4qcbsdrds)
- 19 analyzes Total
Table Number of analyzes sanofi_de84s4qcbsdrds.public.data_sets_dataset 6 sanofi_de84s4qcbsdrds.public.api_data_am_keyword_stats 4 sanofi_de84s4qcbsdrds.public.api_data_dcmfloodlightactivity 2 sanofi_de84s4qcbsdrds.public.api_data_am_keyword_info 1 sanofi_de84s4qcbsdrds.public.api_data_customplatformstats 1 sanofi_de84s4qcbsdrds.public.api_data_customplatformuniquefieldkey_1173 1 sanofi_de84s4qcbsdrds.public.api_data_am_campaign_stats 1 sanofi_de84s4qcbsdrds.public.buckets_tagtocustomplatforminfo_part_3052_1172 1 sanofi_de84s4qcbsdrds.public.api_data_customplatforminfo 1 sanofi_de84s4qcbsdrds.public.api_data_customplatformuniquefieldkey_1172 1 Total 19 Vacuums per table
Key values
- public.api_data_am_keyword_stats (3) 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 3 3 3,106,487 0 0 3 56,624 0 0 0 sanofi_de84s4qcbsdrds.public.api_data_customplatformuniquefieldkey_1277 1 1 1,014,723 0 0 0 0 0 0 0 Total 4 4 4,121,210 625 0 3 56,624 0 0 0 Tuples removed per table
Key values
- public.api_data_am_keyword_stats (740964) Main table with removed tuples on database sanofi_de84s4qcbsdrds
- 865309 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain sanofi_de84s4qcbsdrds.public.api_data_am_keyword_stats 3 3 740,964 8,423,569 34,840 0 2,394,092 sanofi_de84s4qcbsdrds.public.api_data_customplatformuniquefieldkey_1277 1 1 124,345 8,172,242 0 1,112 494,378 Total 4 4 865,309 16,595,811 34,840 1,112 2,888,470 Pages removed per table
Key values
- public.api_data_customplatformuniquefieldkey_1277 (1112) Main table with removed pages on database sanofi_de84s4qcbsdrds
- 1112 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 30 00 0 0 01 0 0 02 0 0 03 0 0 04 0 3 05 3 5 06 0 0 07 0 0 08 1 3 09 0 2 10 0 3 11 0 1 12 0 1 13 0 0 14 0 0 15 0 0 16 0 0 17 0 1 18 0 0 - 21.39 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
- 0 Total write queries
Queries by database
Key values
- sanofi_de84s4qcbsdrds Main database
- 22 Requests
- 3h30m19s (sanofi_de84s4qcbsdrds)
- Main time consuming database
Queries by user
Key values
- u3m4c4715a71na Main user
- 22 Requests
User Request type Count Duration u3m4c4715a71na Total 22 3h30m19s others 22 3h30m19s Duration by user
Key values
- 3h30m19s (u3m4c4715a71na) Main time consuming user
User Request type Count Duration u3m4c4715a71na Total 22 3h30m19s others 22 3h30m19s Queries by host
Key values
- 10.24.60.132 Main host
- 4 Requests
- 41m50s (10.24.165.161)
- Main time consuming host
Host Request type Count Duration 10.24.117.110 Total 2 12m51s others 2 12m51s 10.24.165.161 Total 1 41m50s others 1 41m50s 10.24.167.176 Total 2 12m3s others 2 12m3s 10.24.170.26 Total 1 6m45s others 1 6m45s 10.24.175.103 Total 1 7m20s others 1 7m20s 10.24.175.77 Total 1 16m52s others 1 16m52s 10.24.183.185 Total 1 6m51s others 1 6m51s 10.24.184.13 Total 2 12m40s others 2 12m40s 10.24.188.78 Total 2 25m35s others 2 25m35s 10.24.189.222 Total 2 13m6s others 2 13m6s 10.24.40.159 Total 3 27m56s others 3 27m56s 10.24.60.132 Total 4 26m26s others 4 26m26s Queries by application
Key values
- unknown Main application
- 22 Requests
- 3h30m19s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-10-30 10:02:39 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 22 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 41m50s SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'metrics_impressions' AS "~SAR-3:metrics_impressions:custom_platform_stats:1", data ->> 'metrics_cost_micros' AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", data ->> 'metrics_clicks' AS "~SAR-3:metrics_clicks:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_11 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-30', 'YYYY-MM-DD');[ Date: 2024-10-30 14:21:26 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.165.161 ]
2 16m52s SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "~FE0:impressions:custom_platform_stats:1", data ->> 'spend' AS "~FE0:spend:custom_platform_stats:1", data ->> 'clicks' AS "~FE0:clicks:custom_platform_stats:1", data ->> 'video_views' AS "~FE0:video_views: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('2024-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-12-31', 'YYYY-MM-DD');[ Date: 2024-10-30 13:54:30 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.175.77 ]
3 14m37s 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_11 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-30 10:51:58 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.40.159 ]
4 13m41s 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-30 08:09:03 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.188.78 ]
5 11m53s 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-30 07:48:41 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.188.78 ]
6 8m5s 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_25 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-30', 'YYYY-MM-DD');[ Date: 2024-10-30 10:40:04 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.60.132 ]
7 7m31s SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", 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 ->> 'page_title' AS "~GA4-U15:page_title: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_11 scratch ON scratch.object_id = main.id;[ Date: 2024-10-30 10:17:24 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.189.222 ]
8 7m20s 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_11 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-30 18:05:52 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.175.103 ]
9 7m13s 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 ->> 'spend' AS "SA:spend:stats:1", data ->> 'impressions' AS "SA:impressions: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-30 12:45:58 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.117.110 ]
10 7m12s 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_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-30 10:07:47 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.40.159 ]
11 6m51s 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_28 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-30 16:29:36 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.183.185 ]
12 6m46s SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_sales_value_usd' AS "~PE0:total_sales_value_usd:custom_platform_stats:1", data ->> 'purchase_lead_value' AS "~PE0:purchase_lead_value:custom_platform_stats:1", data ->> 'total_leads' AS "~PE0:total_leads:custom_platform_stats:1", data ->> 'total_sales_count' AS "~PE0:total_sales_count:custom_platform_stats:1", data ->> 'sales_transactions' AS "~PE0:sales_transactions:custom_platform_stats:1", data ->> 'total_impressions' AS "~PE0:total_impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_18 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-30', 'YYYY-MM-DD');[ Date: 2024-10-30 10:20:13 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.60.132 ]
13 6m45s 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_11 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-30 15:03:11 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.170.26 ]
14 6m38s 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-30', 'YYYY-MM-DD');[ Date: 2024-10-30 10:41:32 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.167.176 ]
15 6m22s 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_1 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-30 14:27:53 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.184.13 ]
16 6m17s 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 ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_5 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-30 00:05:07 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.184.13 ]
17 6m9s SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_users' AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> 'screen_page_views' AS "~GA4-U7:screen_page_views:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> 'event_count' AS "~GA4-U7:event_count:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_25 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-30', 'YYYY-MM-DD');[ Date: 2024-10-30 10:46:21 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.60.132 ]
18 6m6s SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'seller_name' AS "~PS2:seller_name:custom_platform_info:1", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;[ Date: 2024-10-30 10:21:50 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.40.159 ]
19 5m38s 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_11 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-30 11:31:29 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.117.110 ]
20 5m35s 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_24 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-30', 'YYYY-MM-DD');[ Date: 2024-10-30 10:45:48 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.189.222 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 41m50s 1 41m50s 41m50s 41m50s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~SAR-3:metrics_impressions:custom_platform_stats:1", data ->> ? AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", data ->> ? AS "~SAR-3:metrics_clicks:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_11 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 30 14 1 41m50s 41m50s [ User: u3m4c4715a71na - Total duration: 41m50s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'metrics_impressions' AS "~SAR-3:metrics_impressions:custom_platform_stats:1", data ->> 'metrics_cost_micros' AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", data ->> 'metrics_clicks' AS "~SAR-3:metrics_clicks:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_11 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 14:21:26 Duration: 41m50s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.165.161
2 25m35s 2 11m53s 13m41s 12m47s 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 #2
Day Hour Count Duration Avg duration Oct 30 07 1 11m53s 11m53s 08 1 13m41s 13m41s [ User: u3m4c4715a71na - Total duration: 25m35s - 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-30 08:09:03 Duration: 13m41s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.78
-
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-30 07:48:41 Duration: 11m53s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.78
3 16m52s 1 16m52s 16m52s 16m52s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~FE0:impressions:custom_platform_stats:1", data ->> ? AS "~FE0:spend:custom_platform_stats:1", data ->> ? AS "~FE0:clicks:custom_platform_stats:1", data ->> ? AS "~FE0:video_views: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(?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 30 13 1 16m52s 16m52s [ User: u3m4c4715a71na - Total duration: 16m52s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "~FE0:impressions:custom_platform_stats:1", data ->> 'spend' AS "~FE0:spend:custom_platform_stats:1", data ->> 'clicks' AS "~FE0:clicks:custom_platform_stats:1", data ->> 'video_views' AS "~FE0:video_views: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('2024-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-12-31', 'YYYY-MM-DD');
Date: 2024-10-30 13:54:30 Duration: 16m52s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.175.77
4 14m37s 1 14m37s 14m37s 14m37s 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_11 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 30 10 1 14m37s 14m37s [ User: u3m4c4715a71na - Total duration: 14m37s - 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_11 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-30 10:51:58 Duration: 14m37s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
5 8m5s 1 8m5s 8m5s 8m5s 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_25 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 30 10 1 8m5s 8m5s [ User: u3m4c4715a71na - Total duration: 8m5s - 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_25 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:40:04 Duration: 8m5s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
6 7m31s 1 7m31s 7m31s 7m31s set local work_mem = ?; select id AS "level_1_id", 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:page_title: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_11 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 30 10 1 7m31s 7m31s [ User: u3m4c4715a71na - Total duration: 7m31s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", 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 ->> 'page_title' AS "~GA4-U15:page_title: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_11 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:17:24 Duration: 7m31s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.189.222
7 7m20s 1 7m20s 7m20s 7m20s 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_11 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 30 18 1 7m20s 7m20s [ User: u3m4c4715a71na - Total duration: 7m20s - 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_11 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-30 18:05:52 Duration: 7m20s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.175.103
8 7m13s 1 7m13s 7m13s 7m13s 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:spend:stats:1", data ->> ? AS "SA:impressions: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 #8
Day Hour Count Duration Avg duration Oct 30 12 1 7m13s 7m13s [ User: u3m4c4715a71na - Total duration: 7m13s - 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 ->> 'spend' AS "SA:spend:stats:1", data ->> 'impressions' AS "SA:impressions: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-30 12:45:58 Duration: 7m13s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.117.110
9 7m12s 1 7m12s 7m12s 7m12s 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_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 30 10 1 7m12s 7m12s [ User: u3m4c4715a71na - Total duration: 7m12s - 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_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-30 10:07:47 Duration: 7m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
10 6m51s 1 6m51s 6m51s 6m51s 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_28 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 30 16 1 6m51s 6m51s [ User: u3m4c4715a71na - Total duration: 6m51s - 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_28 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-30 16:29:36 Duration: 6m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.183.185
11 6m46s 1 6m46s 6m46s 6m46s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~PE0:total_sales_value_usd:custom_platform_stats:1", data ->> ? AS "~PE0:purchase_lead_value:custom_platform_stats:1", data ->> ? AS "~PE0:total_leads:custom_platform_stats:1", data ->> ? AS "~PE0:total_sales_count:custom_platform_stats:1", data ->> ? AS "~PE0:sales_transactions:custom_platform_stats:1", data ->> ? AS "~PE0:total_impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_18 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 30 10 1 6m46s 6m46s [ User: u3m4c4715a71na - Total duration: 6m46s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_sales_value_usd' AS "~PE0:total_sales_value_usd:custom_platform_stats:1", data ->> 'purchase_lead_value' AS "~PE0:purchase_lead_value:custom_platform_stats:1", data ->> 'total_leads' AS "~PE0:total_leads:custom_platform_stats:1", data ->> 'total_sales_count' AS "~PE0:total_sales_count:custom_platform_stats:1", data ->> 'sales_transactions' AS "~PE0:sales_transactions:custom_platform_stats:1", data ->> 'total_impressions' AS "~PE0:total_impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_18 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:20:13 Duration: 6m46s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
12 6m45s 1 6m45s 6m45s 6m45s 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_11 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 30 15 1 6m45s 6m45s [ User: u3m4c4715a71na - Total duration: 6m45s - 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_11 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-30 15:03:11 Duration: 6m45s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.26
13 6m38s 1 6m38s 6m38s 6m38s 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 #13
Day Hour Count Duration Avg duration Oct 30 10 1 6m38s 6m38s [ User: u3m4c4715a71na - Total duration: 6m38s - 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:41:32 Duration: 6m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.176
14 6m22s 1 6m22s 6m22s 6m22s 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_1 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 30 14 1 6m22s 6m22s [ User: u3m4c4715a71na - Total duration: 6m22s - 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_1 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-30 14:27:53 Duration: 6m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.184.13
15 6m17s 1 6m17s 6m17s 6m17s 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:spend:stats:1", data ->> ? AS "SA:clicks:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_5 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 30 00 1 6m17s 6m17s [ User: u3m4c4715a71na - Total duration: 6m17s - 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 ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_5 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-30 00:05:07 Duration: 6m17s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.184.13
16 6m9s 1 6m9s 6m9s 6m9s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:screen_page_views:custom_platform_stats:1", data ->> ? AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:event_count:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_25 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 30 10 1 6m9s 6m9s [ User: u3m4c4715a71na - Total duration: 6m9s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_users' AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> 'screen_page_views' AS "~GA4-U7:screen_page_views:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> 'event_count' AS "~GA4-U7:event_count:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_25 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:46:21 Duration: 6m9s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
17 6m6s 1 6m6s 6m6s 6m6s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:seller_name:custom_platform_info:1", data ->> ? AS "~PS2:redirect_id: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 #17
Day Hour Count Duration Avg duration Oct 30 10 1 6m6s 6m6s [ User: u3m4c4715a71na - Total duration: 6m6s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'seller_name' AS "~PS2:seller_name:custom_platform_info:1", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:21:50 Duration: 6m6s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
18 5m38s 1 5m38s 5m38s 5m38s 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_11 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 30 11 1 5m38s 5m38s [ User: u3m4c4715a71na - Total duration: 5m38s - 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_11 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-30 11:31:29 Duration: 5m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.117.110
19 5m35s 1 5m35s 5m35s 5m35s 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_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 30 10 1 5m35s 5m35s [ User: u3m4c4715a71na - Total duration: 5m35s - 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_24 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:45:48 Duration: 5m35s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.189.222
20 5m24s 1 5m24s 5m24s 5m24s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title: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 #20
Day Hour Count Duration Avg duration Oct 30 10 1 5m24s 5m24s [ User: u3m4c4715a71na - Total duration: 5m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", 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" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:24:12 Duration: 5m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.176
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 25m35s 11m53s 13m41s 12m47s 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 30 07 1 11m53s 11m53s 08 1 13m41s 13m41s [ User: u3m4c4715a71na - Total duration: 25m35s - 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-30 08:09:03 Duration: 13m41s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.78
-
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-30 07:48:41 Duration: 11m53s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.78
2 1 41m50s 41m50s 41m50s 41m50s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~SAR-3:metrics_impressions:custom_platform_stats:1", data ->> ? AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", data ->> ? AS "~SAR-3:metrics_clicks:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_11 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 30 14 1 41m50s 41m50s [ User: u3m4c4715a71na - Total duration: 41m50s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'metrics_impressions' AS "~SAR-3:metrics_impressions:custom_platform_stats:1", data ->> 'metrics_cost_micros' AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", data ->> 'metrics_clicks' AS "~SAR-3:metrics_clicks:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_11 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 14:21:26 Duration: 41m50s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.165.161
3 1 16m52s 16m52s 16m52s 16m52s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~FE0:impressions:custom_platform_stats:1", data ->> ? AS "~FE0:spend:custom_platform_stats:1", data ->> ? AS "~FE0:clicks:custom_platform_stats:1", data ->> ? AS "~FE0:video_views: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(?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 30 13 1 16m52s 16m52s [ User: u3m4c4715a71na - Total duration: 16m52s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "~FE0:impressions:custom_platform_stats:1", data ->> 'spend' AS "~FE0:spend:custom_platform_stats:1", data ->> 'clicks' AS "~FE0:clicks:custom_platform_stats:1", data ->> 'video_views' AS "~FE0:video_views: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('2024-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-12-31', 'YYYY-MM-DD');
Date: 2024-10-30 13:54:30 Duration: 16m52s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.175.77
4 1 14m37s 14m37s 14m37s 14m37s 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_11 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 30 10 1 14m37s 14m37s [ User: u3m4c4715a71na - Total duration: 14m37s - 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_11 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-30 10:51:58 Duration: 14m37s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
5 1 8m5s 8m5s 8m5s 8m5s 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_25 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 30 10 1 8m5s 8m5s [ User: u3m4c4715a71na - Total duration: 8m5s - 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_25 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:40:04 Duration: 8m5s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
6 1 7m31s 7m31s 7m31s 7m31s set local work_mem = ?; select id AS "level_1_id", 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:page_title: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_11 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 30 10 1 7m31s 7m31s [ User: u3m4c4715a71na - Total duration: 7m31s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", 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 ->> 'page_title' AS "~GA4-U15:page_title: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_11 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:17:24 Duration: 7m31s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.189.222
7 1 7m20s 7m20s 7m20s 7m20s 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_11 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 30 18 1 7m20s 7m20s [ User: u3m4c4715a71na - Total duration: 7m20s - 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_11 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-30 18:05:52 Duration: 7m20s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.175.103
8 1 7m13s 7m13s 7m13s 7m13s 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:spend:stats:1", data ->> ? AS "SA:impressions: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 #8
Day Hour Count Duration Avg duration Oct 30 12 1 7m13s 7m13s [ User: u3m4c4715a71na - Total duration: 7m13s - 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 ->> 'spend' AS "SA:spend:stats:1", data ->> 'impressions' AS "SA:impressions: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-30 12:45:58 Duration: 7m13s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.117.110
9 1 7m12s 7m12s 7m12s 7m12s 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_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 30 10 1 7m12s 7m12s [ User: u3m4c4715a71na - Total duration: 7m12s - 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_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-30 10:07:47 Duration: 7m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
10 1 6m51s 6m51s 6m51s 6m51s 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_28 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 30 16 1 6m51s 6m51s [ User: u3m4c4715a71na - Total duration: 6m51s - 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_28 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-30 16:29:36 Duration: 6m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.183.185
11 1 6m46s 6m46s 6m46s 6m46s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~PE0:total_sales_value_usd:custom_platform_stats:1", data ->> ? AS "~PE0:purchase_lead_value:custom_platform_stats:1", data ->> ? AS "~PE0:total_leads:custom_platform_stats:1", data ->> ? AS "~PE0:total_sales_count:custom_platform_stats:1", data ->> ? AS "~PE0:sales_transactions:custom_platform_stats:1", data ->> ? AS "~PE0:total_impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_18 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 30 10 1 6m46s 6m46s [ User: u3m4c4715a71na - Total duration: 6m46s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_sales_value_usd' AS "~PE0:total_sales_value_usd:custom_platform_stats:1", data ->> 'purchase_lead_value' AS "~PE0:purchase_lead_value:custom_platform_stats:1", data ->> 'total_leads' AS "~PE0:total_leads:custom_platform_stats:1", data ->> 'total_sales_count' AS "~PE0:total_sales_count:custom_platform_stats:1", data ->> 'sales_transactions' AS "~PE0:sales_transactions:custom_platform_stats:1", data ->> 'total_impressions' AS "~PE0:total_impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_18 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:20:13 Duration: 6m46s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
12 1 6m45s 6m45s 6m45s 6m45s 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_11 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 30 15 1 6m45s 6m45s [ User: u3m4c4715a71na - Total duration: 6m45s - 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_11 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-30 15:03:11 Duration: 6m45s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.26
13 1 6m38s 6m38s 6m38s 6m38s 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 #13
Day Hour Count Duration Avg duration Oct 30 10 1 6m38s 6m38s [ User: u3m4c4715a71na - Total duration: 6m38s - 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:41:32 Duration: 6m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.176
14 1 6m22s 6m22s 6m22s 6m22s 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_1 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 30 14 1 6m22s 6m22s [ User: u3m4c4715a71na - Total duration: 6m22s - 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_1 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-30 14:27:53 Duration: 6m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.184.13
15 1 6m17s 6m17s 6m17s 6m17s 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:spend:stats:1", data ->> ? AS "SA:clicks:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_5 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 30 00 1 6m17s 6m17s [ User: u3m4c4715a71na - Total duration: 6m17s - 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 ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_5 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-30 00:05:07 Duration: 6m17s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.184.13
16 1 6m9s 6m9s 6m9s 6m9s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:screen_page_views:custom_platform_stats:1", data ->> ? AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:event_count:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_25 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 30 10 1 6m9s 6m9s [ User: u3m4c4715a71na - Total duration: 6m9s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_users' AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> 'screen_page_views' AS "~GA4-U7:screen_page_views:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> 'event_count' AS "~GA4-U7:event_count:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_25 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:46:21 Duration: 6m9s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
17 1 6m6s 6m6s 6m6s 6m6s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:seller_name:custom_platform_info:1", data ->> ? AS "~PS2:redirect_id: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 #17
Day Hour Count Duration Avg duration Oct 30 10 1 6m6s 6m6s [ User: u3m4c4715a71na - Total duration: 6m6s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'seller_name' AS "~PS2:seller_name:custom_platform_info:1", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:21:50 Duration: 6m6s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
18 1 5m38s 5m38s 5m38s 5m38s 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_11 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 30 11 1 5m38s 5m38s [ User: u3m4c4715a71na - Total duration: 5m38s - 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_11 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-30 11:31:29 Duration: 5m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.117.110
19 1 5m35s 5m35s 5m35s 5m35s 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_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 30 10 1 5m35s 5m35s [ User: u3m4c4715a71na - Total duration: 5m35s - 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_24 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:45:48 Duration: 5m35s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.189.222
20 1 5m24s 5m24s 5m24s 5m24s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title: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 #20
Day Hour Count Duration Avg duration Oct 30 10 1 5m24s 5m24s [ User: u3m4c4715a71na - Total duration: 5m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", 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" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:24:12 Duration: 5m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.176
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 41m50s 41m50s 41m50s 1 41m50s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~SAR-3:metrics_impressions:custom_platform_stats:1", data ->> ? AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", data ->> ? AS "~SAR-3:metrics_clicks:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_11 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 30 14 1 41m50s 41m50s [ User: u3m4c4715a71na - Total duration: 41m50s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'metrics_impressions' AS "~SAR-3:metrics_impressions:custom_platform_stats:1", data ->> 'metrics_cost_micros' AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", data ->> 'metrics_clicks' AS "~SAR-3:metrics_clicks:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_11 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 14:21:26 Duration: 41m50s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.165.161
2 16m52s 16m52s 16m52s 1 16m52s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~FE0:impressions:custom_platform_stats:1", data ->> ? AS "~FE0:spend:custom_platform_stats:1", data ->> ? AS "~FE0:clicks:custom_platform_stats:1", data ->> ? AS "~FE0:video_views: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(?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 30 13 1 16m52s 16m52s [ User: u3m4c4715a71na - Total duration: 16m52s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'impressions' AS "~FE0:impressions:custom_platform_stats:1", data ->> 'spend' AS "~FE0:spend:custom_platform_stats:1", data ->> 'clicks' AS "~FE0:clicks:custom_platform_stats:1", data ->> 'video_views' AS "~FE0:video_views: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('2024-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-12-31', 'YYYY-MM-DD');
Date: 2024-10-30 13:54:30 Duration: 16m52s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.175.77
3 14m37s 14m37s 14m37s 1 14m37s 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_11 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 30 10 1 14m37s 14m37s [ User: u3m4c4715a71na - Total duration: 14m37s - 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_11 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-30 10:51:58 Duration: 14m37s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
4 11m53s 13m41s 12m47s 2 25m35s 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 30 07 1 11m53s 11m53s 08 1 13m41s 13m41s [ User: u3m4c4715a71na - Total duration: 25m35s - 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-30 08:09:03 Duration: 13m41s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.78
-
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-30 07:48:41 Duration: 11m53s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.188.78
5 8m5s 8m5s 8m5s 1 8m5s 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_25 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 30 10 1 8m5s 8m5s [ User: u3m4c4715a71na - Total duration: 8m5s - 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_25 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:40:04 Duration: 8m5s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
6 7m31s 7m31s 7m31s 1 7m31s set local work_mem = ?; select id AS "level_1_id", 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:page_title: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_11 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 30 10 1 7m31s 7m31s [ User: u3m4c4715a71na - Total duration: 7m31s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", 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 ->> 'page_title' AS "~GA4-U15:page_title: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_11 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:17:24 Duration: 7m31s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.189.222
7 7m20s 7m20s 7m20s 1 7m20s 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_11 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 30 18 1 7m20s 7m20s [ User: u3m4c4715a71na - Total duration: 7m20s - 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_11 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-30 18:05:52 Duration: 7m20s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.175.103
8 7m13s 7m13s 7m13s 1 7m13s 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:spend:stats:1", data ->> ? AS "SA:impressions: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 #8
Day Hour Count Duration Avg duration Oct 30 12 1 7m13s 7m13s [ User: u3m4c4715a71na - Total duration: 7m13s - 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 ->> 'spend' AS "SA:spend:stats:1", data ->> 'impressions' AS "SA:impressions: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-30 12:45:58 Duration: 7m13s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.117.110
9 7m12s 7m12s 7m12s 1 7m12s 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_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 30 10 1 7m12s 7m12s [ User: u3m4c4715a71na - Total duration: 7m12s - 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_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-30 10:07:47 Duration: 7m12s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
10 6m51s 6m51s 6m51s 1 6m51s 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_28 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 30 16 1 6m51s 6m51s [ User: u3m4c4715a71na - Total duration: 6m51s - 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_28 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-30 16:29:36 Duration: 6m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.183.185
11 6m46s 6m46s 6m46s 1 6m46s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~PE0:total_sales_value_usd:custom_platform_stats:1", data ->> ? AS "~PE0:purchase_lead_value:custom_platform_stats:1", data ->> ? AS "~PE0:total_leads:custom_platform_stats:1", data ->> ? AS "~PE0:total_sales_count:custom_platform_stats:1", data ->> ? AS "~PE0:sales_transactions:custom_platform_stats:1", data ->> ? AS "~PE0:total_impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_18 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 30 10 1 6m46s 6m46s [ User: u3m4c4715a71na - Total duration: 6m46s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_sales_value_usd' AS "~PE0:total_sales_value_usd:custom_platform_stats:1", data ->> 'purchase_lead_value' AS "~PE0:purchase_lead_value:custom_platform_stats:1", data ->> 'total_leads' AS "~PE0:total_leads:custom_platform_stats:1", data ->> 'total_sales_count' AS "~PE0:total_sales_count:custom_platform_stats:1", data ->> 'sales_transactions' AS "~PE0:sales_transactions:custom_platform_stats:1", data ->> 'total_impressions' AS "~PE0:total_impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_18 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:20:13 Duration: 6m46s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
12 6m45s 6m45s 6m45s 1 6m45s 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_11 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 30 15 1 6m45s 6m45s [ User: u3m4c4715a71na - Total duration: 6m45s - 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_11 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-30 15:03:11 Duration: 6m45s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.26
13 6m38s 6m38s 6m38s 1 6m38s 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 #13
Day Hour Count Duration Avg duration Oct 30 10 1 6m38s 6m38s [ User: u3m4c4715a71na - Total duration: 6m38s - 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:41:32 Duration: 6m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.176
14 6m22s 6m22s 6m22s 1 6m22s 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_1 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 30 14 1 6m22s 6m22s [ User: u3m4c4715a71na - Total duration: 6m22s - 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_1 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-30 14:27:53 Duration: 6m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.184.13
15 6m17s 6m17s 6m17s 1 6m17s 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:spend:stats:1", data ->> ? AS "SA:clicks:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_5 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 30 00 1 6m17s 6m17s [ User: u3m4c4715a71na - Total duration: 6m17s - 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 ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_5 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-30 00:05:07 Duration: 6m17s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.184.13
16 6m9s 6m9s 6m9s 1 6m9s set local work_mem = ?; select custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> ? AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:screen_page_views:custom_platform_stats:1", data ->> ? AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> ? AS "~GA4-U7:event_count:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_25 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 30 10 1 6m9s 6m9s [ User: u3m4c4715a71na - Total duration: 6m9s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal", data ->> 'total_users' AS "~GA4-U7:total_users:custom_platform_stats:1", data ->> 'screen_page_views' AS "~GA4-U7:screen_page_views:custom_platform_stats:1", data ->> 'new_users' AS "~GA4-U7:new_users:custom_platform_stats:1", data ->> 'event_count' AS "~GA4-U7:event_count:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_25 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:46:21 Duration: 6m9s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.60.132
17 6m6s 6m6s 6m6s 1 6m6s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:seller_name:custom_platform_info:1", data ->> ? AS "~PS2:redirect_id: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 #17
Day Hour Count Duration Avg duration Oct 30 10 1 6m6s 6m6s [ User: u3m4c4715a71na - Total duration: 6m6s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'seller_name' AS "~PS2:seller_name:custom_platform_info:1", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_24 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:21:50 Duration: 6m6s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.159
18 5m38s 5m38s 5m38s 1 5m38s 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_11 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 30 11 1 5m38s 5m38s [ User: u3m4c4715a71na - Total duration: 5m38s - 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_11 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-30 11:31:29 Duration: 5m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.117.110
19 5m35s 5m35s 5m35s 1 5m35s 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_24 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 30 10 1 5m35s 5m35s [ User: u3m4c4715a71na - Total duration: 5m35s - 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_24 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-30', 'YYYY-MM-DD');
Date: 2024-10-30 10:45:48 Duration: 5m35s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.189.222
20 5m24s 5m24s 5m24s 1 5m24s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title: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 #20
Day Hour Count Duration Avg duration Oct 30 10 1 5m24s 5m24s [ User: u3m4c4715a71na - Total duration: 5m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '300.00MB'; SELECT id AS "level_1_id", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", 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" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_21 scratch ON scratch.object_id = main.id;
Date: 2024-10-30 10:24:12 Duration: 5m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.176
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,675 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
- 5 ERROR entries
- 0 WARNING entries
- 6391 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 6,388 Max number of times the same event was reported
- 6,396 Total events found
Rank Times reported Error 1 6,388 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 30 00 145 01 6 02 6 03 1,579 04 655 05 39 06 24 07 197 08 595 09 2,091 10 154 11 153 12 135 13 153 14 142 15 18 16 212 17 57 18 27 2 4 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 30 08 2 09 1 18 1 - ERROR: duplicate key value violates unique constraint "api_data_worker_scheduler_date_name_request_id_df285f03_uniq"
- ERROR: duplicate key value violates unique constraint "api_data_job_worker_id_job_name_f8c82ace_uniq"
- ERROR: duplicate key value violates unique constraint "api_data_job_worker_id_job_name_f8c82ace_uniq"
Detail: Key (scheduler, date, name, request_id)=(4, 2024-10-30, 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-30T08:17:36.801599+00:00'::timestamptz, '2024-10-30T08:17:36.801613+00:00'::timestamptz, 4, '2024-10-30'::date, '552893', NULL, NULL, NULL, NULL, false, 'CUSTOM_PLATFORM_UPLOAD_APPLY_RULES', 0, 0, NULL, NULL, 'UserTaskScheduler:2024-10-30', NULL) RETURNING "api_data_worker"."id"Date: 2024-10-30 08:17:36 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.34.70
Detail: Key (worker_id, job_name)=(1982844, CUSTOM_PLATFORM_UPLOAD_APPLY_RULES_552860_LAST_JOB) already exists.
Statement: INSERT INTO "api_data_job" ("created", "updated", "worker_id", "job_name", "status", "queue", "queued_at", "work_start_at", "work_stop_at", "job_args", "job_kwargs", "rq_id", "failure_data", "sentry_id", "tracer_link", "job_run_time") VALUES ('2024-10-30T08:49:01.464784+00:00'::timestamptz, '2024-10-30T08:49:01.464796+00:00'::timestamptz, 1982844, 'CUSTOM_PLATFORM_UPLOAD_APPLY_RULES_552860_LAST_JOB', 0, 5, '2024-10-30T04:49:01.458568-04:00'::timestamptz, NULL, NULL, '[]', '{"is_finishing_job": true, "request_id": "552860"}', NULL, NULL, NULL, NULL, NULL) RETURNING "api_data_job"."id"Date: 2024-10-30 08:49:01 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.96.120
Detail: Key (worker_id, job_name)=(1982872, CUSTOM_PLATFORM_UPLOAD_APPLY_RULES_506069_LAST_JOB) already exists.
Statement: INSERT INTO "api_data_job" ("created", "updated", "worker_id", "job_name", "status", "queue", "queued_at", "work_start_at", "work_stop_at", "job_args", "job_kwargs", "rq_id", "failure_data", "sentry_id", "tracer_link", "job_run_time") VALUES ('2024-10-30T09:08:35.818172+00:00'::timestamptz, '2024-10-30T09:08:35.818186+00:00'::timestamptz, 1982872, 'CUSTOM_PLATFORM_UPLOAD_APPLY_RULES_506069_LAST_JOB', 0, 5, '2024-10-30T05:08:35.813759-04:00'::timestamptz, NULL, NULL, '[]', '{"is_finishing_job": true, "request_id": "506069"}', NULL, NULL, NULL, NULL, NULL) RETURNING "api_data_job"."id"Date: 2024-10-30 09:08:35 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.165.161
3 3 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 30 10 3 4 1 ERROR: insert or update on table "..." violates foreign key constraint "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 30 07 1 - ERROR: insert or update on table "api_data_custom_platform_info_to_custom_platform_info" violates foreign key constraint "api_data_custom_plat_main_platform_info_i_67858482_fk_api_data_"
Detail: Key (main_platform_info_id)=(1910307652) is not present in table "api_data_customplatforminfo".
Statement: INSERT INTO api_data_custom_platform_info_to_custom_platform_info AS orig ("main_platform_info_id","associated_platform_info_id","main_platform_id","associated_platform_id","is_active","created","updated") VALUES (1910307652,1726671455,1066,1243,true,'NOW()','NOW()'), (1910307652,1726671469,1066,1243,true,'NOW()','NOW()'), (1910307652,1726671454,1066,1243,true,'NOW()','NOW()'), (1910307652,1726671470,1066,1243,true,'NOW()','NOW()'), (1910307652,1726671471,1066,1243,true,'NOW()','NOW()'), (1910307652,1726671456,1066,1243,true,'NOW()','NOW()'), (1910307652,1726679582,1066,1243,true,'NOW()','NOW()') ON CONFLICT ("main_platform_info_id","associated_platform_info_id") DO UPDATE SET "is_active"=EXCLUDED."is_active","main_platform_id"=EXCLUDED."main_platform_id","associated_platform_id"=EXCLUDED."associated_platform_id","updated"=EXCLUDED."updated" RETURNING (xmax = 0) AS util_was_inserted, main_platform_info_id,associated_platform_info_id,idDate: 2024-10-30 07:19:26 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.168.240