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 |
---|---|---|---|---|
BEGIN | 5.733902 seconds | 1222576 | 0 seconds | |
CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" bigint, "inserted_at" timestamp(0), PRIMARY KEY ("version")) | 253.215571 seconds | 1222427 | 0 seconds | |
COMMIT | 3.940975 seconds | 1222426 | 0 seconds | |
SELECT s0."version"::bigint FROM "schema_migrations" AS s0 | 64.232924 seconds | 1222426 | 0 seconds | |
LOCK TABLE "schema_migrations" IN SHARE UPDATE EXCLUSIVE MODE | 513.532594 seconds | 1222426 | 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) | 48.632326 seconds | 215729 | 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) | 18.004341 seconds | 215725 | 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) | 18.441522 seconds | 215724 | 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) | 66.895381 seconds | 215724 | 0 seconds | |
SELECT option_value FROM wp_options WHERE option_name = $1 LIMIT $2 | 9.277875 seconds | 168429 | 0 seconds |