Outliers
Queries that have longest execution time in aggregate
Queries that have longest execution time in aggregate
| Query | Exec time | Prop exec time | Calls | Sync io time |
|---|---|---|---|---|
| COPY public.particle_concentrations ("timestamp", mass_1p0_ugm3, mass_2p5_ugm3, mass_4p0_ugm3, mass_10p0_ugm3, num_0p5_ncm3, num_1p0_ncm3, num_2p5_ncm3, num_4p0_ncm3, num_10p0_ncm3, size_um) TO stdout | 41.206131 seconds | 9.6 | 6 | 0 seconds |
| COPY public.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout | 40.616642 seconds | 9.5 | 6 | 0 seconds |
| COPY public.solar_observations ("timestamp", temperature_c, humidity_pct, charge_pct, lighting_lm, battery_voltage_mv, photo_light_mv, sensor_id) TO stdout | 38.582247 seconds | 9.0 | 6 | 0 seconds |
| CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" bigint, "inserted_at" timestamp(0), PRIMARY KEY ("version")) | 28.224861 seconds | 6.6 | 43939 | 0 seconds |
| LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 24.663854 seconds | 5.8 | 43939 | 0 seconds |
| COPY (SELECT "timestamp", "aqi_idx", "co_ugm3", "no_ugm3", "no2_ugm3", "o3_ugm3", "so2_ugm3", "pm2_5_ugm3", "pm10_ugm3", "nh3_ugm3", "city_id" FROM "public"."air_pollutions" ) TO STDOUT (FORMAT "binary") | 14.308666 seconds | 3.4 | 2 | 0 seconds |
| COPY public.who_covid (date_reported, country_code, country, who_region, new_cases, cumulative_cases, new_deaths, cumulative_deaths) TO stdout | 7.769323 seconds | 1.8 | 6 | 0 seconds |
| select installed_version from pg_available_extensions where name=$1 | 5.549822 seconds | 1.3 | 2608 | 0 seconds |
| SELECT c.tableoid, c.oid, c.relname, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(c.relacl,pg_catalog.acldefault(CASE WHEN c.relkind = $1 THEN $2 ELSE $3 END::"char",c.relowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $4 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault(CASE WHEN c.relkind = $5 THEN $6 ELSE $7 END::"char",c.relowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS relacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault(CASE WHEN c.relkind = $8 THEN $9 ELSE $10 END::"char",c.relowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $11 FROM pg_catalog.unnest(coalesce(c.relacl,pg_catalog.acldefault(CASE WHEN c.relkind = $12 THEN $13 ELSE $14 END::"char",c.relowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) as rrelacl, $15 AS initrelacl, $16 as initrrelacl, c.relkind, c.relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = c.relowner) AS rolname, c.relchecks, c.relhastriggers, c.relhasindex, c.relhasrules, c.relhasoids, c.relrowsecurity, c.relforcerowsecurity, c.relfrozenxid, c.relminmxid, tc.oid AS toid, tc.relfrozenxid AS tfrozenxid, tc.relminmxid AS tminmxid, c.relpersistence, c.relispopulated, c.relreplident, c.relpages, c.reloftype, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, (SELECT spcname FROM pg_tablespace t WHERE t.oid = c.reltablespace) AS reltablespace, array_remove(array_remove(c.reloptions,$17),$18) AS reloptions, CASE WHEN $19 = ANY (c.reloptions) THEN $20::text WHEN $21 = ANY (c.reloptions) THEN $22::text ELSE $23 END AS checkoption, tc.reloptions AS toast_reloptions, c.relkind = $24 AND EXISTS (SELECT $25 FROM pg_depend WHERE classid = $26::regclass AND objid = c.oid AND objsubid = $27 AND refclassid = $28::regclass AND deptype = $29) AS is_identity_sequence, EXISTS (SELECT $30 FROM pg_attribute at LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = $31::regclass AND pip.objsubid = at.attnum)WHERE at.attrelid = c.oid AND ((SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(at.attacl,pg_catalog.acldefault($32,c.relowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $33 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($34,c.relowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) IS NOT NULL OR (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($35,c.relowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $36 FROM pg_catalog.unnest(coalesce(at.attacl,pg_catalog.acldefault($37,c.relowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) IS NOT NULL OR $38 IS NOT NULL OR $39 IS NOT NULL))AS changed_acl, c.relispartition AS ispartition FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = $40 AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = $41 AND d.refclassid = c.tableoid AND d.deptype IN ($42, $43)) LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid) LEFT JOIN pg_init_privs pip ON (c.oid = pip.objoid AND pip.classoid = $44::regclass AND pip.objsubid = $45) WHERE c.relkind in ($46, $47, $48, $49, $50, $51, $52) ORDER BY c.oid | 5.318384 seconds | 1.2 | 6 | 0 seconds |
| INSERT INTO "air_pollutions" ("aqi_idx","city_id","co_ugm3","nh3_ugm3","no2_ugm3","no_ugm3","o3_ugm3","pm10_ugm3","pm2_5_ugm3","so2_ugm3","timestamp") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) | 4.092431 seconds | 1.0 | 1299 | 0 seconds |