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 | 569.564282 seconds | 11.3 | 55 | 0 seconds |
| COPY public.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout | 436.467422 seconds | 8.6 | 55 | 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 | 378.000059 seconds | 7.5 | 55 | 0 seconds |
| SELECT "timestamp" AS "time", temperature_c as sol_temperature_c FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 AND sensor_id = $3 ORDER BY 1 | 371.257945 seconds | 7.3 | 413 | 0 seconds |
| SELECT "timestamp" AS "time", lighting_lm as sol_lightning_lm FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 AND sensor_id = $3 ORDER BY 1 | 363.209757 seconds | 7.2 | 414 | 0 seconds |
| SELECT "timestamp" AS "time", humidity_pct as balcony FROM solar_observations WHERE "timestamp" BETWEEN $1 AND $2 ORDER BY 1 | 327.266888 seconds | 6.5 | 415 | 0 seconds |
| SELECT "timestamp" AS "time", AVG( charge_pct ) OVER( ORDER BY timestamp ROWS BETWEEN $1 PRECEDING AND CURRENT ROW ) as avg_charge_pct FROM solar_observations WHERE "timestamp" BETWEEN $2 AND $3 ORDER BY 1 | 244.147104 seconds | 4.8 | 417 | 0 seconds |
| LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 108.997764 seconds | 2.2 | 62058 | 0 seconds |
| COPY public.who_covid (date_reported, country_code, country, who_region, new_cases, cumulative_cases, new_deaths, cumulative_deaths) TO stdout | 85.189506 seconds | 1.7 | 55 | 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 | 74.675623 seconds | 1.5 | 55 | 0 seconds |