Calls
Queries that have the highest frequency of execution
Queries that have the highest frequency of execution
| Query | Exec time | Prop exec time | Calls | Sync io time |
|---|---|---|---|---|
| SELECT a.attnum, a.attname, a.atttypmod, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid,a.atttypmod) AS atttypname, array_to_string(a.attoptions, $1) AS attoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE $2 END AS attcollation, a.attidentity, pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(option_name) || $3 || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), $4) AS attfdwoptions ,CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE $5 END AS attmissingval FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = $6::pg_catalog.oid AND a.attnum > $7::pg_catalog.int2 ORDER BY a.attnum | 8.504960 seconds | 25368 | 0 seconds | |
| INSERT INTO "weather_conditions" ("altitude_m","bmp_temperature_c","dht_temperature_c","humidity_pct","lighting_lm","luminance_tag","photo_light_mv","pressure_hg","raspi_temp_c","real_altitude_m","scd_co2_ppm","scd_humidity_pct","scd_temperature_c","sealevel_pressure_hg","timestamp") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15) | 8.928823 seconds | 29838 | 0 seconds | |
| INSERT INTO "power_monitorings" ("current_a","energy_kwh","frequency_hz","power_factor","power_w","timestamp","voltage_v") VALUES ($1,$2,$3,$4,$5,$6,$7) | 2.545891 seconds | 29838 | 0 seconds | |
| INSERT INTO "particle_concentrations" ("mass_10p0_ugm3","mass_1p0_ugm3","mass_2p5_ugm3","mass_4p0_ugm3","num_0p5_ncm3","num_10p0_ncm3","num_1p0_ncm3","num_2p5_ncm3","num_4p0_ncm3","size_um","timestamp") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) | 2.537627 seconds | 29839 | 0 seconds | |
| INSERT INTO "solar_observations" ("battery_voltage_mv","charge_pct","humidity_pct","lighting_lm","photo_light_mv","sensor_id","temperature_c","timestamp") VALUES ($1,$2,$3,$4,$5,$6,$7,$8) | 6.622915 seconds | 29841 | 0 seconds | |
| SELECT s0."version"::bigint FROM "schema_migrations" AS s0 | 8.809975 seconds | 169468 | 0 seconds | |
| COMMIT | 0.565082 seconds | 169468 | 0 seconds | |
| LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 86.672153 seconds | 169468 | 0 seconds | |
| CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" bigint, "inserted_at" timestamp(0), PRIMARY KEY ("version")) | 34.640122 seconds | 169468 | 0 seconds | |
| BEGIN | 0.790597 seconds | 169489 | 0 seconds |