pg_stat_statements

userid
oid
dbid
oid
toplevel
boolean
queryid
bigint
query
text
plans
bigint
total_plan_time
double precision
min_plan_time
double precision
max_plan_time
double precision
mean_plan_time
double precision
stddev_plan_time
double precision
calls
bigint
total_exec_time
double precision
min_exec_time
double precision
max_exec_time
double precision
mean_exec_time
double precision
stddev_exec_time
double precision
rows
bigint
shared_blks_hit
bigint
shared_blks_read
bigint
shared_blks_dirtied
bigint
shared_blks_written
bigint
local_blks_hit
bigint
local_blks_read
bigint
local_blks_dirtied
bigint
local_blks_written
bigint
temp_blks_read
bigint
temp_blks_written
bigint
blk_read_time
double precision
blk_write_time
double precision
wal_records
bigint
wal_fpi
bigint
wal_bytes
numeric
16385 16384 t -3972159607883622282 LOCK TABLE public."tbl001EC6056FD2_65" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.7836879999999999 0.017322 0.291404 0.07124436363636363 0.07815388709610935 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8779499470353472234 INSERT INTO "tbl001EC6050E4D_80" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 5225 424.63965699999994 0.017872000000000002 2.567387 0.0812707477511961 0.18431489767164919 5225 32733 356 6803 46 0 0 0 0 0 0 0 0 15690 6714 25508817
16385 16384 t -2409553782227031537 INSERT INTO "tbl001EC6050D06_4" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 1773 177.82923199999993 0.022012 3.1874 0.10029849520586585 0.21630222248207315 1773 10839 132 3051 133 0 0 0 0 0 0 0 0 5324 3357 15279570
16385 16384 t 3205803266318285475 COPY public."tbl001EC6050F3C_19" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 2 0.596173 0.105828 0.490345 0.29808650000000003 0.19225849999999997 110 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -805669198367088565 SELECT * FROM "tblacquisuite" ORDER BY "lastuploadtime" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 12 3.317831 0.192327 0.38427 0.27648591666666666 0.05505133516464175 426 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2879828730089134789 SELECT * FROM "tbl001EC6050D21_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 10296 330.29607899999985 0.018675999999999998 2.633593 0.03208003875291399 0.05137777808197422 10296 30869 19 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7498025405702148718 LOCK TABLE public."tbl001EC6050B87_6" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.27970500000000004 0.017944 0.049598 0.027970500000000002 0.009693885209244022 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 224041672947850748 DROP TABLE IF EXISTS _ec02dd316d6eafc4e914a5fe9907570e 0 0 0 0 0 0 1 0.903632 0.903632 0.903632 0.903632 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3074221198704879904 CREATE TABLE IF NOT EXISTS "tbl001EC6050F42_51" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "umtLastMeasTime_1" DOUBLE PRECISION DEFAULT NULL, "2" DOUBLE PRECISION DEFAULT NULL, "umtWindSpeed_MPH_3" DOUBLE PRECISION DEFAULT NULL, "4" DOUBLE PRECISION DEFAULT NULL, "umtRawWindDir_Degrees_5" DOUBLE PRECISION DEFAULT NULL, "6" DOUBLE PRECISION DEFAULT NULL, "umtAdjWindDir_Degrees_7" DOUBLE PRECISION DEFAULT NULL, "8" DOUBLE PRECISION DEFAULT NULL, "umtRelHumidity_9" DOUBLE PRECISION DEFAULT NULL, "10" DOUBLE PRECISION DEFAULT NULL, "umtRawBaromPress_Inches_Hg_11" DOUBLE PRECISION DEFAULT NULL, "12" DOUBLE PRECISION DEFAULT NULL, "umtAdjBaromPress_Inches_Hg_13" DOUBLE PRECISION DEFAULT NULL, "14" DOUBLE PRECISION DEFAULT NULL, "umtTrueNorthOffset_Degrees_15" DOUBLE PRECISION DEFAULT NULL, "16" DOUBLE PRECISION DEFAULT NULL, "umtLastRain_Date_and_Time_17" DOUBLE PRECISION DEFAULT NULL, "18" DOUBLE PRECISION DEFAULT NULL, "umtTemp1_Degrees_F_19" DOUBLE PRECISION DEFAULT NULL, "20" DOUBLE PRECISION DEFAULT NULL, "umtWindChill_Degrees_F_21" DOUBLE PRECISION DEFAULT NULL, "22" DOUBLE PRECISION DEFAULT NULL, "umtHeatIndex_Degrees_F_23" DOUBLE PRECISION DEFAULT NULL, "24" DOUBLE PRECISION DEFAULT NULL, "umtDewPoint_Degrees_F_25" DOUBLE PRECISION DEFAULT NULL, "26" DOUBLE PRECISION DEFAULT NULL, "umtDensityAltitude_Feet_27" DOUBLE PRECISION DEFAULT NULL, "28" DOUBLE PRECISION DEFAULT NULL, "umtRainToday_Inches_29" DOUBLE PRECISION DEFAULT NULL, "umtTemp2_Degrees_F_30" DOUBLE PRECISION DEFAULT NULL, "umtTemp3_Degrees_F_31" DOUBLE PRECISION DEFAULT NULL, "umtTemp4_Degrees_F_32" DOUBLE PRECISION DEFAULT NULL, "umtSolarRadiation_W_m_2_33" DOUBLE PRECISION DEFAULT NULL, "umtSolarRadiation_2_W_m_2_34" DOUBLE PRECISION DEFAULT NULL, "35" DOUBLE PRECISION DEFAULT NULL, "36" DOUBLE PRECISION DEFAULT NULL, "37" DOUBLE PRECISION DEFAULT NULL, "38" DOUBLE PRECISION DEFAULT NULL, "39" DOUBLE PRECISION DEFAULT NULL, "40" DOUBLE PRECISION DEFAULT NULL, "41" DOUBLE PRECISION DEFAULT NULL, "42" DOUBLE PRECISION DEFAULT NULL, "43" DOUBLE PRECISION DEFAULT NULL, "44" DOUBLE PRECISION DEFAULT NULL, "45" DOUBLE PRECISION DEFAULT NULL, "46" DOUBLE PRECISION DEFAULT NULL, "47" DOUBLE PRECISION DEFAULT NULL, "48" DOUBLE PRECISION DEFAULT NULL, "49" DOUBLE PRECISION DEFAULT NULL, "50" DOUBLE PRECISION DEFAULT NULL, "51" DOUBLE PRECISION DEFAULT NULL, "52" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 7.332675 7.332675 7.332675 7.332675 0 0 916 4 8 0 0 0 0 0 0 0 0 0 224 7 63314
16385 16384 t -1866995739112601523 CREATE TABLE IF NOT EXISTS "tbl001EC6053109_7" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "AC_Current_Amps_1" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_Amps_2" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_Amps_3" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_Amps_4" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_AB_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_BC_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_CA_Volts_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_AN_Volts_8" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_BN_Volts_9" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_CN_Volts_10" DOUBLE PRECISION DEFAULT NULL, "AC_Power_W_11" DOUBLE PRECISION DEFAULT NULL, "Line_Frequency_Hz_12" DOUBLE PRECISION DEFAULT NULL, "AC_Apparent_Power_VA_13" DOUBLE PRECISION DEFAULT NULL, "AC_Reactive_Power_VAR_14" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Factor_15" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_Wh_16" DOUBLE PRECISION DEFAULT NULL, "DC_Amps_Amps_17" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_Volts_18" DOUBLE PRECISION DEFAULT NULL, "DC_Power_W_19" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_Degrees_20" DOUBLE PRECISION DEFAULT NULL, "Heat_Sink_Temperature_Degrees_21" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_Degrees_22" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_Degrees_23" DOUBLE PRECISION DEFAULT NULL, "Operating_State_24" DOUBLE PRECISION DEFAULT NULL, "Vendor_Specific_Operating_State_25" DOUBLE PRECISION DEFAULT NULL, "Event_Field_26" DOUBLE PRECISION DEFAULT NULL, "Reserved_for_Future_27" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_1_28" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_2_29" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_3_30" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_4_31" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.631215 5.631215 5.631215 5.631215 0 0 652 1 35 0 0 0 0 0 0 0 0 0 163 36 179219
16385 16384 t 7680357449525040232 LOCK TABLE public."tbl001EC6053019_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 4 0.100215 0.016477 0.040717 0.02505375 0.009642164263665085 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6842585822798828792 LOCK TABLE public."tbl001EC6053075_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 4 0.142673 0.024227 0.050876 0.03566825 0.009837169749856916 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7177536492008192512 INSERT INTO "tbl001EC6050F42_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 117 7.757702000000002 0.027954 0.769594 0.0663051452991453 0.09837269129395 117 527 3 232 6 0 0 0 0 0 0 0 0 352 224 636693
16385 16384 t 9198444178929097806 SELECT * FROM "tbl001EC6050D05_80" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30504 903.0210629999938 0.015861 5.572764 0.02960336555861533 0.05782641586425547 30504 122008 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7939822947589408030 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_5" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 6.994644 6.994644 6.994644 6.994644 0 0 1171 2 7 0 0 0 0 0 0 0 0 0 285 6 70207
16385 16384 t -692390808886531713 SELECT * FROM "tbl001EC6050E0D_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2152 104.2283430000001 0.019428 6.391662 0.04843324488847579 0.23680594105224712 2152 6372 27 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -7346657154005939457 CREATE TABLE _e6160c1ab31d04831190b14f09d6fcda(cmd_output text) 0 0 0 0 0 0 1 12.097351 12.097351 12.097351 12.097351 0 0 503 7 27 0 0 0 0 0 0 0 0 0 95 26 127258
16385 16384 t -443583880054380504 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_18" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 8.240913 8.240913 8.240913 8.240913 0 0 1204 3 10 1 0 0 0 0 0 0 0 0 285 8 75517
16385 16384 t 6404249146546237473 SELECT last_value, is_called FROM _timescaledb_config.bgw_job_id_seq 0 0 0 0 0 0 11 6.432051 0.016935 1.222621 0.5847319090909091 0.31842053361451955 11 2 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2193398769792487133 LOCK TABLE public."tbl001EC6050189_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.237668 0.018169 0.030866 0.023766799999999998 0.003656005492337231 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7504907003585325725 INSERT INTO "tbl001EC6056300_50" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15675 670.9472139999972 0.014812 1.8327280000000001 0.04280365001594897 0.04742886383988488 15675 98000 26 8126 667 0 0 0 0 0 0 0 0 47068 7468 32650141
16385 16384 t -4345154154443553969 INSERT INTO "tbl001EC6056FD2_62" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15673 651.3794819999994 0.014858000000000001 3.5067660000000003 0.04156061264595175 0.06275113898311839 15673 96911 42 8828 350 0 0 0 0 0 0 0 0 47061 8127 38824518
16385 16384 t -2379713382969652126 INSERT INTO "tbl001EC60506E1_1" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130,$131,$132,$133,$134) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15673 943.1132520000026 0.021943 56.189534 0.06017439239456429 0.46042897261482824 15673 100676 24 5303 2341 0 0 0 0 0 0 0 0 47062 1915 27137146
16385 16384 t 5230554497823645322 COPY public."tbl001EC6050B87_6" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 10 400.006897 1.735024 78.630209 40.000689699999995 24.975912271798848 34020 1027 2040 3 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7740658506590686095 INSERT INTO "tbl001EC6054E88_56" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 18182 531.8883470000012 0.013937999999999999 4.562832 0.02925356654933445 0.06324360390695373 18182 108913 9 1725 173 0 0 0 0 0 0 0 0 54597 1732 10467568
16385 16384 t -8500379670150473766 INSERT INTO "tbl001EC605309C_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15644 1109.1958100000047 0.018816 11.562107000000001 0.07090231462541526 0.16563556813766192 15644 98389 409 10993 1480 0 0 0 0 0 0 0 0 46975 8204 46465464
16385 16384 t 4098178233266800232 COPY public."tbl001EC6050D15_9" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "SolZone_DC_Current_1_A_15", "Critical_Alarms_16", "SolZone_DC_Current_2_A_17", "SolZone_DC_Current_3_A_18", "SolZone_DC_Current_4_A_19", "SolZone_DC_Current_5_A_20", "SolZone_DC_Current_6_A_21", "SolZone_DC_Current_7_A_22", "SolZone_DC_Current_8_A_23", "SolZone_DC_Current_Total_A_24", "Inverter_AC_Output_Current_A_25") TO stdout 0 0 0 0 0 0 1 0.920087 0.920087 0.920087 0.920087 0 190 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6901787853276789928 COPY public."tbl001EC6053CD9_10" ("time", error, lowrange, highrange, "Horizontal_Irradiance_W_m_2_1", "POA_Irradiance_W_m_2_2", "Ambient_Temperature_Degrees_F_3", "Module_Temperature_Degrees_F_4", "Future_Use_4_5", "Future_Use_5_6", "Future_Use_6_7", "Future_Use_7_8", "Burnout_0_9", "Burnout_1_10", "Burnout_2_11", "Burnout_3_12", "Burnout_4_13", "Burnout_5_14", "Burnout_6_15", "Burnout_7_16") TO stdout 0 0 0 0 0 0 7 94.548274 0.329694 28.956554 13.506896285714285 10.672315270833126 11151 144 182 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3485054269872604905 LOCK TABLE public."tbl001EC6056D41_55" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 1.1325880000000002 0.019061 0.492489 0.10296254545454545 0.1600333407014492 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2129721732713152873 COPY public."tbl001EC6050E4D_52" ("time", error, lowrange, highrange, "umtLastMeasTime_1", "2", "umtWindSpeed_MPH_3", "4", "umtRawWindDir_Degrees_5", "6", "umtAdjWindDir_Degrees_7", "8", "umtRelHumidity_9", "10", "umtRawBaromPress_Inches_Hg_11", "12", "umtAdjBaromPress_Inches_Hg_13", "14", "umtTrueNorthOffset_Degrees_15", "16", "umtLastRain_Date_and_Time_17", "18", "umtTemp1_Degrees_F_19", "20", "umtWindChill_Degrees_F_21", "22", "umtHeatIndex_Degrees_F_23", "24", "umtDewPoint_Degrees_F_25", "26", "umtDensityAltitude_Feet_27", "28", "umtRainToday_Inches_29", "umtTemp2_Degrees_F_30", "umtTemp3_Degrees_F_31", "umtTemp4_Degrees_F_32", "umtSolarRadiation_W_m_2_33", "umtSolarRadiation_2_W_m_2_34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52") TO stdout 0 0 0 0 0 0 11 381.431807 21.205642 53.415754 34.675618818181825 11.055137887244443 90915 421 616 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8243439492552895198 SELECT tableoid, oid, rulename, ev_class AS ruletable, ev_type, is_instead, ev_enabled FROM pg_rewrite ORDER BY oid 0 0 0 0 0 0 11 26.371989 2.04643 3.2958839999999996 2.3974535454545456 0.34695524611720147 1727 209 44 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1821956540302618254 COPY public."tbl001EC6050D30_51" ("time", error, lowrange, highrange, "umtLastMeasTime_1", "2", "umtWindSpeed_MPH_3", "4", "umtRawWindDir_Degrees_5", "6", "umtAdjWindDir_Degrees_7", "8", "umtRelHumidity_9", "10", "umtRawBaromPress_Inches_Hg_11", "12", "umtAdjBaromPress_Inches_Hg_13", "14", "umtTrueNorthOffset_Degrees_15", "16", "umtLastRain_Date_and_Time_17", "18", "umtTemp1_Degrees_F_19", "20", "umtWindChill_Degrees_F_21", "22", "umtHeatIndex_Degrees_F_23", "24", "umtDewPoint_Degrees_F_25", "26", "umtDensityAltitude_Feet_27", "28", "umtRainToday_Inches_29", "umtTemp2_Degrees_F_30", "umtTemp3_Degrees_F_31", "umtTemp4_Degrees_F_32", "umtSolarRadiation_W_m_2_33", "umtSolarRadiation_2_W_m_2_34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52") TO stdout 0 0 0 0 0 0 11 574.844735 42.932347 62.417343 52.25861227272727 5.271332192626351 93665 979 2979 13 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2670075737474270675 INSERT INTO "tbl001EC6050189_33" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 883 65.15457299999997 0.025972000000000002 1.579792 0.07378773839184588 0.1226432966156154 883 4917 15 1764 14 0 0 0 0 0 0 0 0 2652 1748 7181183
16385 16384 t -5704582007588109238 SELECT * FROM "tbl001EC6050C0B_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 18 13.896707000000003 0.089346 3.9085250000000005 0.7720392777777778 1.163534477038715 863 293 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5875246255647876027 COPY public."tbl001EC6056FD2_59" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 11 1006.706906 63.217601 114.72836 91.51880963636364 18.465033196936865 257543 12 5166 21 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1650959084932336692 CREATE TABLE IF NOT EXISTS "tbl001EC6050D16_51" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 7.475105 7.475105 7.475105 7.475105 0 0 572 4 35 0 0 0 0 0 0 0 0 0 143 36 206861
16385 16384 t -902603269441723407 CREATE TABLE IF NOT EXISTS "tbl001EC6050F42_1" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "DC_Voltage_V_1" DOUBLE PRECISION DEFAULT NULL, "Apparent_AC_Power_VA_2" DOUBLE PRECISION DEFAULT NULL, "AC_Grid_Frequency_Hz_3" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Stage_Current_A_4" DOUBLE PRECISION DEFAULT NULL, "L1_to_L2_AC_Voltage_V_5" DOUBLE PRECISION DEFAULT NULL, "L2_to_L3_AC_Voltage_V_6" DOUBLE PRECISION DEFAULT NULL, "L1_to_L3_AC_Voltage_V_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Sequence_8" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_kWh_9" DOUBLE PRECISION DEFAULT NULL, "On_Grid_Hours_Hrs_10" DOUBLE PRECISION DEFAULT NULL, "Fan_On_Time_Hours_Hrs_11" DOUBLE PRECISION DEFAULT NULL, "AC_Contactors_Cycles_12" DOUBLE PRECISION DEFAULT NULL, "Network_ID_13" DOUBLE PRECISION DEFAULT NULL, "Informative_Alarms_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 50.752168 50.752168 50.752168 50.752168 0 0 751 71 42 0 0 0 0 0 0 0 0 0 148 40 190345
16385 13761 t -6020578707396921358 DROP TABLE IF EXISTS _38485d3f99d60a686d135cb5677ebeba 0 0 0 0 0 0 1 0.105249 0.105249 0.105249 0.105249 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2661174454272724884 INSERT INTO "tbl001EC6053109_1" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15675 947.5144189999988 0.016126 7.279105 0.06044749084529481 0.17436434836792422 15675 96854 551 10062 531 0 0 0 0 0 0 0 0 47068 8665 42144572
16385 16384 t -8854639822216356418 SELECT c.relnamespace as scid, nsp.nspname as nspname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace nsp ON nsp.oid = c.relnamespace WHERE c.oid = $1::oid 0 0 0 0 0 0 8 0.26472799999999996 0.021781000000000002 0.049233 0.033091 0.011416233124371629 8 36 0 0 0 0 0 0 0 0 0 0 0 4 0 228
16385 16384 t 374304697277224309 SELECT f.tableoid, f.oid, f.srvname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = f.srvowner) AS rolname, f.srvfdw, f.srvtype, f.srvversion, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(f.srvacl,pg_catalog.acldefault($1,f.srvowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,f.srvowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS srvacl, (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,f.srvowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(f.srvacl,pg_catalog.acldefault($6,f.srvowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) AS rsrvacl, $7 AS initsrvacl, $8 AS initrsrvacl, array_to_string(ARRAY(SELECT quote_ident(option_name) || $9 || quote_literal(option_value) FROM pg_options_to_table(f.srvoptions) ORDER BY option_name), $10) AS srvoptions FROM pg_foreign_server f LEFT JOIN pg_init_privs pip ON (f.oid = pip.objoid AND pip.classoid = $11::regclass AND pip.objsubid = $12) 0 0 0 0 0 0 11 0.127968 0.0098 0.014714 0.011633454545454546 0.001540185370404034 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8592087871455712818 SELECT * FROM "tbl001EC6056D48_55" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.341627 1.16753 1.174097 1.1708135 0.0032834999999999948 200 128 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6369991630809137103 LOCK TABLE public."tbl001EC6056FD2_61" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.388786 0.017589 0.141089 0.035344181818181816 0.03426223991992611 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1865855713615411068 COPY public."tbl001EC6050B42_4" ("time", error, lowrange, highrange, "Vln_a_Volts_1", "Vln_b_Volts_2", "Vln_c_Volts_3", "Vln_ave_Volts_4", "Vll_ab_Volts_5", "Vll_bc_Volts_6", "Vll_ca_Volts_7", "Vll_ave_Volts_8", "I_a_Amps_9", "I_b_Amps_10", "I_c_Amps_11", "I_ave_Amps_12", "V_unbal_13", "I_unbal_14", "Freq_Hz_15", "I4_Amps_16", "kW_a_kW_17", "kW_b_kW_18", "kW_c_kW_19", "kW_tot_kW_20", "kVAR_a_kVAR_21", "kVAR_b_kVAR_22", "kVAR_c_kVAR_23", "kVAR_tot_kVAR_24", "kVA_a_kVA_25", "kVA_b_kVA_26", "kVA_c_kVA_27", "kVA_tot_kVA_28", "PF_sign_a_29", "PF_sign_b_30", "PF_sign_c_31", "PF_sign_tot_32", "Vll_ave_mx_Volts_33", "I_ave_mx_Amps_34", "kW_tot_mx_kW_35", "kVAR_tot_mx_kVAR_36", "kVA_tot_mx_kVA_37", "Freq_mx_Hz_38", "Vll_ave_mn_Volts_39", "I_ave_mn_Amps_40", "Freq_mn_Hz_41", "kW_sd_del_rec_kW_42", "kVA_sd_del_rec_kVA_43", "kVAR_sd_del_rec_kVAR_44", "kW_sd_mx_d_r_kW_45", "kVA_sd_mx_d_r_kVA_46", "kVAR_sd_mx_d_r_kVAR_47", "Phase_Rev_48", "kWh_del_kWh_49", "kWh_rec_kWh_50", "kWh_del_rec_kWh_51", "kWh_del_rec_kWh_52", "kVARh_del_kVARh_53", "kVARh_rec_kVARh_54", "kVARh_del_rec_kVARh_55", "kVARh_del_rec_kVARh_56", "kVAh_del_rec_kVAh_57", "V1_THD_mx_58", "V2_THD_mx_59", "V3_THD_mx_60", "I1_THD_mx_61", "I2_THD_mx_62", "I3_THD_mx_63", unused_64) TO stdout 0 0 0 0 0 0 7 30.831448 0.697351 11.66465 4.404492571428571 3.4246929217358146 2086 144 26 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 104999734102717204 COPY public."tbl001EC6050D16_9" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 7 1353.881911 153.956128 242.176023 193.41170157142855 24.285567108005566 479889 1182 5849 169 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5869172995002009892 INSERT INTO "tbl001EC6056D49_9" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15675 820.1559249999982 0.018937 2.162493 0.05232254704944179 0.06233545282487384 15675 98878 35 10947 1486 0 0 0 0 0 0 0 0 47068 8364 47195637
16385 16384 t -1963747944984696396 SELECT * FROM "tbl001EC6050EFC_213" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1432 64.71496300000008 0.012483999999999999 4.329936 0.045192013268156465 0.2146548265792453 1432 4261 35 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -908740461011927054 COPY (SELECT id, schema_name, table_name, associated_schema_name, associated_table_prefix, num_dimensions, chunk_sizing_func_schema, chunk_sizing_func_name, chunk_target_size, compression_state, compressed_hypertable_id, status FROM _timescaledb_catalog.hypertable WHERE id >= 1) TO stdout 0 0 0 0 0 0 11 41.039049 3.340907 4.135793 3.7308226363636363 0.2783889583172413 11 557 44 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5645216393043454041 COPY public."tbl001EC6050B5D_4" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 10 6.803178000000001 0.040025 1.729279 0.6803178000000001 0.5013600060848092 4422 34 4 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6502611273971958597 LOCK TABLE public."tbl001EC6053CD9_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.20324399999999998 0.024647 0.035897 0.029034857142857144 0.003963588360801049 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9065568952631136956 LOCK TABLE public.tbldevicelist IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.406199 0.026402 0.051574 0.03692718181818182 0.009409104071137039 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -472844020380946084 SELECT rolname, unnest(setconfig) FROM pg_db_role_setting s, pg_roles r WHERE setrole = r.oid AND setdatabase = $1::oid 0 0 0 0 0 0 11 0.18764399999999998 0.010117 0.065529 0.01705854545454545 0.015647181578125918 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -7873898334286540022 CREATE TABLE _5001befeeb31fb8114be059bfe6a816a(cmd_output text) 0 0 0 0 0 0 1 62.865427 62.865427 62.865427 62.865427 0 0 426 85 27 0 0 0 0 0 0 0 0 0 93 27 119021
16385 16384 t 6206064897698728739 COPY public."tbl001EC6053075_52" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 4 6.578830999999999 0.189296 2.81227 1.64470775 0.9989764593198317 1872 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2997830545432485452 SELECT * FROM "tbl001EC6050B87_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 38 69.730776 0.345292 11.259805 1.8350204210526315 2.585243844649624 3549 8595 63 5 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7784801625823612588 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_16" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 7.38572 7.38572 7.38572 7.38572 0 0 1188 0 12 0 0 0 0 0 0 0 0 0 286 13 124110
16385 16384 t -9152206790129950179 INSERT INTO "tbl001EC6056300_15" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15675 684.179802999998 0.015799 12.598395 0.04364783432216913 0.1134039357056378 15675 97911 27 8230 627 0 0 0 0 0 0 0 0 47069 7353 31832190
16385 16384 t -821675762088708213 SELECT * FROM "tbl001EC6050BAC_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 20360 566.0841080000007 0.006142 48.83449 0.027803738113949105 0.38000034269169114 20359 60270 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5647855166793447404 COPY public."tbl001EC6056D49_52" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 11 2883.5043960000003 172.174677 369.441393 262.13676327272725 68.90254010964308 242330 17 22491 63 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5502575409029393979 COPY public."tbl001EC6056D47_9" ("time", error, lowrange, highrange, "Active_Power_Total_kW_1", "Reactive_Power_Total_kVAR_2", "Apparent_Power_Total_kVA_3", "Voltage_Average_Volts_4", "Voltage_L_L_Average_Volts_5", "Current_Average_Amps_6", "System_Power_Factor_7", "System_Frequency_Hz_8", "Voltage_Average_Angle_Degrees_9", "System_Quadrant_10", "Voltage_A_Volts_11", "Voltage_B_Volts_12", "Voltage_C_Volts_13", "Voltage_A_B_Volts_14", "Voltage_B_C_Volts_15", "Voltage_A_C_Volts_16", "Current_A_Amps_17", "Current_B_Amps_18", "Current_C_Amps_19", "Active_Power_A_kW_20", "Active_Power_B_kW_21", "Active_Power_C_kW_22", "Reactive_Power_A_kVAR_23", "Reactive_Power_B_kVAR_24", "Reactive_Power_C_kVAR_25", "Apparent_Power_A_kVA_26", "Apparent_Power_B_kVA_27", "Apparent_Power_C_kVA_28", "Power_Factor_A_29", "Power_Factor_B_30", "Power_Factor_C_31", "Voltage_Angle_AB_Degrees_32", "Voltage_Angle_BC_Degrees_33", "Voltage_Angle_CA_Degrees_34", "Quadrant_A_35", "Quadrant_B_36", "Quadrant_C_37", "Sliding_Window_Power_kW_38", "Net_Total_Energy_Revenue_kWh_39", "Total_Net_Apparent_Energy_Revenue_kVA_40", "Total_Import_Energy_Revenue_kWh_41", "Total_Export_Energy_Revenue_kWh_42", "Total_Import_Apparent_Energy_Revenue_kVA_43", "Total_Export_Apparent_Energy_Revenue_kVA_44", "Q1_Total_Reactive_Energy_Revenue_kVAR_45", "Q2_Total_Reactive_Energy_Revenue_kVAR_46", "Q3_Total_Reactive_Energy_Revenue_kVAR_47", "Q4_Total_Reactive_Energy_Revenue_kVAR_48", "Q1_Q2_Total_Inductive_Reactive_Energy_Revenue_kVAR_49", "Q3_Q4_Total_Capacitive_Reactive_Energy_Revenue_kVAR_50", "Net_Energy_Revenue_A_kWh_51", "Net_Energy_Revenue_B_kWh_52", "Net_Energy_Revenue_C_kWh_53", "Net_Apparent_Energy_Revenue_A_kVA_54", "Net_Apparent_Energy_Revenue_B_kVA_55", "Net_Apparent_Energy_Revenue_C_kVA_56", "Import_Energy_Revenue_A_kWh_57", "Import_Energy_Revenue_B_kWh_58", "Import_Energy_Revenue_C_kWh_59", "Export_Energy_Revenue_A_kWh_60", "Export_Energy_Revenue_B_kWh_61", "Export_Energy_Revenue_C_kWh_62", "Import_Apparent_Energy_Revenue_A_kVA_63", "Import_Apparent_Energy_Revenue_B_kVA_64", "Import_Apparent_Energy_Revenue_C_kVA_65", "Export_Apparent_Energy_Revenue_A_kVA_66", "Export_Apparent_Energy_Revenue_B_kVA_67", "Export_Apparent_Energy_Revenue_C_kVA_68", "Q1_Reactive_Energy_Revenue_A_kVAR_69", "Q1_Reactive_Energy_Revenue_B_kVAR_70", "Q1_Reactive_Energy_Revenue_C_kVAR_71", "Q2_Reactive_Energy_Revenue_A_kVAR_72", "Q2_Reactive_Energy_Revenue_B_kVAR_73", "Q2_Reactive_Energy_Revenue_C_kVAR_74", "Q3_Reactive_Energy_Revenue_A_kVAR_75", "Q3_Reactive_Energy_Revenue_B_kVAR_76", "Q3_Reactive_Energy_Revenue_C_kVAR_77", "Q4_Reactive_Energy_Revenue_A_kVAR_78", "Q4_Reactive_Energy_Revenue_B_kVAR_79", "Q4_Reactive_Energy_Revenue_C_kVAR_80") TO stdout 0 0 0 0 0 0 11 6536.427272 331.697966 866.79786 594.2206610909092 160.4076275580944 253960 59 23378 78 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8089700090597217456 SELECT * FROM "tbl001EC6050F3C_33" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 18 3.7912770000000005 0.038216 0.976025 0.21062649999999997 0.2873774790720483 196 168 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6452493843438600642 SELECT * FROM "tbl001EC6056300_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 5.917340000000001 1.579056 4.338284000000001 2.9586700000000006 1.3796140000000001 200 101 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2655360374593724555 SELECT * FROM "tbl001EC60506E1_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2162 82.71419999999995 0.013141 4.758659 0.03825818686401487 0.19854485764934193 2162 8604 44 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4727437538285089750 SELECT * FROM "tbl001EC6054E88_11" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3702 82.64836499999993 0.009552999999999999 0.804351 0.02232532820097246 0.020624333245770326 3701 11085 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6406861584801964677 SELECT * FROM "tbl001EC605311A_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6180 158.0033179999999 0.012719 2.855176 0.025566879935275073 0.05547288141849183 6180 18529 11 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7206612092024015835 LOCK TABLE public."tbl001EC6053075_5" IN ACCESS SHARE MODE 0 0 0 0 0 0 4 0.090075 0.019055 0.027832 0.02251875 0.0033945351946179612 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8286686929867759833 COPY public."tbl001EC6050D30_80" ("time", error, lowrange, highrange, "Inverter_ID_ASCII_CHAR_00_01_1", "Inverter_ID_ASCII_CHAR_02_03_2", "Inverter_ID_ASCII_CHAR_04_05_3", "Inverter_ID_ASCII_CHAR_06_07_4", "Inverter_ID_ASCII_CHAR_08_09_5", "Inverter_ID_ASCII_CHAR_10_11_6", "Inverter_ID_ASCII_CHAR_12_13_7", "Inverter_ID_ASCII_CHAR_14_15_8", "Firmware_Version_ASCII_CHAR_00_01_9", "Firmware_Version_ASCII_CHAR_02_03_10", "Firmware_Version_ASCII_CHAR_04_05_11", "Firmware_Version_ASCII_CHAR_06_07_12", "Map_version_13", "Inverter_configuration_14", "Inverter_serial_ASCII_CHAR_00_01_15", "Inverter_serial_ASCII_CHAR_02_03_16", "Inverter_serial_ASCII_CHAR_04_05_17", "Inverter_serial_ASCII_CHAR_06_07_18", "Inverter_serial_ASCII_CHAR_08_09_19", "Inverter_serial_ASCII_CHAR_10_11_20", "Inverter_serial_ASCII_CHAR_12_13_21", "Inverter_serial_ASCII_CHAR_14_15_22", "Inverter_serial_ASCII_CHAR_16_17_23", "Inverter_serial_ASCII_CHAR_18_19_24", "Voltage_A_N_V_25", "Voltage_B_N_V_26", "Voltage_C_N_V_27", "Current_A_A_28", "Current_B_A_29", "Current_C_A_30", "DC_input_voltage_V_31", "DC_input_current_A_32", "Line_Frequency_Hz_33", "Output_Generation_kW_34", "Total_Energy_Generation_kWh_35", "PV_Input_Voltage_V_36", "Input_Generation_calculated_kW_37", "Inverter_operating_status_state_38", "Main_fault_39", "Drive_fault_40", "Voltage_fault_41", "Grid_fault_42", "Temperature_fault_43", "System_fault_44", "System_warnings_45", "PVM_status_codes_46") TO stdout 0 0 0 0 0 0 11 798.068865 55.61597 98.854163 72.551715 11.091471755831106 93665 1229 3744 8 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 905976906289400631 SET client_min_messages=notice 0 0 0 0 0 0 4 0.010119 0.00177 0.003166 0.00252975 0.0006059869532423945 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1230337631824687512 SELECT * FROM "tbl001EC6050189_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1762 49.278048999999925 0.00763 3.6888739999999998 0.027967110669693533 0.1370226103615436 1761 4454 22 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3810966080860055649 LOCK TABLE public."tbl001EC6050D17_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.028305 0.028305 0.028305 0.028305 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -590670737981508520 SELECT * FROM "tbl001EC6050E4D_80" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 10298 287.1850540000003 0.014483 2.525365 0.027887459118275424 0.05774009235250835 10298 30877 17 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3494879671813421537 INSERT INTO "tbl001EC6050BAC_3" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 10233 557.1493620000007 0.015511 67.687707 0.05444633655819402 0.6900839397223579 10233 62168 96 5525 181 0 0 0 0 0 0 0 0 30727 5281 24408964
16385 16384 t -1538463311646837960 COPY public."tbl001EC60537E0_2" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 8 35.109376 0.069702 7.97695 4.388672000000001 2.630767648572323 8232 82 79 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1781943504368410970 LOCK TABLE public."tbl001EC6056D49_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.3840430000000001 0.017604 0.148407 0.03491299999999999 0.036297840714641066 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4177472427163830166 LOCK TABLE public."tbl001EC6050B87_5" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.37139000000000005 0.024131 0.073512 0.037139 0.015749718683201932 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4339902332375380363 SELECT * FROM "tbl001EC60506E1_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 6 0.885051 0.10047500000000001 0.216586 0.1475085 0.04033901219973043 600 29 0 10 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4559525109671902606 SELECT * FROM "tbl001EC60537E0_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 4120 104.48063400000017 0.005742000000000001 3.162187 0.025359377184466073 0.06701832977977616 4119 11543 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7893755655820554076 INSERT INTO "tbl001EC6056D47_50" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15671 843.4098850000056 0.019312 2.837146 0.053819787186522805 0.06594565758372993 15671 98834 28 10846 1488 0 0 0 0 0 0 0 0 47055 8285 46632660
16385 16384 t -882954474607768591 SELECT * FROM "tbl001EC6050D17_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 9 12.865828 0.057691 11.170026 1.4295364444444445 3.4484110811344566 249 437 18 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8545590094234210170 LOCK TABLE public."tbl001EC6050D16_5" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.141253 0.017619 0.024502 0.020179000000000002 0.002172239200193465 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7001264197968889793 SELECT * FROM "tbl001EC6053093_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30502 1294.5322400000066 0.021988999999999998 5.260133 0.04244089699036123 0.07279366948870042 30502 121968 40 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3726855867855014023 LOCK TABLE public."tbl001EC6056FD2_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.302778 0.019188 0.048033 0.027525272727272725 0.00849627458564698 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 881251627666653277 SELECT * FROM "tbl001EC6050D06_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 18 30.917043999999997 0.553122 9.068698 1.7176135555555554 2.4448260065936123 1800 5079 25 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4761008475407494000 INSERT INTO "tbl001EC6053CD9_4" VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 3071 159.42515799999984 0.016453 2.4808260000000004 0.051913109084988605 0.10633309103836937 3071 18611 39 4034 40 0 0 0 0 0 0 0 0 9222 4017 17398742
16385 13761 t -8217787928374346230 DROP TABLE IF EXISTS _7b39a21ac0c4a9821e6d26376e0be03b 0 0 0 0 0 0 1 1.007686 1.007686 1.007686 1.007686 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6423888068504112425 SELECT * FROM "tbl001EC6056FD2_63" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.555469 0.192349 0.36312 0.2777345 0.0853855 200 110 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1022216283660081612 SELECT * FROM "tbl001EC6053113_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29904 1370.1381600000059 0.028767 5.733714 0.045817889245585726 0.047792870636183406 29904 89693 19 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3598250727493113391 LOCK TABLE public."tbl001EC6053CD9_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.170536 0.020972 0.034327 0.024362285714285715 0.004719772867243439 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3033217080036596150 SELECT checkpoints_timed ,checkpoints_req ,checkpoint_write_time ,checkpoint_sync_time ,buffers_checkpoint ,buffers_clean ,maxwritten_clean ,buffers_backend ,buffers_backend_fsync ,buffers_alloc ,stats_reset FROM pg_stat_bgwriter 0 0 0 0 0 0 184467 369640.94411000225 0.063323 113.89989 2.003832360855851 3.988129806887121 184467 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5792809329006332841 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_2" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 6.959186 6.959186 6.959186 6.959186 0 0 1165 1 11 0 0 0 0 0 0 0 0 0 283 10 95299
16385 16384 t 2282511859623702562 SELECT * FROM "tbl001EC6050B87_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 39 183.82451500000002 0.439652 103.029634 4.713449102564102 16.05701748633756 3649 11450 245 6 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8389198162331681533 SELECT slot_name, slot_type, CASE WHEN pg_is_in_recovery() THEN pg_last_wal_receive_lsn() - $1 ELSE pg_current_wal_lsn() - $2 END AS current_wal_lsn, COALESCE(confirmed_flush_lsn, $3) - $4 AS confirmed_flush_lsn, active, safe_wal_size, wal_status FROM pg_replication_slots 0 0 0 0 0 0 123551 1913.1293020000126 0.005306 4.078926 0.015484531100517266 0.021384061775173928 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4823108524736255565 INSERT INTO "tbl001EC6053113_10" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15649 894.9695000000039 0.015404000000000001 6.166111 0.05719020384689125 0.1369500246993052 15649 96224 413 9062 451 0 0 0 0 0 0 0 0 46990 8187 38080776
16385 16384 t -1700357955702562591 LOCK TABLE public."tbl001EC6056300_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.443293 0.017695 0.177208 0.04029936363636364 0.04414480012881725 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1203062231202201875 INSERT INTO "tbl001EC6056D41_54" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 3135 210.45474199999975 0.02265 2.156454 0.0671306992025519 0.10041877443896167 3135 21049 33 6253 246 0 0 0 0 0 0 0 0 9414 5812 26802961
16385 16384 t 1674390874603308315 SELECT * FROM "tbl001EC6050B5D_5" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1690 80.90198000000007 0.009829000000000001 2.112783 0.04787099408284027 0.09545411355708665 1689 4292 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2859277235430319612 SELECT name, setting, COALESCE(unit, $1), short_desc, vartype FROM pg_settings WHERE vartype IN ($2, $3, $4) AND name != $5 0 0 0 0 0 0 186105 409230.3527489976 1.055172 119.26013300000001 2.1989218599661338 2.0382670056785996 55831500 16 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -919948031571200222 CREATE TABLE IF NOT EXISTS "tbl001EC6053075_5" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "DC_Voltage_V_1" DOUBLE PRECISION DEFAULT NULL, "Apparent_AC_Power_VA_2" DOUBLE PRECISION DEFAULT NULL, "AC_Grid_Frequency_Hz_3" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Stage_Current_A_4" DOUBLE PRECISION DEFAULT NULL, "L1_to_L2_AC_Voltage_V_5" DOUBLE PRECISION DEFAULT NULL, "L2_to_L3_AC_Voltage_V_6" DOUBLE PRECISION DEFAULT NULL, "L1_to_L3_AC_Voltage_V_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Sequence_8" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_kWh_9" DOUBLE PRECISION DEFAULT NULL, "On_Grid_Hours_Hrs_10" DOUBLE PRECISION DEFAULT NULL, "Fan_On_Time_Hours_Hrs_11" DOUBLE PRECISION DEFAULT NULL, "AC_Contactors_Cycles_12" DOUBLE PRECISION DEFAULT NULL, "Network_ID_13" DOUBLE PRECISION DEFAULT NULL, "Informative_Alarms_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 10.341205 10.341205 10.341205 10.341205 0 0 745 5 39 0 0 0 0 0 0 0 0 0 135 37 176324
16385 16384 t -3640787550058088845 COPY public."tbl001EC60537E0_21" ("time", error, lowrange, highrange, "Vln_a_Volts_1", "Vln_b_Volts_2", "Vln_c_Volts_3", "Vln_ave_Volts_4", "Vll_ab_Volts_5", "Vll_bc_Volts_6", "Vll_ca_Volts_7", "Vll_ave_Volts_8", "I_a_Amps_9", "I_b_Amps_10", "I_c_Amps_11", "I_ave_Amps_12", "V_unbal_13", "I_unbal_14", "Freq_Hz_15", "I4_Amps_16", "kW_a_kW_17", "kW_b_kW_18", "kW_c_kW_19", "kW_tot_kW_20", "kVAR_a_kVAR_21", "kVAR_b_kVAR_22", "kVAR_c_kVAR_23", "kVAR_tot_kVAR_24", "kVA_a_kVA_25", "kVA_b_kVA_26", "kVA_c_kVA_27", "kVA_tot_kVA_28", "PF_sign_a_29", "PF_sign_b_30", "PF_sign_c_31", "PF_sign_tot_32", "Vll_ave_mx_Volts_33", "I_ave_mx_Amps_34", "kW_tot_mx_kW_35", "kVAR_tot_mx_kVAR_36", "kVA_tot_mx_kVA_37", "Freq_mx_Hz_38", "Vll_ave_mn_Volts_39", "I_ave_mn_Amps_40", "Freq_mn_Hz_41", "kW_sd_del_rec_kW_42", "kVA_sd_del_rec_kVA_43", "kVAR_sd_del_rec_kVAR_44", "kW_sd_mx_d_r_kW_45", "kVA_sd_mx_d_r_kVA_46", "kVAR_sd_mx_d_r_kVAR_47", "Phase_Rev_48", "kWh_del_kWh_49", "kWh_rec_kWh_50", "kWh_del_rec_kWh_51", "kWh_del_rec_kWh_52", "kVARh_del_kVARh_53", "kVARh_rec_kVARh_54", "kVARh_del_rec_kVARh_55", "kVARh_del_rec_kVARh_56", "kVAh_del_rec_kVAh_57", "V1_THD_mx_58", "V2_THD_mx_59", "V3_THD_mx_60", "I1_THD_mx_61", "I2_THD_mx_62", "I3_THD_mx_63", unused_64) TO stdout 0 0 0 0 0 0 8 201.35218 0.208305 81.933611 25.1690225 24.31729292055452 8232 288 427 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8448468195485461587 SELECT * FROM "tbl001EC6056D48_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30402 1219.5142720000026 0.022168 2.8983809999999997 0.040112962041970714 0.03286764397258819 30402 91200 6 1 0 0 0 0 0 0 0 0 0 0 0 0