pgBadger-
Global information
- Generated on Wed Oct 23 16:06:46 2024
- Log file: out/error/postgresql.log.2024-10-23-0000, ..., out/error/postgresql.log.2024-10-23-2000
- Parsed 28,393 log entries in 42s
- Log start from 2024-10-23 00:00:26 to 2024-10-23 20:01:21
-
Overview
Global Stats
- 68 Number of unique normalized queries
- 48 Number of queries
- 7h13m58s Total query duration
- 2024-10-23 00:06:06 First query
- 2024-10-23 18:05:34 Last query
- 1 queries/s at 2024-10-23 11:28:42 Query peak
- 7h13m58s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h13m58s Execute total duration
- 8,154 Number of events
- 7 Number of unique normalized events
- 8,127 Max number of times the same event was reported
- 0 Number of cancellation
- 4 Total number of automatic vacuums
- 17 Total number of automatic analyzes
- 162 Number temporary file
- 1.00 GiB Max size of temporary file
- 201.42 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
- 48 Average queries per session
- 7h13m58s 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-23 11:28:42 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2024-10-23 09:34:24 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2024-10-23 11:19:39 Date
Queries duration
Key values
- 7h13m58s 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 23 00 1 0ms 7m22s 7m22s 0ms 7m22s 7m22s 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 13m47s 13m47s 0ms 0ms 13m47s 08 1 0ms 17m26s 17m26s 0ms 0ms 17m26s 09 1 0ms 6m23s 6m23s 0ms 0ms 6m23s 10 10 0ms 16m30s 7m57s 9m24s 14m44s 16m30s 11 23 0ms 39m40s 10m 12m 18m39s 39m40s 12 2 0ms 7m11s 7m9s 0ms 7m7s 7m11s 13 3 0ms 12m46s 8m44s 0ms 7m 12m46s 14 3 0ms 6m51s 6m17s 0ms 6m9s 6m51s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 1 0ms 7m15s 7m15s 0ms 0ms 7m15s 17 1 0ms 5m11s 5m11s 0ms 0ms 5m11s 18 1 0ms 7m16s 7m16s 0ms 7m16s 7m16s 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 23 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 1 0 6m23s 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 19 0 0 0ms 0ms 0ms 0ms 20 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 23 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 1 0 0 0 5m45s 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 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 23 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% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% Day Hour Count Average / Second Oct 23 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 19 0 0.00/s 20 0 0.00/s Day Hour Count Average Duration Average idle time Oct 23 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 19 0 0ms 0ms 20 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 23 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 19 0 0s 0s 0s 20 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 23 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 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Oct 23 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 19 0 0s 20 0 0s Day Hour Mean distance Mean estimate Oct 23 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 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 1.51 GiB Temp Files size Peak
- 2024-10-23 13:06:43 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2024-10-23 09:39:58 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 23 00 0 0 0 01 0 0 0 02 3 396.95 MiB 132.32 MiB 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 36 3.92 GiB 111.58 MiB 08 37 4.35 GiB 120.47 MiB 09 29 4.88 GiB 172.27 MiB 10 13 4.58 GiB 360.93 MiB 11 0 0 0 12 12 3.93 GiB 335.43 MiB 13 14 4.45 GiB 325.57 MiB 14 2 532.81 MiB 266.41 MiB 15 0 0 0 16 0 0 0 17 13 4.45 GiB 350.61 MiB 18 0 0 0 19 3 396.95 MiB 132.32 MiB 20 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 42 4.57 GiB 111.27 MiB 112.12 MiB 111.54 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-23 08:19:53 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.179.40
2 31 3.70 GiB 120.68 MiB 123.59 MiB 122.24 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-16', '2024-10-17', '2024-10-18', '2024-10-19', '2024-10-20', '2024-10-21', '2024-10-22') 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-23 08:01:39 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.179.40
3 10 1.84 GiB 188.14 MiB 188.14 MiB 188.14 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-22'::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-23 09:40:20 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.226
4 10 1.84 GiB 188.14 MiB 188.14 MiB 188.14 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-22'::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-23 09:39:58 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.226
5 9 1.37 GiB 150.42 MiB 166.62 MiB 156.37 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~FE0:spend:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'spend')::numeric) AS "~FE0:spend:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 17:47:41 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.45.126
6 9 1.16 GiB 127.49 MiB 136.61 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-23 19:23:01 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.124.113
7 8 4.52 GiB 464.53 MiB 1.00 GiB 578.81 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 17:46:00 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.45.126
8 3 417.98 MiB 136.27 MiB 145.03 MiB 139.33 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") inner join "data_sets_datasetsourcetoportfolio" on ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") inner join "vayner_portfolio" on ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") inner join "clients_account" on ("vayner_portfolio"."id" = "clients_account"."portfolio_id") inner join "clients_campaign" on ("clients_account"."id" = "clients_campaign"."account_id") inner join "campaign_daily_breakdown_spend" on ("clients_campaign"."id" = "campaign_daily_breakdown_spend"."campaign_id") inner join "data_sets_datasettocolumn" t12 on ("data_sets_dataset"."id" = t12."data_set_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 case when ("data_sets_datasettocolumn"."platform_breakdown_id" is not null) then true else false end and t12."platform_breakdown_id" = ("campaign_daily_breakdown_spend"."breakdown_id")) group by "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" having "data_sets_dataset"."last_refreshed" < (max("campaign_daily_breakdown_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") INNER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") INNER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") INNER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") INNER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") INNER JOIN "campaign_daily_breakdown_spend" ON ("clients_campaign"."id" = "campaign_daily_breakdown_spend"."campaign_id") INNER JOIN "data_sets_datasettocolumn" T12 ON ("data_sets_dataset"."id" = T12."data_set_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-22'::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 CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END AND T12."platform_breakdown_id" = ("campaign_daily_breakdown_spend"."breakdown_id")) GROUP BY "data_sets_dataset"."id", "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_breakdown_spend"."db_spend_last_updated"));
Date: 2024-10-23 09:39:55 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
9 3 1.51 GiB 476.58 MiB 555.76 MiB 514.49 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_0 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_0 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 12:54:34 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.61.203
10 3 1.51 GiB 488.80 MiB 539.99 MiB 514.49 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_30 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_30 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 10:27:09 Duration: 5m6s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_30 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 10:27:09 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
11 3 469.09 MiB 152.26 MiB 160.14 MiB 156.36 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~FE0:spend:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_0 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'spend')::numeric) AS "~FE0:spend:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_0 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 12:56:09 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.61.203
12 3 1.51 GiB 477.37 MiB 557.41 MiB 514.49 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_14 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_14 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 13:04:09 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.53.154
13 3 1.51 GiB 471.00 MiB 550.14 MiB 514.50 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_28 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_28 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 10:31:45 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
14 3 469.09 MiB 152.95 MiB 158.72 MiB 156.36 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~FE0:spend:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_14 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'spend')::numeric) AS "~FE0:spend:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_14 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 13:05:20 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.53.154
15 3 1.51 GiB 488.61 MiB 545.83 MiB 514.49 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_7 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_7 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 17:44:27 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.38.32
16 3 417.98 MiB 136.72 MiB 141.27 MiB 139.33 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") inner join "data_sets_datasetsourcetoportfolio" on ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") inner join "vayner_portfolio" on ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") inner join "clients_account" on ("vayner_portfolio"."id" = "clients_account"."portfolio_id") inner join "clients_campaign" on ("clients_account"."id" = "clients_campaign"."account_id") inner join "campaign_daily_breakdown_spend" on ("clients_campaign"."id" = "campaign_daily_breakdown_spend"."campaign_id") inner join "data_sets_datasettocolumn" t12 on ("data_sets_dataset"."id" = t12."data_set_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 case when ("data_sets_datasettocolumn"."platform_breakdown_id" is not null) then true else false end and t12."platform_breakdown_id" = ("campaign_daily_breakdown_spend"."breakdown_id")) group by "data_sets_dataset"."id", ?, "data_sets_dataset"."last_refreshed" having "data_sets_dataset"."last_refreshed" < (max("campaign_daily_breakdown_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") INNER JOIN "data_sets_datasetsourcetoportfolio" ON ("data_sets_dataset"."id" = "data_sets_datasetsourcetoportfolio"."data_set_id") INNER JOIN "vayner_portfolio" ON ("data_sets_datasetsourcetoportfolio"."portfolio_id" = "vayner_portfolio"."id") INNER JOIN "clients_account" ON ("vayner_portfolio"."id" = "clients_account"."portfolio_id") INNER JOIN "clients_campaign" ON ("clients_account"."id" = "clients_campaign"."account_id") INNER JOIN "campaign_daily_breakdown_spend" ON ("clients_campaign"."id" = "campaign_daily_breakdown_spend"."campaign_id") INNER JOIN "data_sets_datasettocolumn" T12 ON ("data_sets_dataset"."id" = T12."data_set_id") WHERE (NOT ("data_sets_dataset"."data_status" = 5) AND NOT ("data_sets_dataset"."_cached_lifetime_end_date" <= '2024-09-22'::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 CASE WHEN ("data_sets_datasettocolumn"."platform_breakdown_id" IS NOT NULL) THEN true ELSE false END AND T12."platform_breakdown_id" = ("campaign_daily_breakdown_spend"."breakdown_id")) GROUP BY "data_sets_dataset"."id", 1, "data_sets_dataset"."last_refreshed" HAVING "data_sets_dataset"."last_refreshed" < (MAX("campaign_daily_breakdown_spend"."db_spend_last_updated"))) subquery;
Date: 2024-10-23 09:39:51 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
17 3 468.69 MiB 152.54 MiB 158.18 MiB 156.23 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~FE0:spend:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_28 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'spend')::numeric) AS "~FE0:spend:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_28 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 10:33:51 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
18 3 469.09 MiB 153.82 MiB 158.00 MiB 156.36 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~FE0:spend:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_7 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'spend')::numeric) AS "~FE0:spend:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_7 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 17:45:39 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.38.32
19 2 757.62 MiB 378.81 MiB 378.81 MiB 378.81 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", sum((data ->> ?)::numeric) AS "~SAR-3:metrics_impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_7 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'metrics_cost_micros')::numeric) AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", SUM((data ->> 'metrics_impressions')::numeric) AS "~SAR-3:metrics_impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_7 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') GROUP BY "level_1_id";
Date: 2024-10-23 17:51:44 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
20 1 154.00 MiB 154.00 MiB 154.00 MiB 154.00 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~YO0:advertiser_spending:custom_platform_stats:1", sum((data ->> ?)::numeric) AS "~YO0:impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_0 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'advertiser_spending')::numeric) AS "~YO0:advertiser_spending:custom_platform_stats:1", SUM((data ->> 'impressions')::numeric) AS "~YO0:impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_0 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') GROUP BY "level_1_id";
Date: 2024-10-23 14:04:53 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.39.78
21 1 154.00 MiB 154.00 MiB 154.00 MiB 154.00 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~YO0:advertiser_spending:custom_platform_stats:1", sum((data ->> ?)::numeric) AS "~YO0:impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_14 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'advertiser_spending')::numeric) AS "~YO0:advertiser_spending:custom_platform_stats:1", SUM((data ->> 'impressions')::numeric) AS "~YO0:impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_14 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') GROUP BY "level_1_id";
Date: 2024-10-23 13:12:11 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.59.250
22 1 134.91 MiB 134.91 MiB 134.91 MiB 134.91 MiB with custom_platform_info as ( select id from "api_data_customplatforminfo" where "portfolio_id" = ? and "platform_id" = ? ) select distinct "api_data_customplatformstats"."custom_platform_info_id" from "api_data_customplatformstats" where ("api_data_customplatformstats"."platform_id" = ? and "api_data_customplatformstats"."date" >= ? and "api_data_customplatformstats"."date" <= ? and "api_data_customplatformstats"."custom_platform_info_id" in ( select id from custom_platform_info));-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 10:02:47 Duration: 16m30s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1243 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1243 AND "api_data_customplatformstats"."date" >= '2023-01-01' AND "api_data_customplatformstats"."date" <= '2025-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 11:26:18 Duration: 11m57s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1065 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1065 AND "api_data_customplatformstats"."date" >= '2019-01-01' AND "api_data_customplatformstats"."date" <= '2024-10-23' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 11:19:39 Duration: 7m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
23 1 154.00 MiB 154.00 MiB 154.00 MiB 154.00 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~YO0:impressions:custom_platform_stats:1", sum((data ->> ?)::numeric) AS "~YO0:advertiser_spending:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_7 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'impressions')::numeric) AS "~YO0:impressions:custom_platform_stats:1", SUM((data ->> 'advertiser_spending')::numeric) AS "~YO0:advertiser_spending:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_7 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') GROUP BY "level_1_id";
Date: 2024-10-23 17:51:45 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
24 1 378.81 MiB 378.81 MiB 378.81 MiB 378.81 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", sum((data ->> ?)::numeric) AS "~SAR-3:metrics_impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_0 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'metrics_cost_micros')::numeric) AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", SUM((data ->> 'metrics_impressions')::numeric) AS "~SAR-3:metrics_impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_0 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') GROUP BY "level_1_id";
Date: 2024-10-23 14:04:52 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.39.78
25 1 378.81 MiB 378.81 MiB 378.81 MiB 378.81 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", sum((data ->> ?)::numeric) AS "~SAR-3:metrics_impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_14 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'metrics_cost_micros')::numeric) AS "~SAR-3:metrics_cost_micros:custom_platform_stats:1", SUM((data ->> 'metrics_impressions')::numeric) AS "~SAR-3:metrics_impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_14 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') GROUP BY "level_1_id";
Date: 2024-10-23 13:12:10 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.59.250
26 1 468.70 MiB 468.70 MiB 468.70 MiB 468.70 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~FE0:spend:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_30 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'spend')::numeric) AS "~FE0:spend:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_30 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";
Date: 2024-10-23 10:29:18 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
27 1 154.00 MiB 154.00 MiB 154.00 MiB 154.00 MiB set local work_mem = ?; select custom_platform_info_id AS "level_1_id", sum((data ->> ?)::numeric) AS "~YO0:advertiser_spending:custom_platform_stats:1", sum((data ->> ?)::numeric) AS "~YO0:impressions:custom_platform_stats:1" from api_data_customplatformstats stats join api_data_datasetfetchscratch_7 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?) group by "level_1_id";-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'advertiser_spending')::numeric) AS "~YO0:advertiser_spending:custom_platform_stats:1", SUM((data ->> 'impressions')::numeric) AS "~YO0:impressions:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_7 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') GROUP BY "level_1_id";
Date: 2024-10-23 10:44:29 Duration: 0ms Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
Queries generating the largest temporary files
Rank Size Query 1 1.00 GiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 17:46:00 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.45.126 ]
2 557.41 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_14 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 13:04:09 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.53.154 ]
3 556.86 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 12:53:33 ]
4 555.76 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_0 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 12:54:34 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.61.203 ]
5 550.90 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 13:06:43 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.53.154 ]
6 550.14 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_28 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 10:31:45 ]
7 545.83 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_7 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 17:44:27 ]
8 539.99 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_30 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 10:27:09 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.161.212 ]
9 522.35 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_28 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 10:31:45 ]
10 522.10 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 12:53:33 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.53.154 ]
11 519.48 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 17:46:00 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.45.126 ]
12 514.99 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 13:06:43 ]
13 514.68 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_30 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 10:27:09 ]
14 511.13 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_0 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 12:54:34 ]
15 509.04 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_7 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 17:44:27 ]
16 508.69 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_14 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 13:04:09 ]
17 488.80 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_30 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 10:27:09 ]
18 488.61 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_7 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 17:44:27 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.38.32 ]
19 477.61 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2019-01-01', 'YYYY-MM-DD') AND date <= to_date('2024-10-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 13:06:43 ]
20 477.37 MiB SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", SUM((data ->> 'media_cost_advertiser_currency')::numeric) AS "~DD0:media_cost_advertiser_currency:custom_platform_stats:1" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_14 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-23', 'YYYY-MM-DD') GROUP BY "level_1_id";[ Date: 2024-10-23 13:04:09 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 20.68 sec Highest CPU-cost vacuum
Table public.api_data_am_keyword_stats
Database sanofi_de84s4qcbsdrds - 2024-10-23 06:00:27 Date
- 0 sec Highest CPU-cost analyze
Table
Database sanofi_de84s4qcbsdrds - Date
Average Autovacuum Duration
Key values
- 20.68 sec Highest CPU-cost vacuum
Table public.api_data_am_keyword_stats
Database sanofi_de84s4qcbsdrds - 2024-10-23 06:00:27 Date
Analyzes per table
Key values
- public.data_sets_dataset (5) Main table analyzed (database sanofi_de84s4qcbsdrds)
- 17 analyzes Total
Table Number of analyzes sanofi_de84s4qcbsdrds.public.data_sets_dataset 5 sanofi_de84s4qcbsdrds.public.api_data_am_keyword_stats 2 sanofi_de84s4qcbsdrds.public.api_data_dcmfloodlightactivity 2 sanofi_de84s4qcbsdrds.public.api_data_customplatformstats 1 sanofi_de84s4qcbsdrds.public.api_data_am_campaign_stats 1 sanofi_de84s4qcbsdrds.public.api_data_am_info 1 sanofi_de84s4qcbsdrds.public.api_data_fb_campaign_stats_platformbreakdown_placement 1 sanofi_de84s4qcbsdrds.public.api_data_am_stats 1 sanofi_de84s4qcbsdrds.public.clients_campaign 1 sanofi_de84s4qcbsdrds.public.api_data_customplatforminfo 1 sanofi_de84s4qcbsdrds.public.api_data_am_platformobject 1 Total 17 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 2,928,115 0 0 4 67,629 0 0 0 sanofi_de84s4qcbsdrds.public.api_data_customplatformuniquefieldkey_1277 1 1 983,986 0 0 0 0 0 0 0 Total 4 4 3,912,101 379 0 4 67,629 0 0 0 Tuples removed per table
Key values
- public.api_data_am_keyword_stats (545562) Main table with removed tuples on database sanofi_de84s4qcbsdrds
- 566852 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 545,562 8,228,785 166,287 0 2,302,932 sanofi_de84s4qcbsdrds.public.api_data_customplatformuniquefieldkey_1277 1 1 21,290 8,124,469 7,038 0 487,810 Total 4 4 566,852 16,353,254 173,325 0 2,790,742 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 23 00 0 0 01 0 0 02 0 0 03 0 0 04 0 3 05 0 2 06 3 2 07 1 0 08 0 0 09 0 1 10 0 3 11 0 4 12 0 1 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 1 20 0 0 - 20.68 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareUpdateExclusiveLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s1ms 1s1ms 1s1ms 1s1ms analyze;-
analyze;
Date: 2024-10-23 06:01:57
Queries that waited the most
Rank Wait time Query 1 1s1ms analyze;[ Date: 2024-10-23 06:01:57 ]
-
Queries
Queries by type
Key values
- 1 Total read queries
- 4 Total write queries
Queries by database
Key values
- sanofi_de84s4qcbsdrds Main database
- 48 Requests
- 7h13m58s (sanofi_de84s4qcbsdrds)
- Main time consuming database
Queries by user
Key values
- u3m4c4715a71na Main user
- 48 Requests
User Request type Count Duration u3m4c4715a71na Total 48 7h13m58s cte 3 36m19s insert 1 5m45s others 43 6h25m30s select 1 6m23s Duration by user
Key values
- 7h13m58s (u3m4c4715a71na) Main time consuming user
User Request type Count Duration u3m4c4715a71na Total 48 7h13m58s cte 3 36m19s insert 1 5m45s others 43 6h25m30s select 1 6m23s Queries by host
Key values
- 10.24.167.205 Main host
- 8 Requests
- 58m48s (10.24.167.205)
- Main time consuming host
Host Request type Count Duration 10.24.161.210 Total 1 6m23s select 1 6m23s 10.24.161.212 Total 5 53m50s cte 1 16m30s others 4 37m20s 10.24.166.219 Total 3 54m17s others 3 54m17s 10.24.167.205 Total 8 58m48s cte 1 11m57s others 7 46m51s 10.24.170.189 Total 4 32m51s others 4 32m51s 10.24.177.34 Total 5 34m1s cte 1 7m51s others 4 26m9s 10.24.179.40 Total 2 31m14s others 2 31m14s 10.24.181.71 Total 1 5m45s insert 1 5m45s 10.24.34.220 Total 1 6m9s others 1 6m9s 10.24.34.94 Total 3 19m49s others 3 19m49s 10.24.36.115 Total 1 7m11s others 1 7m11s 10.24.39.78 Total 2 13m1s others 2 13m1s 10.24.40.134 Total 1 12m46s others 1 12m46s 10.24.41.87 Total 3 39m9s others 3 39m9s 10.24.45.126 Total 2 12m6s others 2 12m6s 10.24.48.209 Total 1 7m58s others 1 7m58s 10.24.49.197 Total 1 12m others 1 12m 10.24.59.250 Total 3 19m18s others 3 19m18s 10.24.61.203 Total 1 7m15s others 1 7m15s Queries by application
Key values
- unknown Main application
- 48 Requests
- 7h13m58s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-10-23 11:18:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 48 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 39m40s SET LOCAL work_mem = '100.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_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-23 11:25:18 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.166.219 ]
2 26m38s SET LOCAL work_mem = '100.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_7 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-23 11:39:05 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.41.87 ]
3 18m39s SET LOCAL work_mem = '100.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_28 scratch ON scratch.object_id = main.id;[ Date: 2024-10-23 11:07:59 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.161.212 ]
4 17m26s 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-23 08:19:32 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.179.40 ]
5 16m30s WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));[ Date: 2024-10-23 10:02:47 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.161.212 ]
6 13m47s 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-23 07:53:45 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.179.40 ]
7 12m46s SET LOCAL work_mem = '100.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_0 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-23 13:56:57 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.40.134 ]
8 12m SET LOCAL work_mem = '100.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_4 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');[ Date: 2024-10-23 11:24:27 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.49.197 ]
9 11m57s WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1243 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1243 AND "api_data_customplatformstats"."date" >= '2023-01-01' AND "api_data_customplatformstats"."date" <= '2025-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));[ Date: 2024-10-23 11:26:18 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.167.205 ]
10 9m38s SET LOCAL work_mem = '100.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_28 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');[ Date: 2024-10-23 10:27:47 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.170.189 ]
11 9m29s SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_16 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-23', 'YYYY-MM-DD');[ Date: 2024-10-23 11:00:09 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.167.205 ]
12 9m26s SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", data ->> 'session_manual_term' AS "~GA4-U13:session_manual_term:custom_platform_info:1", data ->> 'page_title' AS "~GA4-U13:page_title:custom_platform_info:1", data ->> 'full_page_url' AS "~GA4-U13:full_page_url:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = main.id;[ Date: 2024-10-23 10:15:51 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.166.219 ]
13 9m24s SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_12 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-23 10:58:49 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.170.189 ]
14 9m SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'unified_screen_name' AS "~GA4-U7:unified_screen_name:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U7:session_default_channel_group:custom_platform_info:1", data ->> 'session_source_medium' AS "~GA4-U7:session_source_medium:custom_platform_info:1", data ->> 'session_campaign_name' AS "~GA4-U7:session_campaign_name:custom_platform_info:1", data ->> 'event_name' AS "~GA4-U7:event_name:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_3 scratch ON scratch.object_id = main.id;[ Date: 2024-10-23 11:29:03 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.177.34 ]
15 8m24s SET LOCAL work_mem = '100.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_27 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-23 11:43:40 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.161.212 ]
16 7m58s SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'video_views' AS "GO:video_views:stats:1", data ->> 'total_video_quartile_p_100_views' AS "GO:total_video_quartile_p_100_views:stats:1", data ->> 'impressions' AS "GO:impressions:stats:1", data ->> 'spend' AS "GO:spend:stats:1" FROM api_data_go_stats stats JOIN api_data_datasetfetchscratch_19 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-23', 'YYYY-MM-DD');[ Date: 2024-10-23 11:18:19 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.48.209 ]
17 7m51s WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1065 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1065 AND "api_data_customplatformstats"."date" >= '2019-01-01' AND "api_data_customplatformstats"."date" <= '2024-10-23' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));[ Date: 2024-10-23 11:19:39 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.177.34 ]
18 7m39s SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'utid' AS "~PS2:utid:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_4 scratch ON scratch.object_id = main.id;[ Date: 2024-10-23 11:36:37 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.167.205 ]
19 7m22s SET LOCAL work_mem = '100.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_10 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');[ Date: 2024-10-23 00:06:06 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.34.94 ]
20 7m16s SET LOCAL work_mem = '100.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_14 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-23 18:05:34 - Database: sanofi_de84s4qcbsdrds - User: u3m4c4715a71na - Remote: 10.24.34.94 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 39m40s 1 39m40s 39m40s 39m40s 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_11 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 23 11 1 39m40s 39m40s [ User: u3m4c4715a71na - Total duration: 39m40s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_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-23 11:25:18 Duration: 39m40s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.166.219
2 36m19s 3 7m51s 16m30s 12m6s with custom_platform_info as ( select id from "api_data_customplatforminfo" where "portfolio_id" = ? and "platform_id" = ? ) select distinct "api_data_customplatformstats"."custom_platform_info_id" from "api_data_customplatformstats" where ("api_data_customplatformstats"."platform_id" = ? and "api_data_customplatformstats"."date" >= ? and "api_data_customplatformstats"."date" <= ? and "api_data_customplatformstats"."custom_platform_info_id" in ( select id from custom_platform_info));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 23 10 1 16m30s 16m30s 11 2 19m48s 9m54s [ User: u3m4c4715a71na - Total duration: 36m19s - Times executed: 3 ]
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 10:02:47 Duration: 16m30s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1243 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1243 AND "api_data_customplatformstats"."date" >= '2023-01-01' AND "api_data_customplatformstats"."date" <= '2025-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 11:26:18 Duration: 11m57s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1065 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1065 AND "api_data_customplatformstats"."date" >= '2019-01-01' AND "api_data_customplatformstats"."date" <= '2024-10-23' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 11:19:39 Duration: 7m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
3 33m4s 2 6m26s 26m38s 16m32s 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_7 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 23 11 1 26m38s 26m38s 13 1 6m26s 6m26s [ User: u3m4c4715a71na - Total duration: 33m4s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.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_7 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-23 11:39:05 Duration: 26m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.41.87
-
SET LOCAL work_mem = '100.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_7 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-23 13:05:37 Duration: 6m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.59.250
4 31m14s 2 13m47s 17m26s 15m37s 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 23 07 1 13m47s 13m47s 08 1 17m26s 17m26s [ User: u3m4c4715a71na - Total duration: 31m14s - 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-23 08:19:32 Duration: 17m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.179.40
-
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-23 07:53:45 Duration: 13m47s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.179.40
5 18m39s 1 18m39s 18m39s 18m39s 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_28 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 23 11 1 18m39s 18m39s [ User: u3m4c4715a71na - Total duration: 18m39s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_28 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:07:59 Duration: 18m39s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
6 17m57s 2 5m11s 12m46s 8m58s 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_0 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 23 13 1 12m46s 12m46s 17 1 5m11s 5m11s [ User: u3m4c4715a71na - Total duration: 17m57s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.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_0 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-23 13:56:57 Duration: 12m46s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.134
-
SET LOCAL work_mem = '100.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_0 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-23 17:44:53 Duration: 5m11s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
7 16m9s 2 6m45s 9m24s 8m4s 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_12 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 23 10 1 9m24s 9m24s 11 1 6m45s 6m45s [ User: u3m4c4715a71na - Total duration: 16m9s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_12 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 10:58:49 Duration: 9m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_12 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:28:42 Duration: 6m45s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
8 12m 1 12m 12m 12m 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_4 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 23 11 1 12m 12m [ User: u3m4c4715a71na - Total duration: 12m - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_4 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 11:24:27 Duration: 12m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.49.197
9 9m38s 1 9m38s 9m38s 9m38s 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_28 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 23 10 1 9m38s 9m38s [ User: u3m4c4715a71na - Total duration: 9m38s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_28 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 10:27:47 Duration: 9m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
10 9m29s 1 9m29s 9m29s 9m29s 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_16 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 23 11 1 9m29s 9m29s [ User: u3m4c4715a71na - Total duration: 9m29s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_16 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:00:09 Duration: 9m29s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
11 9m26s 1 9m26s 9m26s 9m26s 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:session_manual_term:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_18 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 23 10 1 9m26s 9m26s [ User: u3m4c4715a71na - Total duration: 9m26s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", data ->> 'session_manual_term' AS "~GA4-U13:session_manual_term:custom_platform_info:1", data ->> 'page_title' AS "~GA4-U13:page_title:custom_platform_info:1", data ->> 'full_page_url' AS "~GA4-U13:full_page_url:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 10:15:51 Duration: 9m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.166.219
12 9m 1 9m 9m 9m set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U7:unified_screen_name:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_default_channel_group:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_source_medium:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_campaign_name:custom_platform_info:1", data ->> ? AS "~GA4-U7:event_name:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_3 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 23 11 1 9m 9m [ User: u3m4c4715a71na - Total duration: 9m - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'unified_screen_name' AS "~GA4-U7:unified_screen_name:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U7:session_default_channel_group:custom_platform_info:1", data ->> 'session_source_medium' AS "~GA4-U7:session_source_medium:custom_platform_info:1", data ->> 'session_campaign_name' AS "~GA4-U7:session_campaign_name:custom_platform_info:1", data ->> 'event_name' AS "~GA4-U7:event_name:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_3 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:29:03 Duration: 9m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
13 8m24s 1 8m24s 8m24s 8m24s 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_27 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 23 11 1 8m24s 8m24s [ User: u3m4c4715a71na - Total duration: 8m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_27 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-23 11:43:40 Duration: 8m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
14 7m58s 1 7m58s 7m58s 7m58s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "GO:video_views:stats:1", data ->> ? AS "GO:total_video_quartile_p_100_views:stats:1", data ->> ? AS "GO:impressions:stats:1", data ->> ? AS "GO:spend:stats:1" from api_data_go_stats stats join api_data_datasetfetchscratch_19 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 23 11 1 7m58s 7m58s [ User: u3m4c4715a71na - Total duration: 7m58s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'video_views' AS "GO:video_views:stats:1", data ->> 'total_video_quartile_p_100_views' AS "GO:total_video_quartile_p_100_views:stats:1", data ->> 'impressions' AS "GO:impressions:stats:1", data ->> 'spend' AS "GO:spend:stats:1" FROM api_data_go_stats stats JOIN api_data_datasetfetchscratch_19 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:18:19 Duration: 7m58s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.48.209
15 7m39s 1 7m39s 7m39s 7m39s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:utid:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_4 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 23 11 1 7m39s 7m39s [ User: u3m4c4715a71na - Total duration: 7m39s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'utid' AS "~PS2:utid:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_4 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:36:37 Duration: 7m39s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
16 7m22s 1 7m22s 7m22s 7m22s 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_10 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 23 00 1 7m22s 7m22s [ User: u3m4c4715a71na - Total duration: 7m22s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_10 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 00:06:06 Duration: 7m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
17 7m16s 1 7m16s 7m16s 7m16s 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_14 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 23 18 1 7m16s 7m16s [ User: u3m4c4715a71na - Total duration: 7m16s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_14 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-23 18:05:34 Duration: 7m16s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
18 7m15s 1 7m15s 7m15s 7m15s 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_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 23 16 1 7m15s 7m15s [ User: u3m4c4715a71na - Total duration: 7m15s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 16:30:48 Duration: 7m15s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.61.203
19 7m11s 1 7m11s 7m11s 7m11s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 23 12 1 7m11s 7m11s [ User: u3m4c4715a71na - Total duration: 7m11s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 12:18:18 Duration: 7m11s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.36.115
20 7m7s 1 7m7s 7m7s 7m7s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 23 12 1 7m7s 7m7s [ User: u3m4c4715a71na - Total duration: 7m7s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 12:38:35 Duration: 7m7s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.41.87
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 3 36m19s 7m51s 16m30s 12m6s with custom_platform_info as ( select id from "api_data_customplatforminfo" where "portfolio_id" = ? and "platform_id" = ? ) select distinct "api_data_customplatformstats"."custom_platform_info_id" from "api_data_customplatformstats" where ("api_data_customplatformstats"."platform_id" = ? and "api_data_customplatformstats"."date" >= ? and "api_data_customplatformstats"."date" <= ? and "api_data_customplatformstats"."custom_platform_info_id" in ( select id from custom_platform_info));Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 23 10 1 16m30s 16m30s 11 2 19m48s 9m54s [ User: u3m4c4715a71na - Total duration: 36m19s - Times executed: 3 ]
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 10:02:47 Duration: 16m30s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1243 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1243 AND "api_data_customplatformstats"."date" >= '2023-01-01' AND "api_data_customplatformstats"."date" <= '2025-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 11:26:18 Duration: 11m57s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1065 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1065 AND "api_data_customplatformstats"."date" >= '2019-01-01' AND "api_data_customplatformstats"."date" <= '2024-10-23' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 11:19:39 Duration: 7m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
2 2 33m4s 6m26s 26m38s 16m32s 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_7 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 23 11 1 26m38s 26m38s 13 1 6m26s 6m26s [ User: u3m4c4715a71na - Total duration: 33m4s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.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_7 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-23 11:39:05 Duration: 26m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.41.87
-
SET LOCAL work_mem = '100.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_7 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-23 13:05:37 Duration: 6m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.59.250
3 2 31m14s 13m47s 17m26s 15m37s set local work_mem = ?; with deleted_infos as ( delete from api_data_customplatforminfo info using api_data_customplatforminfoscratch_0 info_to_delete where info.id = info_to_delete.info_id returning info.id, info.new_unique_field_key_id), inserted_infos as ( insert into one_bigint_scratch_0 select new_unique_field_key_id from deleted_infos ) select count(*) from deleted_infos;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 23 07 1 13m47s 13m47s 08 1 17m26s 17m26s [ User: u3m4c4715a71na - Total duration: 31m14s - 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-23 08:19:32 Duration: 17m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.179.40
-
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-23 07:53:45 Duration: 13m47s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.179.40
4 2 17m57s 5m11s 12m46s 8m58s 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_0 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 23 13 1 12m46s 12m46s 17 1 5m11s 5m11s [ User: u3m4c4715a71na - Total duration: 17m57s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.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_0 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-23 13:56:57 Duration: 12m46s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.134
-
SET LOCAL work_mem = '100.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_0 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-23 17:44:53 Duration: 5m11s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
5 2 16m9s 6m45s 9m24s 8m4s 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_12 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 23 10 1 9m24s 9m24s 11 1 6m45s 6m45s [ User: u3m4c4715a71na - Total duration: 16m9s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_12 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 10:58:49 Duration: 9m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_12 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:28:42 Duration: 6m45s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
6 1 39m40s 39m40s 39m40s 39m40s 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_11 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 23 11 1 39m40s 39m40s [ User: u3m4c4715a71na - Total duration: 39m40s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_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-23 11:25:18 Duration: 39m40s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.166.219
7 1 18m39s 18m39s 18m39s 18m39s 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_28 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 23 11 1 18m39s 18m39s [ User: u3m4c4715a71na - Total duration: 18m39s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_28 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:07:59 Duration: 18m39s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
8 1 12m 12m 12m 12m 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_4 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 23 11 1 12m 12m [ User: u3m4c4715a71na - Total duration: 12m - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_4 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 11:24:27 Duration: 12m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.49.197
9 1 9m38s 9m38s 9m38s 9m38s 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_28 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 23 10 1 9m38s 9m38s [ User: u3m4c4715a71na - Total duration: 9m38s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_28 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 10:27:47 Duration: 9m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
10 1 9m29s 9m29s 9m29s 9m29s 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_16 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 23 11 1 9m29s 9m29s [ User: u3m4c4715a71na - Total duration: 9m29s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_16 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:00:09 Duration: 9m29s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
11 1 9m26s 9m26s 9m26s 9m26s 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:session_manual_term:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_18 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 23 10 1 9m26s 9m26s [ User: u3m4c4715a71na - Total duration: 9m26s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", data ->> 'session_manual_term' AS "~GA4-U13:session_manual_term:custom_platform_info:1", data ->> 'page_title' AS "~GA4-U13:page_title:custom_platform_info:1", data ->> 'full_page_url' AS "~GA4-U13:full_page_url:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 10:15:51 Duration: 9m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.166.219
12 1 9m 9m 9m 9m set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U7:unified_screen_name:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_default_channel_group:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_source_medium:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_campaign_name:custom_platform_info:1", data ->> ? AS "~GA4-U7:event_name:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_3 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 23 11 1 9m 9m [ User: u3m4c4715a71na - Total duration: 9m - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'unified_screen_name' AS "~GA4-U7:unified_screen_name:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U7:session_default_channel_group:custom_platform_info:1", data ->> 'session_source_medium' AS "~GA4-U7:session_source_medium:custom_platform_info:1", data ->> 'session_campaign_name' AS "~GA4-U7:session_campaign_name:custom_platform_info:1", data ->> 'event_name' AS "~GA4-U7:event_name:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_3 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:29:03 Duration: 9m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
13 1 8m24s 8m24s 8m24s 8m24s 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_27 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 23 11 1 8m24s 8m24s [ User: u3m4c4715a71na - Total duration: 8m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_27 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-23 11:43:40 Duration: 8m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
14 1 7m58s 7m58s 7m58s 7m58s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "GO:video_views:stats:1", data ->> ? AS "GO:total_video_quartile_p_100_views:stats:1", data ->> ? AS "GO:impressions:stats:1", data ->> ? AS "GO:spend:stats:1" from api_data_go_stats stats join api_data_datasetfetchscratch_19 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 23 11 1 7m58s 7m58s [ User: u3m4c4715a71na - Total duration: 7m58s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'video_views' AS "GO:video_views:stats:1", data ->> 'total_video_quartile_p_100_views' AS "GO:total_video_quartile_p_100_views:stats:1", data ->> 'impressions' AS "GO:impressions:stats:1", data ->> 'spend' AS "GO:spend:stats:1" FROM api_data_go_stats stats JOIN api_data_datasetfetchscratch_19 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:18:19 Duration: 7m58s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.48.209
15 1 7m39s 7m39s 7m39s 7m39s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:utid:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_4 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 23 11 1 7m39s 7m39s [ User: u3m4c4715a71na - Total duration: 7m39s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'utid' AS "~PS2:utid:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_4 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:36:37 Duration: 7m39s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
16 1 7m22s 7m22s 7m22s 7m22s 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_10 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 23 00 1 7m22s 7m22s [ User: u3m4c4715a71na - Total duration: 7m22s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_10 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 00:06:06 Duration: 7m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
17 1 7m16s 7m16s 7m16s 7m16s 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_14 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 23 18 1 7m16s 7m16s [ User: u3m4c4715a71na - Total duration: 7m16s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_14 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-23 18:05:34 Duration: 7m16s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
18 1 7m15s 7m15s 7m15s 7m15s 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_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 23 16 1 7m15s 7m15s [ User: u3m4c4715a71na - Total duration: 7m15s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 16:30:48 Duration: 7m15s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.61.203
19 1 7m11s 7m11s 7m11s 7m11s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 23 12 1 7m11s 7m11s [ User: u3m4c4715a71na - Total duration: 7m11s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 12:18:18 Duration: 7m11s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.36.115
20 1 7m7s 7m7s 7m7s 7m7s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 23 12 1 7m7s 7m7s [ User: u3m4c4715a71na - Total duration: 7m7s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 12:38:35 Duration: 7m7s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.41.87
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 39m40s 39m40s 39m40s 1 39m40s 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_11 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 23 11 1 39m40s 39m40s [ User: u3m4c4715a71na - Total duration: 39m40s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_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-23 11:25:18 Duration: 39m40s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.166.219
2 18m39s 18m39s 18m39s 1 18m39s 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_28 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 23 11 1 18m39s 18m39s [ User: u3m4c4715a71na - Total duration: 18m39s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_28 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:07:59 Duration: 18m39s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
3 6m26s 26m38s 16m32s 2 33m4s 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_7 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 23 11 1 26m38s 26m38s 13 1 6m26s 6m26s [ User: u3m4c4715a71na - Total duration: 33m4s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.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_7 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-23 11:39:05 Duration: 26m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.41.87
-
SET LOCAL work_mem = '100.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_7 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-23 13:05:37 Duration: 6m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.59.250
4 13m47s 17m26s 15m37s 2 31m14s 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 23 07 1 13m47s 13m47s 08 1 17m26s 17m26s [ User: u3m4c4715a71na - Total duration: 31m14s - 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-23 08:19:32 Duration: 17m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.179.40
-
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-23 07:53:45 Duration: 13m47s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.179.40
5 7m51s 16m30s 12m6s 3 36m19s with custom_platform_info as ( select id from "api_data_customplatforminfo" where "portfolio_id" = ? and "platform_id" = ? ) select distinct "api_data_customplatformstats"."custom_platform_info_id" from "api_data_customplatformstats" where ("api_data_customplatformstats"."platform_id" = ? and "api_data_customplatformstats"."date" >= ? and "api_data_customplatformstats"."date" <= ? and "api_data_customplatformstats"."custom_platform_info_id" in ( select id from custom_platform_info));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 23 10 1 16m30s 16m30s 11 2 19m48s 9m54s [ User: u3m4c4715a71na - Total duration: 36m19s - Times executed: 3 ]
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1277 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1277 AND "api_data_customplatformstats"."date" >= '2024-01-01' AND "api_data_customplatformstats"."date" <= '2024-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 10:02:47 Duration: 16m30s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1243 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1243 AND "api_data_customplatformstats"."date" >= '2023-01-01' AND "api_data_customplatformstats"."date" <= '2025-12-31' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 11:26:18 Duration: 11m57s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
-
WITH custom_platform_info AS ( SELECT id FROM "api_data_customplatforminfo" WHERE "portfolio_id" = 1 AND "platform_id" = 1065 ) SELECT DISTINCT "api_data_customplatformstats"."custom_platform_info_id" FROM "api_data_customplatformstats" WHERE ("api_data_customplatformstats"."platform_id" = 1065 AND "api_data_customplatformstats"."date" >= '2019-01-01' AND "api_data_customplatformstats"."date" <= '2024-10-23' AND "api_data_customplatformstats"."custom_platform_info_id" IN ( SELECT id FROM custom_platform_info));
Date: 2024-10-23 11:19:39 Duration: 7m51s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
6 12m 12m 12m 1 12m 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_4 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 23 11 1 12m 12m [ User: u3m4c4715a71na - Total duration: 12m - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_4 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 11:24:27 Duration: 12m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.49.197
7 9m38s 9m38s 9m38s 1 9m38s 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_28 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 23 10 1 9m38s 9m38s [ User: u3m4c4715a71na - Total duration: 9m38s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_28 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2022-01-01', 'YYYY-MM-DD') AND date <= to_date('2022-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 10:27:47 Duration: 9m38s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
8 9m29s 9m29s 9m29s 1 9m29s 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_16 scratch on scratch.object_id = stats.custom_platform_info_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 23 11 1 9m29s 9m29s [ User: u3m4c4715a71na - Total duration: 9m29s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_16 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:00:09 Duration: 9m29s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
9 9m26s 9m26s 9m26s 1 9m26s 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:session_manual_term:custom_platform_info:1", data ->> ? AS "~GA4-U13:page_title:custom_platform_info:1", data ->> ? AS "~GA4-U13:full_page_url:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_18 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 23 10 1 9m26s 9m26s [ User: u3m4c4715a71na - Total duration: 9m26s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'session_default_channel_group' AS "~GA4-U13:session_default_channel_group:custom_platform_info:1", data ->> 'session_manual_term' AS "~GA4-U13:session_manual_term:custom_platform_info:1", data ->> 'page_title' AS "~GA4-U13:page_title:custom_platform_info:1", data ->> 'full_page_url' AS "~GA4-U13:full_page_url:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_18 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 10:15:51 Duration: 9m26s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.166.219
10 9m 9m 9m 1 9m set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~GA4-U7:unified_screen_name:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_default_channel_group:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_source_medium:custom_platform_info:1", data ->> ? AS "~GA4-U7:session_campaign_name:custom_platform_info:1", data ->> ? AS "~GA4-U7:event_name:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_3 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 23 11 1 9m 9m [ User: u3m4c4715a71na - Total duration: 9m - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'unified_screen_name' AS "~GA4-U7:unified_screen_name:custom_platform_info:1", data ->> 'session_default_channel_group' AS "~GA4-U7:session_default_channel_group:custom_platform_info:1", data ->> 'session_source_medium' AS "~GA4-U7:session_source_medium:custom_platform_info:1", data ->> 'session_campaign_name' AS "~GA4-U7:session_campaign_name:custom_platform_info:1", data ->> 'event_name' AS "~GA4-U7:event_name:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_3 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:29:03 Duration: 9m Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.177.34
11 5m11s 12m46s 8m58s 2 17m57s 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_0 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 23 13 1 12m46s 12m46s 17 1 5m11s 5m11s [ User: u3m4c4715a71na - Total duration: 17m57s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.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_0 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-23 13:56:57 Duration: 12m46s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.40.134
-
SET LOCAL work_mem = '100.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_0 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-23 17:44:53 Duration: 5m11s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
12 8m24s 8m24s 8m24s 1 8m24s 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_27 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 23 11 1 8m24s 8m24s [ User: u3m4c4715a71na - Total duration: 8m24s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_27 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-23 11:43:40 Duration: 8m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.161.212
13 6m45s 9m24s 8m4s 2 16m9s 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_12 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 23 10 1 9m24s 9m24s 11 1 6m45s 6m45s [ User: u3m4c4715a71na - Total duration: 16m9s - Times executed: 2 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_12 scratch ON scratch.object_id = stats.custom_platform_info_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 10:58:49 Duration: 9m24s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
-
SET LOCAL work_mem = '100.00MB'; SELECT custom_platform_info_id AS "level_1_id", date AS "date:internal" FROM api_data_customplatformstats stats JOIN api_data_datasetfetchscratch_12 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:28:42 Duration: 6m45s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.170.189
14 7m58s 7m58s 7m58s 1 7m58s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "GO:video_views:stats:1", data ->> ? AS "GO:total_video_quartile_p_100_views:stats:1", data ->> ? AS "GO:impressions:stats:1", data ->> ? AS "GO:spend:stats:1" from api_data_go_stats stats join api_data_datasetfetchscratch_19 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 23 11 1 7m58s 7m58s [ User: u3m4c4715a71na - Total duration: 7m58s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'video_views' AS "GO:video_views:stats:1", data ->> 'total_video_quartile_p_100_views' AS "GO:total_video_quartile_p_100_views:stats:1", data ->> 'impressions' AS "GO:impressions:stats:1", data ->> 'spend' AS "GO:spend:stats:1" FROM api_data_go_stats stats JOIN api_data_datasetfetchscratch_19 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-23', 'YYYY-MM-DD');
Date: 2024-10-23 11:18:19 Duration: 7m58s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.48.209
15 7m39s 7m39s 7m39s 1 7m39s set local work_mem = ?; select id AS "level_1_id", data ->> ? AS "~PS2:redirect_id:custom_platform_info:1", data ->> ? AS "~PS2:originating_brand:custom_platform_info:1", data ->> ? AS "~PS2:utid:custom_platform_info:1" from api_data_customplatforminfo main join api_data_datasetfetchscratch_4 scratch on scratch.object_id = main.id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 23 11 1 7m39s 7m39s [ User: u3m4c4715a71na - Total duration: 7m39s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT id AS "level_1_id", data ->> 'redirect_id' AS "~PS2:redirect_id:custom_platform_info:1", data ->> 'originating_brand' AS "~PS2:originating_brand:custom_platform_info:1", data ->> 'utid' AS "~PS2:utid:custom_platform_info:1" FROM api_data_customplatforminfo main JOIN api_data_datasetfetchscratch_4 scratch ON scratch.object_id = main.id;
Date: 2024-10-23 11:36:37 Duration: 7m39s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.167.205
16 7m22s 7m22s 7m22s 1 7m22s 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_10 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 23 00 1 7m22s 7m22s [ User: u3m4c4715a71na - Total duration: 7m22s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_10 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 00:06:06 Duration: 7m22s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
17 7m16s 7m16s 7m16s 1 7m16s 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_14 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 23 18 1 7m16s 7m16s [ User: u3m4c4715a71na - Total duration: 7m16s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_14 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-23 18:05:34 Duration: 7m16s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.34.94
18 7m15s 7m15s 7m15s 1 7m15s 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_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 23 16 1 7m15s 7m15s [ User: u3m4c4715a71na - Total duration: 7m15s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.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_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 16:30:48 Duration: 7m15s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.61.203
19 7m11s 7m11s 7m11s 1 7m11s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1", data ->> ? AS "SA:spend:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 23 12 1 7m11s 7m11s [ User: u3m4c4715a71na - Total duration: 7m11s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1", data ->> 'spend' AS "SA:spend:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 12:18:18 Duration: 7m11s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.36.115
20 7m7s 7m7s 7m7s 1 7m7s set local work_mem = ?; select platform_object_id AS "level_1_id", date AS "date:internal", data ->> ? AS "SA:spend:stats:1", data ->> ? AS "SA:clicks:stats:1", data ->> ? AS "SA:impressions:stats:1" from api_data_sa_stats stats join api_data_datasetfetchscratch_26 scratch on scratch.object_id = stats.platform_object_id where date >= to_date(?, ?) and date <= to_date(?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 23 12 1 7m7s 7m7s [ User: u3m4c4715a71na - Total duration: 7m7s - Times executed: 1 ]
-
SET LOCAL work_mem = '100.00MB'; SELECT platform_object_id AS "level_1_id", date AS "date:internal", data ->> 'spend' AS "SA:spend:stats:1", data ->> 'clicks' AS "SA:clicks:stats:1", data ->> 'impressions' AS "SA:impressions:stats:1" FROM api_data_sa_stats stats JOIN api_data_datasetfetchscratch_26 scratch ON scratch.object_id = stats.platform_object_id WHERE date >= to_date('2023-01-01', 'YYYY-MM-DD') AND date <= to_date('2025-12-31', 'YYYY-MM-DD');
Date: 2024-10-23 12:38:35 Duration: 7m7s Database: sanofi_de84s4qcbsdrds User: u3m4c4715a71na Remote: 10.24.41.87
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
- 8,596 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
- 10 ERROR entries
- 0 WARNING entries
- 8144 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 8,127 Max number of times the same event was reported
- 8,154 Total events found
Rank Times reported Error 1 8,127 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 23 00 18 01 6 02 1,580 03 7 04 676 05 35 06 28 07 250 08 536 09 2,107 10 214 11 230 12 126 13 206 14 153 15 5 16 229 17 59 18 27 19 1,634 20 1 2 16 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 23 06 3 09 1 10 2 11 3 12 1 13 4 14 1 17 1 3 4 ERROR: table "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 23 18 4 - ERROR: table "api_data_customplatformstatsscratch_1" does not exist
- ERROR: table "api_data_customplatformstatsscratch_2" does not exist
- ERROR: table "api_data_customplatformstatsscratch_3" does not exist
Statement: drop table api_data_customplatformstatsscratch_1;
Date: 2024-10-23 18:17:06 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.169.215
Statement: drop table api_data_customplatformstatsscratch_2;
Date: 2024-10-23 18:17:07 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.169.215
Statement: drop table api_data_customplatformstatsscratch_3;
Date: 2024-10-23 18:17:08 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.169.215
4 4 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 23 07 1 08 2 18 1 - 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_worker_scheduler_date_name_request_id_df285f03_uniq"
- ERROR: duplicate key value violates unique constraint "api_data_job_worker_id_job_name_f8c82ace_uniq"
Detail: Key (worker_id, job_name)=(1974217, CUSTOM_PLATFORM_UPLOAD_APPLY_RULES_572462_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-23T07:12:34.936262+00:00'::timestamptz, '2024-10-23T07:12:34.936275+00:00'::timestamptz, 1974217, 'CUSTOM_PLATFORM_UPLOAD_APPLY_RULES_572462_LAST_JOB', 0, 5, '2024-10-23T03:12:34.932693-04:00'::timestamptz, NULL, NULL, '[]', '{"is_finishing_job": true, "request_id": "572462"}', NULL, NULL, NULL, NULL, NULL) RETURNING "api_data_job"."id"Date: 2024-10-23 07:12:34 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.34.94
Detail: Key (scheduler, date, name, request_id)=(4, 2024-10-23, 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-23T08:27:33.563278+00:00'::timestamptz, '2024-10-23T08:27:33.563292+00:00'::timestamptz, 4, '2024-10-23'::date, '552893', NULL, NULL, NULL, NULL, false, 'CUSTOM_PLATFORM_UPLOAD_APPLY_RULES', 0, 0, NULL, NULL, 'UserTaskScheduler:2024-10-23', NULL) RETURNING "api_data_worker"."id"Date: 2024-10-23 08:27:33 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.171.182
Detail: Key (worker_id, job_name)=(1974265, 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-23T08:28:20.666032+00:00'::timestamptz, '2024-10-23T08:28:20.666044+00:00'::timestamptz, 1974265, 'CUSTOM_PLATFORM_UPLOAD_APPLY_RULES_552860_LAST_JOB', 0, 5, '2024-10-23T04:28:20.662541-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-23 08:28:20 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.40.134
5 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 23 06 1 6 1 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 23 17 1 - ERROR: deadlock detected
Detail: Process 11525 waits for ShareLock on transaction 244082922; blocked by process 11524. Process 11524 waits for ShareLock on transaction 244082924; blocked by process 11525. Process 11525: INSERT INTO api_data_customplatforminfo AS orig ("platform_id","currency","data","portfolio_id","custom_platform_template_upload_id","new_unique_field_key_id","created","updated") VALUES (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.794000+00:00", "creative_id": "Unknown", "fivetran_id": "VRd5oRfW/1L9bc2LXnxkG77HbRc=", "line_item_id": "21070798444", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1430205485,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.218000+00:00", "creative_id": "Unknown", "fivetran_id": "I7Ue22TSe/cgnrrnMebrdKDsrKk=", "line_item_id": "21794757760", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1876714124,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.207000+00:00", "creative_id": "Unknown", "fivetran_id": "cSqilliOKuxIULGhfKJI2Mg8D6s=", "line_item_id": "21825155176", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018610376", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1894277881,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.225000+00:00", "creative_id": "Unknown", "fivetran_id": "fVjZ7wpYzmN1InG1y7lGBVJR0qE=", "line_item_id": "21814801881", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018960777", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1894277891,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.232000+00:00", "creative_id": "Unknown", "fivetran_id": "hTsd8lPvibypXzOTi2zPG/TiJQw=", "line_item_id": "21784383060", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1876714119,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type Process 11524: INSERT INTO api_data_customplatforminfo AS orig ("currency","platform_id","data","portfolio_id","custom_platform_template_upload_id","new_unique_field_key_id","created","updated") VALUES (0,1054,'{"campaign": "Gold Bond_2024", "partner_currency": "USD", "device_type": "Smart Phone", "line_item_id": "21825093022", "appurl_id": "101266649351", "creative_id": "Unknown", "fivetran_synced": "2024-10-23 17:35:09.653000+00:00", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "publisher_property": "Unknown", "creative": "Unknown", "fivetran_id": "d5CIpvNb3/Bq2AnXrqO9DjKVVh8=", "partner": "Havas Media USA", "creative_type": "Standard", "advertiser_id": "5166141", "appurl": "youtube.com", "insertion_order_id": "1018607333", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "advertiser": "HMNYC_Sanofi CHC Gold Bond"}',1,627209,1894277898,'NOW()','NOW()'), (0,1054,'{"campaign": "Gold Bond_2024", "partner_currency": "USD", "device_type": "Desktop", "line_item_id": "21776089375", "appurl_id": "101266649351", "creative_id": "Unknown", "fivetran_synced": "2024-10-23 17:35:09.648000+00:00", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "publisher_property": "Unknown", "creative": "Unknown", "fivetran_id": "kgDu3ueV5TcRusD/nUEDgtRw22w=", "partner": "Havas Media USA", "creative_type": "Standard", "advertiser_id": "5166141", "appurl": "youtube.com", "insertion_order_id": "1018420410", "line_item": "All Creatives_Efficient Reach 2.0 Line", "advertiser": "HMNYC_Sanofi CHC Gold Bond"}',1,627209,1867189960,'NOW()','NOW()'), (0,1054,'{"campaign": "Icy Hot_2024", "partner_currency": "USD", "device_type": "Tablet", "line_item_id": "21814620153", "appurl_id": "101266649351", "creative_id": "Unknown", "fivetran_synced": "2024-10-23 17:35:09.736000+00:00", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "campaign_id": "54328319", "publisher_property": "Unknown", "creative": "Unknown", "fivetran_id": "A1PBes651LqxV+pi5ftpx9iRvVc=", "partner": "Havas Media USA", "creative_type": "Standard", "advertiser_id": "5166147", "appurl": "youtube.com", "insertion_order_id": "1018959577", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "advertiser": "HMNYC_Sanofi CHC Icy Hot"}',1,627209,1894277937,'NOW()','NOW()'), (0,1054,'{"campaign": "Icy Hot_2024", "partner_currency": "USD", "device_type": "Smart Phone", "line_item_id": "21133277217", "appurl_id": "101266649351", "creative_id": "Unknown", "fivetran_synced": "2024-10-23 17:35:09.732000+00:00", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "publisher_property": "Unknown", "creative": "Unknown", "fivetran_id": "8KrOgFFiazcb6oysPdT6UIom0LE=", "partner": "Havas Media USA", "creative_type": "Standard", "advertiser_id": "5166147", "appurl": "youtube.com", "insertion_order_id": "1016625613", "line_item": "TRV_AUD_ALL_CustomIntent: Relevant Keywords URLs and App Alignment 15s_CPM", "advertiser": "HMNYC_Sanofi CHC Icy Hot"}',1,627209,1480002498,'NOW()','NOW()'), (0,1054,'{"campaign": "Gold Bond_2024", "partner_currency": "USD", "device_type": "Smart Phone", "line_item_id": "21784383060", "appurl_id": "101266649351", "creative_id": "Unknown", "fivetran_synced": "2024-10-23 17:35:09.656000+00:00", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "publisher_property": "Unknown", "creative": "Unknown", "fivetran_id": "e/u1oS48SVEpLoYgu0aDxWOW8gE=", "partner": "Havas Media USA", "creative_type": "Standard", "advertiser_id": "5166141", "appurl": "youtube.com", "insertion_order_id": "1018420410", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "advertiser": "HMNYC_Sanofi CHC Gold Bond"}',1,627209,1876714119,'NOW()','NOW()'), (0,1054,'{"campaign": "Gold Bond_2024", "partner_cur
Context: while inserting index tuple (2562107,4) in relation "api_data_customplatforminfo"
Hint: See server log for query details.
Statement: INSERT INTO api_data_customplatforminfo AS orig ("platform_id","currency","data","portfolio_id","custom_platform_template_upload_id","new_unique_field_key_id","created","updated") VALUES (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.794000+00:00", "creative_id": "Unknown", "fivetran_id": "VRd5oRfW/1L9bc2LXnxkG77HbRc=", "line_item_id": "21070798444", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1430205485,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.218000+00:00", "creative_id": "Unknown", "fivetran_id": "I7Ue22TSe/cgnrrnMebrdKDsrKk=", "line_item_id": "21794757760", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1876714124,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.207000+00:00", "creative_id": "Unknown", "fivetran_id": "cSqilliOKuxIULGhfKJI2Mg8D6s=", "line_item_id": "21825155176", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018610376", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1894277881,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.225000+00:00", "creative_id": "Unknown", "fivetran_id": "fVjZ7wpYzmN1InG1y7lGBVJR0qE=", "line_item_id": "21814801881", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018960777", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1894277891,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.232000+00:00", "creative_id": "Unknown", "fivetran_id": "hTsd8lPvibypXzOTi2zPG/TiJQw=", "line_item_id": "21784383060", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1876714119,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.227000+00:00", "creative_id": "Unknown", "fivetran_id": "41CiOPmjKmwSgQTUEzLXidyxnRI=", "line_item_id": "21794757760", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1876714120,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT Shorts YouTube DV360_2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.491000+00:00", "creative_id": "Unknown", "fivetran_id": "Tty2gRcxk4Du664RRj58x7shaMI=", "line_item_id": "21821194700", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018957912", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1894277930,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.236000+00:00", "creative_id": "Unknown", "fivetran_id": "rAvzhiCPsc0uFQ3fT0+un+vVjuw=", "line_item_id": "21794757760", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1876714126,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.229000+00:00", "creative_id": "Unknown", "fivetran_id": "5Px87rCop8FhFp4+7dHx6DLF6Bw=", "line_item_id": "21825093022", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018607333", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1894277898,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.490000+00:00", "creative_id": "Unknown", "fivetran_id": "0V4zfqXxDwjNu6YD8TZpNiK69b4=", "line_item_id": "21814620153", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018959577", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1894277931,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT Shorts YouTube DV360_2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.484000+00:00", "creative_id": "Unknown", "fivetran_id": "g0OL1NCY305aWpZT2SHfvq2T/Yk=", "line_item_id": "21821194700", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018957912", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1894277924,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.234000+00:00", "creative_id": "Unknown", "fivetran_id": "bGedDh6WJO7hVj7SZRRayo3gW+4=", "line_item_id": "21814801881", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018960777", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1894277900,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT Shorts YouTube DV360_2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.471000+00:00", "creative_id": "Unknown", "fivetran_id": "eac3xlsd+EKnUySH00RX/cy+UEU=", "line_item_id": "21821194700", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018957912", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1894277918,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.238000+00:00", "creative_id": "Unknown", "fivetran_id": "IW3znn12U4UDN4bc8QQVL2xw49I=", "line_item_id": "21825093022", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018607333", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1894277907,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT Shorts YouTube DV360_2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.496000+00:00", "creative_id": "Unknown", "fivetran_id": "iw1U08wQj5AlXaVb7ifGiQ/pqSI=", "line_item_id": "21821194700", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018957912", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1894277936,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.220000+00:00", "creative_id": "Unknown", "fivetran_id": "AltnxTbJdN72abM4Gx84cKAlTi8=", "line_item_id": "21825093022", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018607333", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1894277889,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.241000+00:00", "creative_id": "Unknown", "fivetran_id": "5mf8v2xwoc1Lve9I2oYc/euRZoI=", "line_item_id": "21784383060", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1876714123,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.206000+00:00", "creative_id": "Unknown", "fivetran_id": "b5vH2XF9b3eAuJlY+riWwq1A+nA=", "line_item_id": "21825093022", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT 6&15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018607333", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1894277880,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.470000+00:00", "creative_id": "Unknown", "fivetran_id": "FsICAUCRt5HjdbI9+gEmhlFpr6s=", "line_item_id": "21814620153", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018959577", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1894277919,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.243000+00:00", "creative_id": "Unknown", "fivetran_id": "uedns/Wa7jG4WCSMMd6uoOvCh6Y=", "line_item_id": "21814801881", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018960777", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1894277909,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.233000+00:00", "creative_id": "Unknown", "fivetran_id": "X4PjZga60FoCl0/WiFTpDn2lNgA=", "line_item_id": "21821314052", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT 6&15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018605443", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1894277897,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.211000+00:00", "creative_id": "Unknown", "fivetran_id": "Ve7WgNgRZh2LEwLdQaASQPYLVCE=", "line_item_id": "21821314052", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT 6&15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018605443", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1894277879,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.483000+00:00", "creative_id": "Unknown", "fivetran_id": "VtFq7Z7NncVB1RdwDQg4LQ4EVl8=", "line_item_id": "21814620153", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018959577", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1894277925,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.224000+00:00", "creative_id": "Unknown", "fivetran_id": "9xtSCva2GfUSjXZxRo6d03pZdU4=", "line_item_id": "21821314052", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT 6&15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018605443", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1894277888,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.230000+00:00", "creative_id": "Unknown", "fivetran_id": "blEl+GI3P79OWoxKHZTdrVy7Kuc=", "line_item_id": "21825155176", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018610376", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1894277899,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.245000+00:00", "creative_id": "Unknown", "fivetran_id": "aLDZgXPb0Wp6ivuLNgcnfEnkqew=", "line_item_id": "21794757760", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1876714121,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.239000+00:00", "creative_id": "Unknown", "fivetran_id": "9N/BaAtDnz7kGc+jD8nYijkrJnw=", "line_item_id": "21825155176", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018610376", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1894277908,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.210000+00:00", "creative_id": "Unknown", "fivetran_id": "Ow9PcIAUYeCqgjfztn+RGV2Tt4U=", "line_item_id": "21784383060", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1876714122,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.223000+00:00", "creative_id": "Unknown", "fivetran_id": "zQTjoSW3E2aOgRgLDP4aZI32f3Q=", "line_item_id": "21784383060", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Shorts Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1876714125,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT 6&15s NonSkip YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.242000+00:00", "creative_id": "Unknown", "fivetran_id": "iZVAFdGiK4BDo5a+TRxSdptcEKg=", "line_item_id": "21821314052", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT 6&15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018605443", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1894277906,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.496000+00:00", "creative_id": "Unknown", "fivetran_id": "urWXtJa465ey4DEf+8T2N+irH+I=", "line_item_id": "21814620153", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Icy Hot Awareness YouTube SELECT 15s NonSkip YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018959577", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1894277937,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.216000+00:00", "creative_id": "Unknown", "fivetran_id": "lT4jayZ4IgmgisveYsjppG+kTSY=", "line_item_id": "21814801881", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 55+ SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018960777", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1894277882,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:25.221000+00:00", "creative_id": "Unknown", "fivetran_id": "Qn0Z8jwu8GAaljYEow5AMq7nRhA=", "line_item_id": "21825155176", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "Sanofi CHC_Gold Bond Consideration Healing 35-54 SELECT Shorts YouTube DV360_2024", "appurl": "youtube.com", "insertion_order_id": "1018610376", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1894277890,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.361000+00:00", "creative_id": "Unknown", "fivetran_id": "KyIPCZSF7TBcy4I1l0KDdtF8c7U=", "line_item_id": "20958541367", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1409760373,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.432000+00:00", "creative_id": "Unknown", "fivetran_id": "9h9YoHDV482c6LFbzDAY3N683Aw=", "line_item_id": "21067595645", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_RTG_ALL_LAL/RTG: Build Look-A-Likes off Allegra Site Visitors/Retarget Allegra site visitors 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1430205504,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.436000+00:00", "creative_id": "Unknown", "fivetran_id": "+BrJe3dcBDCPAtmkOfpmUSz6RgQ=", "line_item_id": "21507563691", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creative", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1737501914,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.448000+00:00", "creative_id": "Unknown", "fivetran_id": "4d03xfBNueca0jZgpkZ103zC2YM=", "line_item_id": "21060804903", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Outdoor Enthusiasts 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1430205604,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.417000+00:00", "creative_id": "Unknown", "fivetran_id": "CSrRPrSKVacnwbDVIhxIfH9QErU=", "line_item_id": "21070798444", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1430205447,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.353000+00:00", "creative_id": "Unknown", "fivetran_id": "a6uydUfjwItw/cb1ia9M9yLHNtg=", "line_item_id": "20961579538", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Outdoor Enthusiasts 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1409760398,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.397000+00:00", "creative_id": "Unknown", "fivetran_id": "CJX+pyIfTu5hbqNIqeRWcNTmqro=", "line_item_id": "20952159264", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_RTG_ALL_LAL/RTG: Build Look-A-Likes off Allegra Site Visitors/Retarget Allegra site visitors 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1409760362,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.377000+00:00", "creative_id": "Unknown", "fivetran_id": "K3KGZtxhe2hqj2soMsQJtYeZ36k=", "line_item_id": "21070798444", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1430205471,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.408000+00:00", "creative_id": "Unknown", "fivetran_id": "VDfRJkB83Q+nJ64/9NsslcBrQG0=", "line_item_id": "21067593806", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomAffinity: Qualified audience profile based on relevant keywords, URLs and app alignment 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1430205446,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.533000+00:00", "creative_id": "Unknown", "fivetran_id": "bTP5jyccqsmSYbMtvmwAPm72268=", "line_item_id": "21067595645", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_RTG_ALL_LAL/RTG: Build Look-A-Likes off Allegra Site Visitors/Retarget Allegra site visitors 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1430205483,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.355000+00:00", "creative_id": "Unknown", "fivetran_id": "k+lBMJNLR5ehfshBMP3kvgBKv7I=", "line_item_id": "21060804903", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Outdoor Enthusiasts 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1430205652,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.403000+00:00", "creative_id": "Unknown", "fivetran_id": "C7FKTuBPVBDPPLzZIZQ2D2aaXdE=", "line_item_id": "21060804903", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Outdoor Enthusiasts 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1430205736,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.431000+00:00", "creative_id": "Unknown", "fivetran_id": "Mn/T5y8MZrp7xyRm1ythUXZrVD4=", "line_item_id": "20952159264", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_RTG_ALL_LAL/RTG: Build Look-A-Likes off Allegra Site Visitors/Retarget Allegra site visitors 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1409760365,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.453000+00:00", "creative_id": "Unknown", "fivetran_id": "9k2y2+gApmuDKWJPUx7o9Gn/M84=", "line_item_id": "20952159264", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_RTG_ALL_LAL/RTG: Build Look-A-Likes off Allegra Site Visitors/Retarget Allegra site visitors 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1409760347,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.437000+00:00", "creative_id": "Unknown", "fivetran_id": "LDaX/zkbnDHa0NkjZJDtUaPH5xY=", "line_item_id": "20961579538", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Outdoor Enthusiasts 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1409760345,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.338000+00:00", "creative_id": "Unknown", "fivetran_id": "q64MF1m6YK85OiYqX0Dw/4q4ztI=", "line_item_id": "21507563691", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creative", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1737501894,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.451000+00:00", "creative_id": "Unknown", "fivetran_id": "bZlP2/lN+PQW2UHnYmR3EZ/uYQk=", "line_item_id": "21067593806", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomAffinity: Qualified audience profile based on relevant keywords, URLs and app alignment 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1430205431,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.315000+00:00", "creative_id": "Unknown", "fivetran_id": "HE4wXgdp2JsT4pWiKLBcgFeiaRY=", "line_item_id": "21067595645", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_RTG_ALL_LAL/RTG: Build Look-A-Likes off Allegra Site Visitors/Retarget Allegra site visitors 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1430205505,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.310000+00:00", "creative_id": "Unknown", "fivetran_id": "REg+axit5Tlmh5fFGRF5x3lxZeI=", "line_item_id": "20958541367", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1409760376,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.449000+00:00", "creative_id": "Unknown", "fivetran_id": "gh0knH16JTGyzWcg+JbUnWiIojk=", "line_item_id": "20958533891", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomAffinity: Qualified audience profile based on relevant keywords, URLs and app alignment 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1409760374,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.404000+00:00", "creative_id": "Unknown", "fivetran_id": "TqVKEvmeiAOabWuipm2cOa/gPCY=", "line_item_id": "20958533891", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomAffinity: Qualified audience profile based on relevant keywords, URLs and app alignment 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1409760372,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.309000+00:00", "creative_id": "Unknown", "fivetran_id": "bStuX6lKfqF7hdbgrWVbq498FTA=", "line_item_id": "21067593806", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomAffinity: Qualified audience profile based on relevant keywords, URLs and app alignment 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1430205509,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.303000+00:00", "creative_id": "Unknown", "fivetran_id": "lvtAk8h2F0SFS18l5Bm+aascGiY=", "line_item_id": "21060804903", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Outdoor Enthusiasts 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1430205647,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.357000+00:00", "creative_id": "Unknown", "fivetran_id": "IVErbP+BY3S5SuRHK2CrvQxEsEg=", "line_item_id": "21067593806", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomAffinity: Qualified audience profile based on relevant keywords, URLs and app alignment 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1430205539,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.311000+00:00", "creative_id": "Unknown", "fivetran_id": "M/fp5LuOebmciq7NRTI7jAMaDZs=", "line_item_id": "21070798444", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1430205475,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.402000+00:00", "creative_id": "Unknown", "fivetran_id": "ieAFayC0C7sOmTRhTLjgz/AdvWw=", "line_item_id": "20961579538", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Outdoor Enthusiasts 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1409760343,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.410000+00:00", "creative_id": "Unknown", "fivetran_id": "OxGD+pz1crfXkxvy82ISYdnFPAI=", "line_item_id": "20958541367", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1409760336,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.304000+00:00", "creative_id": "Unknown", "fivetran_id": "FlaoIRZxLZrB6a6qN2HS8Op3/Yk=", "line_item_id": "20958533891", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomAffinity: Qualified audience profile based on relevant keywords, URLs and app alignment 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1409760386,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.452000+00:00", "creative_id": "Unknown", "fivetran_id": "vXWms/5PUnn7LXoTE1rTG4qt8GU=", "line_item_id": "20958541367", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Outdoor Items, Pet Supplies 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1409760360,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.399000+00:00", "creative_id": "Unknown", "fivetran_id": "CGPX4Lixlo5yM4NaLOAPlJB/aXI=", "line_item_id": "21067595645", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_RTG_ALL_LAL/RTG: Build Look-A-Likes off Allegra Site Visitors/Retarget Allegra site visitors 6s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1430205403,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.356000+00:00", "creative_id": "Unknown", "fivetran_id": "vmo4mqn64lXTeLI3zxZV2cJ8QbY=", "line_item_id": "20958533891", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomAffinity: Qualified audience profile based on relevant keywords, URLs and app alignment 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1409760370,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.314000+00:00", "creative_id": "Unknown", "fivetran_id": "cRKte/uUs2/ceZXELOwHVDwNYjc=", "line_item_id": "20952159264", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_RTG_ALL_LAL/RTG: Build Look-A-Likes off Allegra Site Visitors/Retarget Allegra site visitors 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1409760341,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.300000+00:00", "creative_id": "Unknown", "fivetran_id": "ghhOwQqW3zlW/8v+IKKtT5pHKOo=", "line_item_id": "21507563691", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creative", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1737501892,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:23.301000+00:00", "creative_id": "Unknown", "fivetran_id": "ikQKgaQVb9MiVlB25gd/98b5RKg=", "line_item_id": "20961579538", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Outdoor Enthusiasts 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1409760330,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Allegra", "insertion_order": "Sanofi CHC_Allegra Awareness YouTube Auction_2024", "campaign_id": "54039428", "campaign": "Allegra_2024", "advertiser_id": "4910331", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.037000+00:00", "creative_id": "Unknown", "fivetran_id": "L7P8pAUvaCPqpHb1GMsmdHHXhAw=", "line_item_id": "21507563691", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creative", "appurl": "youtube.com", "insertion_order_id": "1015200009", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1737501876,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube Efficient Reach 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.155000+00:00", "creative_id": "Unknown", "fivetran_id": "F0XT9vakgjEnxXAD7MT9Jm+/ank=", "line_item_id": "21375341971", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV - All creative", "appurl": "youtube.com", "insertion_order_id": "1017066434", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1501313992,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.842000+00:00", "creative_id": "Unknown", "fivetran_id": "DmSlS/GKW6XbWUTLGUjx2dzAb2U=", "line_item_id": "21771946268", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV - All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1015473412", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1867190099,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Cortizone", "insertion_order": "Sanofi CHC_Cortizone Awareness YouTube DV360_2024", "campaign_id": "54740879", "campaign": "Cortizone_2024", "advertiser_id": "5166146", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.583000+00:00", "creative_id": "Unknown", "fivetran_id": "eL22y+T/14f/Be24mafevz2m91w=", "line_item_id": "21603347022", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives", "appurl": "youtube.com", "insertion_order_id": "1018196962", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1796195903,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.834000+00:00", "creative_id": "Unknown", "fivetran_id": "AofpS9NvV5DNRIP9dlm/TqVy0E4=", "line_item_id": "21765799326", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1867189961,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.154000+00:00", "creative_id": "Unknown", "fivetran_id": "+fAP++WQJE5c0efeWO5CqgWZqj4=", "line_item_id": "21140059886", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Sports & Fitness 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1480002401,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.152000+00:00", "creative_id": "Unknown", "fivetran_id": "K9wSN6CJrl/zp/LMiUHxfC83Y4E=", "line_item_id": "21133276689", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Sports & Fitness 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1480002411,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.840000+00:00", "creative_id": "Unknown", "fivetran_id": "FMg3mCYBHbEaEmA8Y2dOCC1JoHs=", "line_item_id": "21776089375", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1867189958,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.846000+00:00", "creative_id": "Unknown", "fivetran_id": "Pv4QCWo4PZ1pTDjB0aP4wXT+bPs=", "line_item_id": "21771946268", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV - All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1015473412", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1867190094,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.835000+00:00", "creative_id": "Unknown", "fivetran_id": "ZW135rql5IMvh7HDl8/3n2twJSA=", "line_item_id": "21771946268", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV - All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1015473412", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1867190093,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.157000+00:00", "creative_id": "Unknown", "fivetran_id": "9nhaHwao4rUj3tR9E1GmkQOZpls=", "line_item_id": "21133277217", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomIntent: Relevant Keywords URLs and App Alignment 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1480002498,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.844000+00:00", "creative_id": "Unknown", "fivetran_id": "8h2HIvJTv1hDLvnI4Nd7dt062O4=", "line_item_id": "21765799326", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1867189957,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.830000+00:00", "creative_id": "Unknown", "fivetran_id": "gJiYcLD7GBuaBERLk/aXrHShLOY=", "line_item_id": "21776089375", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1867189964,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.843000+00:00", "creative_id": "Unknown", "fivetran_id": "lp7EEalOFGXXsEweax3Wnr1Q7KA=", "line_item_id": "21776089375", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1867189963,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube Efficient Reach 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.151000+00:00", "creative_id": "Unknown", "fivetran_id": "FUk/edGvqXJDkjVCG1FWjl2mhQY=", "line_item_id": "21375341971", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV - All creative", "appurl": "youtube.com", "insertion_order_id": "1017066434", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1501314066,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.161000+00:00", "creative_id": "Unknown", "fivetran_id": "brBi+jrwgMM2Cz60MuY8ZsfYTaE=", "line_item_id": "21133276689", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Sports & Fitness 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1480002395,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.162000+00:00", "creative_id": "Unknown", "fivetran_id": "faiyrntNJM5RER/gg/wVx7M8Q+k=", "line_item_id": "21133277217", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomIntent: Relevant Keywords URLs and App Alignment 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1480002458,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.156000+00:00", "creative_id": "Unknown", "fivetran_id": "MwqGkc5+VCEVYwTqbKzeyToRilo=", "line_item_id": "21133276689", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Sports & Fitness 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1480002431,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.841000+00:00", "creative_id": "Unknown", "fivetran_id": "9nEGjRfe09+h/0+mf/CL3HvWbj4=", "line_item_id": "21765799326", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1867189959,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.149000+00:00", "creative_id": "Unknown", "fivetran_id": "thKki2OCeLjUjX5gTqFyLWP9TkA=", "line_item_id": "21133277217", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomIntent: Relevant Keywords URLs and App Alignment 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1480002474,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Cortizone", "insertion_order": "Sanofi CHC_Cortizone Awareness YouTube DV360_2024", "campaign_id": "54740879", "campaign": "Cortizone_2024", "advertiser_id": "5166146", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.603000+00:00", "creative_id": "Unknown", "fivetran_id": "HV9qLVE/h/dfJrkr3H7caYIPD08=", "line_item_id": "21603347022", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives", "appurl": "youtube.com", "insertion_order_id": "1018196962", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1796195904,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.147000+00:00", "creative_id": "Unknown", "fivetran_id": "nJ1IYYZAThHWzVw8gS3VK5pD9r8=", "line_item_id": "21133276689", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_Affinity: Sports & Fitness 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1480002471,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.153000+00:00", "creative_id": "Unknown", "fivetran_id": "eyBS+5aglamifhQtg5p+CLT/Q8k=", "line_item_id": "21133277217", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_CustomIntent: Relevant Keywords URLs and App Alignment 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1480002468,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube Efficient Reach 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.164000+00:00", "creative_id": "Unknown", "fivetran_id": "P9ikVm6wtPM2I/apORoaHS6SOM8=", "line_item_id": "21375341971", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV - All creative", "appurl": "youtube.com", "insertion_order_id": "1017066434", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1501314063,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing A55+ YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.837000+00:00", "creative_id": "Unknown", "fivetran_id": "RlQE5gWdSxghPMA8NczGyGR6Pxs=", "line_item_id": "21765799326", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420646", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1867189962,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube Efficient Reach 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.160000+00:00", "creative_id": "Unknown", "fivetran_id": "qvXoeLM1wfkzCOSRpb9EjYiaAd8=", "line_item_id": "21375341971", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV - All creative", "appurl": "youtube.com", "insertion_order_id": "1017066434", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1501313994,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.838000+00:00", "creative_id": "Unknown", "fivetran_id": "M/8MHtglyVvDQTz8ndesB4Kj+HU=", "line_item_id": "21771946268", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV - All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1015473412", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1867190097,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Cortizone", "insertion_order": "Sanofi CHC_Cortizone Awareness YouTube DV360_2024", "campaign_id": "54740879", "campaign": "Cortizone_2024", "advertiser_id": "5166146", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.591000+00:00", "creative_id": "Unknown", "fivetran_id": "x80OlOCpwMEDuCLxhKD7LUsBJmQ=", "line_item_id": "21603347022", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives", "appurl": "youtube.com", "insertion_order_id": "1018196962", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1796195901,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Cortizone", "insertion_order": "Sanofi CHC_Cortizone Awareness YouTube DV360_2024", "campaign_id": "54740879", "campaign": "Cortizone_2024", "advertiser_id": "5166146", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.601000+00:00", "creative_id": "Unknown", "fivetran_id": "IDfCv/L4kN7/d3tt/XhbbW8rYVI=", "line_item_id": "21603347022", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives", "appurl": "youtube.com", "insertion_order_id": "1018196962", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1796195902,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Gold Bond", "insertion_order": "Sanofi CHC_Gold Bond Consideration Healing 35-54 YouTube DV360_2024", "campaign_id": "54034685", "campaign": "Gold Bond_2024", "advertiser_id": "5166141", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:24.836000+00:00", "creative_id": "Unknown", "fivetran_id": "E0cyAsHM4nTJNidxrvZTdRoFUms=", "line_item_id": "21776089375", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "All Creatives_Efficient Reach 2.0 Line", "appurl": "youtube.com", "insertion_order_id": "1018420410", "creative": "Unknown", "device_type": "Desktop"}',1,627210,1867189960,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.150000+00:00", "creative_id": "Unknown", "fivetran_id": "ekinm8DSq87z5bZVInszd9ki3eQ=", "line_item_id": "21140059886", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Sports & Fitness 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Connected TV"}',1,627210,1480002407,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.158000+00:00", "creative_id": "Unknown", "fivetran_id": "BQOkT2SnfLnFsCZ/rCvNA52XnyY=", "line_item_id": "21140059886", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Sports & Fitness 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Smart Phone"}',1,627210,1480002437,'NOW()','NOW()'), (1054,0,'{"appurl_id": "101266649351", "creative_type": "Standard", "advertiser": "HMNYC_Sanofi CHC Icy Hot", "insertion_order": "Sanofi CHC_IcyHot Awareness YouTube 2024", "campaign_id": "54328319", "campaign": "Icy Hot_2024", "advertiser_id": "5166147", "publisher_property": "Unknown", "fivetran_synced": "2024-10-23 11:37:26.163000+00:00", "creative_id": "Unknown", "fivetran_id": "HmGQLMdkm9tiWraQPyGZxUwa7eA=", "line_item_id": "21140059886", "partner_currency": "USD", "partner": "Havas Media USA", "line_item": "TRV_AUD_ALL_InMarket: Sports & Fitness 15s_CPM", "appurl": "youtube.com", "insertion_order_id": "1016625613", "creative": "Unknown", "device_type": "Tablet"}',1,627210,1480002427,'NOW()','NOW()') ON CONFLICT ("platform_id","portfolio_id","new_unique_field_key_id") DO UPDATE SET "custom_platform_template_upload_id"=EXCLUDED."custom_platform_template_upload_id","data"=EXCLUDED."data","updated"=EXCLUDED."updated" RETURNING (xmax = 0) AS util_was_inserted, id,new_unique_field_key_idDate: 2024-10-23 17:36:31 Database: sanofi_de84s4qcbsdrds Application: User: u3m4c4715a71na Remote: 10.24.177.34
7 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 23 06 1 - LOG: process 9270 still waiting for ShareUpdateExclusiveLock on relation 517081 of database 16402 after 1000.047 ms
Detail: Process holding the lock: 9360. Wait queue: 9270.
Statement: analyzeDate: 2024-10-23 06:01:57