Outliers
Queries that have longest execution time in aggregate
Showing 10 entries
Query Exec time
 		Prop exec time Calls Sync io time
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) 23.183831 seconds 5.0 515 0 seconds
select register_city( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 ) 19.361375 seconds 4.2 610 0 seconds
INSERT INTO "openweather_maps" ("city_id","clouds_all_pt","description","feels_like_c","ground_level_mb","humidity_pct","icon","ow_temperature_c","pressure_mb","sea_level_mb","temp_max_c","temp_min_c","timestamp","visibility_m","weather_tag","wind_direction_deg","wind_gust_ms","wind_speed_ms") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18) 17.379939 seconds 3.8 406 0 seconds
SELECT conrelid, confrelid FROM pg_constraint JOIN pg_depend ON (objid = confrelid) WHERE contype = $1 AND refclassid = $2::regclass AND classid = $3::regclass 16.885045 seconds 3.7 2 0 seconds
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 14.924271 seconds 3.2 2 0 seconds
COPY public.power_monitorings ("timestamp", voltage_v, current_a, power_w, energy_kwh, frequency_hz, power_factor) TO stdout 13.523459 seconds 2.9 2 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 12.809729 seconds 2.8 2 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 12.063407 seconds 2.6 2 0 seconds
LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE 11.025550 seconds 2.4 4813 0 seconds
SELECT t.tableoid, t.oid, t.typname, t.typnamespace, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(t.typacl,pg_catalog.acldefault($1,t.typowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,t.typowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS typacl, (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($4,t.typowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(t.typacl,pg_catalog.acldefault($6,t.typowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) AS rtypacl, $7 AS inittypacl, $8 AS initrtypacl, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = t.typowner) AS rolname, t.typelem, t.typrelid, CASE WHEN t.typrelid = $9 THEN $10::"char" ELSE (SELECT relkind FROM pg_class WHERE oid = t.typrelid) END AS typrelkind, t.typtype, t.typisdefined, t.typname[$11] = $12 AND t.typelem != $13 AND (SELECT typarray FROM pg_type te WHERE oid = t.typelem) = t.oid AS isarray FROM pg_type t LEFT JOIN pg_init_privs pip ON (t.oid = pip.objoid AND pip.classoid = $14::regclass AND pip.objsubid = $15) 10.605382 seconds 2.3 2 0 seconds