Tables

conditions dl_device_type dl_inverter_device_data dl_meter_device_data pg_stat_statements pg_stat_statements_info tbl001EC6050189_1 tbl001EC6050189_2 tbl001EC6050189_3 tbl001EC6050189_32 tbl001EC6050189_33 tbl001EC6050189_6 tbl001EC60506E1_1 tbl001EC60506E1_10 tbl001EC60506E1_3 tbl001EC6050B08_1 tbl001EC6050B08_2 tbl001EC6050B08_51 tbl001EC6050B42_1 tbl001EC6050B42_2 tbl001EC6050B42_3 tbl001EC6050B42_4 tbl001EC6050B42_51 tbl001EC6050B42_52 tbl001EC6050B5D_1 tbl001EC6050B5D_2 tbl001EC6050B5D_3 tbl001EC6050B5D_4 tbl001EC6050B5D_5 tbl001EC6050B5D_51 tbl001EC6050B5D_52 tbl001EC6050B87_1 tbl001EC6050B87_103 tbl001EC6050B87_2 tbl001EC6050B87_3 tbl001EC6050B87_4 tbl001EC6050B87_5 tbl001EC6050B87_51 tbl001EC6050B87_6 tbl001EC6050B87_7 tbl001EC6050BAC_1 tbl001EC6050BAC_10 tbl001EC6050BAC_2 tbl001EC6050BAC_3 tbl001EC6050BAC_4 tbl001EC6050BAC_5 tbl001EC6050BAC_51 tbl001EC6050BAC_52 tbl001EC6050BAC_6 tbl001EC6050BAC_7 tbl001EC6050BAC_8 tbl001EC6050BAC_9 tbl001EC6050C0B_1 tbl001EC6050C0B_3 tbl001EC6050C0B_51 tbl001EC6050D05_103 tbl001EC6050D05_51 tbl001EC6050D05_80 tbl001EC6050D06_2 tbl001EC6050D06_3 tbl001EC6050D06_4 tbl001EC6050D06_51 tbl001EC6050D16_10 tbl001EC6050D16_4 tbl001EC6050D16_5 tbl001EC6050D16_50 tbl001EC6050D16_51 tbl001EC6050D16_52 tbl001EC6050D16_6 tbl001EC6050D16_7 tbl001EC6050D16_8 tbl001EC6050D16_9 tbl001EC6050D17_1 tbl001EC6050D17_2 tbl001EC6050D17_3 tbl001EC6050D17_4 tbl001EC6050D17_5 tbl001EC6050D17_51 tbl001EC6050D17_6 tbl001EC6050D21_103 tbl001EC6050D21_51 tbl001EC6050D21_52 tbl001EC6050D21_80 tbl001EC6050D21_81 tbl001EC6050D30_3 tbl001EC6050D30_51 tbl001EC6050D30_80 tbl001EC6050E0D_1 tbl001EC6050E0D_2 tbl001EC6050E0D_51 tbl001EC6050E4D_2 tbl001EC6050E4D_52 tbl001EC6050E4D_80 tbl001EC6050E4D_81 tbl001EC6050EFC_211 tbl001EC6050EFC_213 tbl001EC6050F3A_1 tbl001EC6050F3A_2 tbl001EC6050F3A_3 tbl001EC6050F3A_4 tbl001EC6050F3A_51 tbl001EC6050F3C_1 tbl001EC6050F3C_10 tbl001EC6050F3C_11 tbl001EC6050F3C_12 tbl001EC6050F3C_13 tbl001EC6050F3C_14 tbl001EC6050F3C_15 tbl001EC6050F3C_16 tbl001EC6050F3C_17 tbl001EC6050F3C_18 tbl001EC6050F3C_19 tbl001EC6050F3C_2 tbl001EC6050F3C_3 tbl001EC6050F3C_33 tbl001EC6050F3C_4 tbl001EC6050F3C_5 tbl001EC6050F3C_54 tbl001EC6050F3C_6 tbl001EC6050F3C_7 tbl001EC6050F3C_8 tbl001EC6050F3C_9 tbl001EC6050F42_1 tbl001EC6050F42_2 tbl001EC6050F42_51 tbl001EC6052F1E_51 tbl001EC6052F1E_9 tbl001EC6053019_53 tbl001EC6053075_5 tbl001EC6053075_51 tbl001EC6053075_52 tbl001EC6053075_53 tbl001EC6053075_54 tbl001EC6053075_6 tbl001EC6053075_60 tbl001EC6053075_7 tbl001EC6053093_51 tbl001EC6053093_52 tbl001EC6053093_53 tbl001EC6053093_54 tbl001EC6053093_55 tbl001EC6053093_9 tbl001EC605309C_51 tbl001EC605309C_52 tbl001EC605309C_53 tbl001EC605309C_54 tbl001EC605309C_55 tbl001EC605309C_9 tbl001EC60530AB_51 tbl001EC60530AB_9 tbl001EC6053109_1 tbl001EC6053109_11 tbl001EC6053109_2 tbl001EC6053109_3 tbl001EC6053109_4 tbl001EC6053109_5 tbl001EC6053109_7 tbl001EC6053113_10 tbl001EC6053113_51 tbl001EC6053113_52 tbl001EC6053113_53 tbl001EC6053113_9 tbl001EC605311A_1 tbl001EC605311A_2 tbl001EC605311A_3 tbl001EC60537AE_1 tbl001EC60537AE_2 tbl001EC60537AE_21 tbl001EC60537AE_41 tbl001EC60537E0_1 tbl001EC60537E0_2 tbl001EC60537E0_21 tbl001EC60537E0_3 tbl001EC60537E0_41 tbl001EC6053CD9_1 tbl001EC6053CD9_10 tbl001EC6053CD9_2 tbl001EC6053CD9_4 tbl001EC6053CD9_5 tbl001EC6054E7A_1 tbl001EC6054E88_103 tbl001EC6054E88_11 tbl001EC6054E88_56 tbl001EC6056300_10 tbl001EC6056300_15 tbl001EC6056300_50 tbl001EC6056300_51 tbl001EC6056300_52 tbl001EC6056300_53 tbl001EC6056300_55 tbl001EC6056D41_51 tbl001EC6056D41_52 tbl001EC6056D41_53 tbl001EC6056D41_54 tbl001EC6056D41_55 tbl001EC6056D41_9 tbl001EC6056D47_10 tbl001EC6056D47_50 tbl001EC6056D47_51 tbl001EC6056D47_52 tbl001EC6056D47_9 tbl001EC6056D48_51 tbl001EC6056D48_52 tbl001EC6056D48_53 tbl001EC6056D48_54 tbl001EC6056D48_55 tbl001EC6056D48_9 tbl001EC6056D49_10 tbl001EC6056D49_51 tbl001EC6056D49_52 tbl001EC6056D49_53 tbl001EC6056D49_9 tbl001EC6056FD2_10 tbl001EC6056FD2_23 tbl001EC6056FD2_26 tbl001EC6056FD2_27 tbl001EC6056FD2_28 tbl001EC6056FD2_51 tbl001EC6056FD2_52 tbl001EC6056FD2_54 tbl001EC6056FD2_55 tbl001EC6056FD2_59 tbl001EC6056FD2_60 tbl001EC6056FD2_61 tbl001EC6056FD2_62 tbl001EC6056FD2_63 tbl001EC6056FD2_64 tbl001EC6056FD2_65 tbl001EC6056FD2_66 tbl001EC6056FD2_67 tbl001EC6056FD2_68 tbl001EC6056FD2_69 tbl001EC6056FD2_9 tbl001EC6057D26_4 tblacquisuite tbldevicelist

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 -6875939680217679485 COPY public."tbl001EC6053CD9_1" ("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 6 37.718655 1.242178 13.842059 6.2864425 4.204885745344407 8118 94 68 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1917432499337382162 INSERT INTO "tbl001EC6056FD2_61" 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 15256 629.9444290000023 0.014868000000000001 4.835656 0.04129158554011516 0.0775649709096082 15256 94378 46 8741 314 0 0 0 0 0 0 0 0 45809 8049 39382777
16385 13761 t 1764253958286693590 CREATE TABLE _67fd6ee7e4f01dfcea8c7178633bfc2b(cmd_output text) 0 0 0 0 0 0 1 12.136124 12.136124 12.136124 12.136124 0 0 505 3 26 0 0 0 0 0 0 0 0 0 92 25 96009
16385 16384 t -658444458644331300 COPY public."tbl001EC6050B87_5" ("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 9 309.20073 1.89184 69.796289 34.35563666666667 22.31812073485481 27378 867 1561 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4959767942330807915 INSERT INTO "tbl001EC6056FD2_69" 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 15256 619.5549330000038 0.015078000000000001 4.1849490000000005 0.040610575052438515 0.06167416899231813 15256 94400 42 8691 317 0 0 0 0 0 0 0 0 45809 8011 39131405
16385 16384 t -6765505269119710467 SELECT * FROM "tbl001EC6050D06_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3372 147.127951 0.00881 2.227132 0.04363225118623959 0.04388175014869807 3371 9304 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7255880967451626351 SELECT * FROM "tbl001EC6056D49_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29576 1183.6261250000114 0.020531999999999998 2.424565 0.04001981758858513 0.028122862442261073 29576 88724 4 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6681778736620723284 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_54" ( 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 9.009545 9.009545 9.009545 9.009545 0 0 933 2 10 0 0 0 0 0 0 0 0 0 226 9 74483
16385 16384 t -7889903677744378010 INSERT INTO "tbl001EC6050F3C_11" 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 83 4.07827 0.027393 0.162859 0.04913578313253013 0.020619816500911974 83 333 0 165 2 0 0 0 0 0 0 0 0 250 162 296859
16385 16384 t -2219161677984514301 LOCK TABLE public."tbl001EC6050D16_10" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.174051 0.01965 0.06031 0.029008500000000003 0.01462710869983083 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5686801952966243016 CREATE TABLE IF NOT EXISTS "tbl001EC6050B87_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 6.013641 6.013641 6.013641 6.013641 0 0 886 1 3 0 0 0 0 0 0 0 0 0 219 3 28402
16385 16384 t -7322177306657076758 LOCK TABLE public."tbl001EC6050B42_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.127089 0.01993 0.023652 0.021181500000000002 0.0013980488486935402 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8786260371827405139 SELECT * FROM "tbl001EC6050189_6" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 26 73.362437 0.057207 8.89912 2.8216321923076926 2.76575479428468 1939 647 66 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8562298773565266370 CREATE TABLE IF NOT EXISTS "tbl001EC6050D30_3" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Vln_a_Volts_1" DOUBLE PRECISION DEFAULT NULL, "Vln_b_Volts_2" DOUBLE PRECISION DEFAULT NULL, "Vln_c_Volts_3" DOUBLE PRECISION DEFAULT NULL, "Vln_ave_Volts_4" DOUBLE PRECISION DEFAULT NULL, "Vll_ab_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Vll_bc_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Vll_ca_Volts_7" DOUBLE PRECISION DEFAULT NULL, "Vll_ave_Volts_8" DOUBLE PRECISION DEFAULT NULL, "I_a_Amps_9" DOUBLE PRECISION DEFAULT NULL, "I_b_Amps_10" DOUBLE PRECISION DEFAULT NULL, "I_c_Amps_11" DOUBLE PRECISION DEFAULT NULL, "I_ave_Amps_12" DOUBLE PRECISION DEFAULT NULL, "V_unbal_13" DOUBLE PRECISION DEFAULT NULL, "I_unbal_14" DOUBLE PRECISION DEFAULT NULL, "Freq_Hz_15" DOUBLE PRECISION DEFAULT NULL, "I4_Amps_16" DOUBLE PRECISION DEFAULT NULL, "kW_a_kW_17" DOUBLE PRECISION DEFAULT NULL, "kW_b_kW_18" DOUBLE PRECISION DEFAULT NULL, "kW_c_kW_19" DOUBLE PRECISION DEFAULT NULL, "kW_tot_kW_20" DOUBLE PRECISION DEFAULT NULL, "kVAR_a_kVAR_21" DOUBLE PRECISION DEFAULT NULL, "kVAR_b_kVAR_22" DOUBLE PRECISION DEFAULT NULL, "kVAR_c_kVAR_23" DOUBLE PRECISION DEFAULT NULL, "kVAR_tot_kVAR_24" DOUBLE PRECISION DEFAULT NULL, "kVA_a_kVA_25" DOUBLE PRECISION DEFAULT NULL, "kVA_b_kVA_26" DOUBLE PRECISION DEFAULT NULL, "kVA_c_kVA_27" DOUBLE PRECISION DEFAULT NULL, "kVA_tot_kVA_28" DOUBLE PRECISION DEFAULT NULL, "PF_sign_a_29" DOUBLE PRECISION DEFAULT NULL, "PF_sign_b_30" DOUBLE PRECISION DEFAULT NULL, "PF_sign_c_31" DOUBLE PRECISION DEFAULT NULL, "PF_sign_tot_32" DOUBLE PRECISION DEFAULT NULL, "Vll_ave_mx_Volts_33" DOUBLE PRECISION DEFAULT NULL, "I_ave_mx_Amps_34" DOUBLE PRECISION DEFAULT NULL, "kW_tot_mx_kW_35" DOUBLE PRECISION DEFAULT NULL, "kVAR_tot_mx_kVAR_36" DOUBLE PRECISION DEFAULT NULL, "kVA_tot_mx_kVA_37" DOUBLE PRECISION DEFAULT NULL, "Freq_mx_Hz_38" DOUBLE PRECISION DEFAULT NULL, "Vll_ave_mn_Volts_39" DOUBLE PRECISION DEFAULT NULL, "I_ave_mn_Amps_40" DOUBLE PRECISION DEFAULT NULL, "Freq_mn_Hz_41" DOUBLE PRECISION DEFAULT NULL, "kW_sd_del_rec_kW_42" DOUBLE PRECISION DEFAULT NULL, "kVA_sd_del_rec_kVA_43" DOUBLE PRECISION DEFAULT NULL, "kVAR_sd_del_rec_kVAR_44" DOUBLE PRECISION DEFAULT NULL, "kW_sd_mx_d_r_kW_45" DOUBLE PRECISION DEFAULT NULL, "kVA_sd_mx_d_r_kVA_46" DOUBLE PRECISION DEFAULT NULL, "kVAR_sd_mx_d_r_kVAR_47" DOUBLE PRECISION DEFAULT NULL, "Phase_Rev_48" DOUBLE PRECISION DEFAULT NULL, "kWh_del_kWh_49" DOUBLE PRECISION DEFAULT NULL, "kWh_rec_kWh_50" DOUBLE PRECISION DEFAULT NULL, "kWh_del_rec_kWh_51" DOUBLE PRECISION DEFAULT NULL, "kWh_del_rec_kWh_52" DOUBLE PRECISION DEFAULT NULL, "kVARh_del_kVARh_53" DOUBLE PRECISION DEFAULT NULL, "kVARh_rec_kVARh_54" DOUBLE PRECISION DEFAULT NULL, "kVARh_del_rec_kVARh_55" DOUBLE PRECISION DEFAULT NULL, "kVARh_del_rec_kVARh_56" DOUBLE PRECISION DEFAULT NULL, "kVAh_del_rec_kVAh_57" DOUBLE PRECISION DEFAULT NULL, "V1_THD_mx_58" DOUBLE PRECISION DEFAULT NULL, "V2_THD_mx_59" DOUBLE PRECISION DEFAULT NULL, "V3_THD_mx_60" DOUBLE PRECISION DEFAULT NULL, "I1_THD_mx_61" DOUBLE PRECISION DEFAULT NULL, "I2_THD_mx_62" DOUBLE PRECISION DEFAULT NULL, "I3_THD_mx_63" DOUBLE PRECISION DEFAULT NULL, "unused_64" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 52.282106 52.282106 52.282106 52.282106 0 0 1124 77 41 0 0 0 0 0 0 0 0 0 244 38 199543
16385 16384 t -4203805990209830924 COPY public."tbl001EC60530AB_51" ("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 3949.3751060000004 313.853998 573.015064 394.9375106 74.54340760278873 325190 1558 28680 44 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6720849247711158671 LOCK TABLE public."tbl001EC6056FD2_59" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 1.432968 0.022849 1.127111 0.1432968 0.3280608658507747 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9155193666847515428 SELECT * FROM "tbl001EC6050B42_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1126 38.88330400000002 0.005509 7.035879 0.03453224156305509 0.22782760387617917 1125 2559 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1958189684033139884 SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(p.proacl,pg_catalog.acldefault($1,p.proowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,p.proowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS proacl, (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,p.proowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(p.proacl,pg_catalog.acldefault($6,p.proowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) AS rproacl, $7 AS initproacl, $8 AS initrproacl, p.pronamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = p.proowner) AS rolname FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = $9::regclass AND pip.objsubid = $10) WHERE p.prokind <> $11 AND NOT EXISTS (SELECT $12 FROM pg_depend WHERE classid = $13::regclass AND objid = p.oid AND deptype = $14) AND ( pronamespace != (SELECT oid FROM pg_namespace WHERE nspname = $15) OR EXISTS (SELECT $16 FROM pg_cast WHERE pg_cast.oid > $17 AND p.oid = pg_cast.castfunc) OR EXISTS (SELECT $18 FROM pg_transform WHERE pg_transform.oid > $19 AND (p.oid = pg_transform.trffromsql OR p.oid = pg_transform.trftosql)) OR p.proacl IS DISTINCT FROM pip.initprivs) 0 0 0 0 0 0 10 478.2349540000001 21.929122999999997 84.83435300000001 47.8234954 18.45843403786106 3000 3850 530 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3158508218147820510 SELECT * FROM "tbl001EC6050B5D_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1674 43.024381999999996 0.010957 1.937413 0.02570154241338112 0.08009669050500111 1673 4227 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7983667754917634682 CREATE TABLE IF NOT EXISTS tblacquisuite ( serialnumber VARCHAR(20) PRIMARY KEY, password VARCHAR(64) NOT NULL, name VARCHAR(100), lastuploadtime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, config BYTEA, configchangetime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, configchecksum VARCHAR(64), firmwareversion VARCHAR(64) ) 0 0 0 0 0 0 3601145 194735.55826100212 0.023847 92.300734 0.054076011452190105 0.2150784448911905 0 23896 65 0 0 0 0 0 0 0 0 0 0 2 0 142
16385 16384 t -1523122680739484758 INSERT INTO tblacquisuite (serialnumber, password) VALUES ($1, $2) ON CONFLICT (serialnumber) DO NOTHING 0 0 0 0 0 0 18 7.926793 0.070517 0.963834 0.44037738888888883 0.38292683931923005 18 124 8 36 0 0 0 0 0 0 0 0 0 54 36 122534
16385 16384 t -5689723223478772456 INSERT INTO "tbl001EC6057D26_4" VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 3051 222.2339009999999 0.016266 16.799491 0.07283969223205498 0.32108236779364846 3051 19100 23 5872 58 0 0 0 0 0 0 0 0 9161 5884 25639715
16385 16384 t 8351775942804763120 SELECT * FROM "tbl001EC60537E0_41" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3952 101.21353300000014 0.007328 1.247198 0.025610711791497955 0.03489333739186165 3951 11041 3 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9088440367090795019 SELECT * FROM "tbl001EC6050D05_103" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 5 7.513278 0.885286 2.738329 1.5026556 0.6906471317330145 500 204 0 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1315256996097975791 SET lock_timeout = 0 0 0 0 0 0 0 10 0.069247 0.003899 0.012354 0.0069247 0.0030197916500977347 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -60576080738721978 LOCK TABLE public."tbl001EC6053113_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.22672400000000004 0.017526 0.029836 0.0226724 0.0039992887917728575 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 812480966011973916 SELECT * FROM "tbl001EC6050F3C_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 10 0.6785340000000001 0.027686 0.202778 0.06785340000000001 0.05733041965344402 184 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8562466736490574703 INSERT INTO "tbl001EC6056FD2_68" 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 15256 625.0437559999986 0.015264000000000002 2.960809 0.04097035631882532 0.06215926531614543 15256 94310 42 8596 321 0 0 0 0 0 0 0 0 45809 7911 38039817
16385 16384 t 6478991220833328220 SELECT current_database() datname, schemaname, relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, n_mod_since_analyze, COALESCE(last_vacuum, $1) as last_vacuum, COALESCE(last_autovacuum, $2) as last_autovacuum, COALESCE(last_analyze, $3) as last_analyze, COALESCE(last_autoanalyze, $4) as last_autoanalyze, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count, pg_total_relation_size(relid) as total_size FROM pg_stat_user_tables 0 0 0 0 0 0 179466 4525363.64801698 10.931731 821.786323 25.215715779128058 18.86058044324123 35832422 1144410838 440 0 0 0 0 0 0 0 0 0 0 4 0 256
16385 16384 t 1031307865707556548 -- pg_get_indexdef did not support INCLUDE columns SELECT a.attname as colname FROM ( SELECT i.indnkeyatts, i.indrelid, pg_catalog.unnest(indkey) AS table_colnum, pg_catalog.unnest(ARRAY(SELECT pg_catalog.generate_series($1, i.indnatts) AS n)) attnum FROM pg_catalog.pg_index i WHERE i.indexrelid = $2::OID ) i JOIN pg_catalog.pg_attribute a ON (a.attrelid = i.indrelid AND i.table_colnum = a.attnum) WHERE i.attnum > i.indnkeyatts ORDER BY i.attnum 0 0 0 0 0 0 10 0.419932 0.022668999999999998 0.190207 0.041993199999999994 0.0495487298036993 0 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2965823601041084731 SELECT pol.oid, pol.tableoid, pol.polrelid, pol.polname, pol.polcmd, pol.polpermissive, CASE WHEN pol.polroles = $1 THEN $2 ELSE pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(rolname) from pg_catalog.pg_roles WHERE oid = ANY(pol.polroles)), $3) END AS polroles, pg_catalog.pg_get_expr(pol.polqual, pol.polrelid) AS polqual, pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid) AS polwithcheck FROM unnest($4::pg_catalog.oid[]) AS src(tbloid) JOIN pg_catalog.pg_policy pol ON (src.tbloid = pol.polrelid) 0 0 0 0 0 0 10 0.163265 0.015552 0.017499 0.0163265 0.0006296501012467158 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9114868446763214196 SELECT * FROM "tbl001EC6050D21_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 4 4.988922 0.37383099999999997 3.6610810000000003 1.2472305000000001 1.3946689950969549 400 87 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1738038041871174897 SELECT * FROM "tbl001EC6050F3C_7" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 166 5.794731999999999 0.010454 1.266049 0.034908024096385534 0.09660394194580928 165 329 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1841907060942206006 COPY public."tbl001EC6050F3C_17" ("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 1 0.111739 0.111739 0.111739 0.111739 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 227523649052159221 COPY _timescaledb_catalog.continuous_aggs_materialization_invalidation_log (materialization_id, lowest_modified_value, greatest_modified_value) TO stdout 0 0 0 0 0 0 10 0.224823 0.020104 0.024126 0.0224823 0.0013046510682937422 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4990405823209452054 SELECT * FROM "tbl001EC6050D16_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 12 2.228854 0.091229 0.5404509999999999 0.18573783333333335 0.1174169185550882 1200 83 0 18 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5150948721564352453 LOCK TABLE public."tbl001EC6050F3C_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.027875 0.027875 0.027875 0.027875 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6484619689149886235 INSERT INTO "tbl001EC6056D48_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 15258 801.1480699999987 0.019369 3.5293680000000003 0.0525067551448419 0.06305775310966767 15258 96496 27 10855 1397 0 0 0 0 0 0 0 0 45816 8178 46096904
16385 16384 t -5056835883387869000 INSERT INTO "tbl001EC6053093_53" 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 15259 853.7450320000044 0.01961 2.7717039999999997 0.05595026096074446 0.07355186026274195 15259 97347 36 10459 1627 0 0 0 0 0 0 0 0 45820 7796 43753407
16385 16384 t 5476564701160806171 INSERT INTO "tbl001EC60530AB_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 15259 1019.1783240000038 0.019185999999999998 7.415578 0.06679194730978419 0.1422029643369744 15259 95935 288 10816 1475 0 0 0 0 0 0 0 0 45820 8101 45691858
16385 16384 t -1213835742240001064 COPY public."tbl001EC60506E1_1" ("time", error, lowrange, highrange, "Software_Identification_Number_v_1", "Fault_Word_1_2", "Fault_Word_2_3", "Fault_Word_3_4", "Fault_Word_4_5", "Fault_Word_5_6", "Fault_Word_6_7", "Fault_Word_7_8", "Number_of_Faults_9", "Program_Checksum_10", "Parameter_Checksum_11", "DC_Input_Volts_volts_12", "DC_Link_Volts_volts_13", "DC_Link_Amps_amps_14", "DC_Ground_Current_amps_15", "Line_Amps_A_amps_16", "Line_Amps_B_amps_17", "Line_Amps_C_amps_18", "Line_Amps_Average_amps_19", "Neutral_Current_amps_20", "Line_Volts_A_volts_21", "Line_Volts_B_volts_22", "Line_Volts_C_volts_23", "Line_Volts_Average_volts_24", "Line_Voltage_Unbalance_25", "Line_Current_Unbalance_26", "Input_kW_kw_27", "Output_kw_kw_28", "Output_kvar_kvar_29", "Output_kva_kva_30", "Power_Factor_31", "Ground_Impedance_kohms_32", "String_Amps_1_amps_33", "String_Amps_2_amps_34", "String_Amps_3_amps_35", "String_Amps_4_amps_36", "String_Amps_5_amps_37", "String_Amps_6_amps_38", "String_Amps_7_amps_39", "String_Amps_8_amps_40", "String_Amps_9_amps_41", "String_Amps_10_amps_42", "String_Amps_11_amps_43", "String_Amps_12_amps_44", "String_Amps_13_amps_45", "String_Amps_14_amps_46", "String_Amps_15_amps_47", "String_Amps_16_amps_48", "String_Amps_17_amps_49", "String_Amps_18_amps_50", "String_Amps_19_amps_51", "String_Amps_20_amps_52", "String_Amps_21_amps_53", "String_Amps_22_amps_54", "String_Amps_23_amps_55", "String_Amps_24_amps_56", "String_Amps_25_amps_57", "String_Amps_26_amps_58", "String_Amps_27_amps_59", "String_Amps_28_amps_60", "String_Amps_29_amps_61", "String_Amps_30_amps_62", "String_Amps_31_amps_63", "String_Amps_32_amps_64", "String_Amps_Average_amps_65", "String_kwh_1_kwh_66", "String_kwh_2_kwh_67", "String_kwh_3_kwh_68", "String_kwh_4_kwh_69", "String_kwh_5_kwh_70", "String_kwh_6_kwh_71", "String_kwh_7_kwh_72", "String_kwh_8_kwh_73", "String_kwh_9_kwh_74", "String_kwh_10_kwh_75", "String_kwh_11_kwh_76", "String_kwh_12_kwh_77", "String_kwh_13_kwh_78", "String_kwh_14_kwh_79", "String_kwh_15_kwh_80", "String_kwh_16_kwh_81", "String_kwh_17_kwh_82", "String_kwh_18_kwh_83", "String_kwh_19_kwh_84", "String_kwh_20_kwh_85", "String_kwh_21_kwh_86", "String_kwh_22_kwh_87", "String_kwh_23_kwh_88", "String_kwh_24_kwh_89", "String_kwh_25_kwh_90", "String_kwh_26_kwh_91", "String_kwh_27_kwh_92", "String_kwh_28_kwh_93", "String_kwh_29_kwh_94", "String_kwh_30_kwh_95", "String_kwh_31_kwh_96", "String_kwh_32_kwh_97", "String_kwh_Average_kwh_98", "Total_kwh_kwh_99", "Total_mwh_mwh_100", "kwh_Today_kwh_101", "kwh_Yesterday_kwh_102", "Total_kwh_7_days_kwh_103", "Total_kwh_30_days_mwhr_104", "Average_kwh_7_days_kwh_105", "Average_kwh_30_Days_kwh_106", "Average_Line_Frequency_Hz_107", "Average_Line_Frequency_Error_difference_108", "FPGA_Identification_Number_num_109", "DC_Input_Voltage_Timer_min_110", "AC_Line_Voltage_Timer_min_111", "Operating_State_112", "Internal_Air_Temperature_Deg_C_113", "Inverter_Air_Temperature_Deg_C_114", "Heatsink_Temperature_1_Deg_C_115", "Heatsink_Temperature_2_Deg_C_116", "Heatsink_Temperature_3_Deg_C_117", "Heatsink_Temperature_4_Deg_C_118", "Heatsink_Temperature_5_Deg_C_119", "Heatsink_Temperature_6_Deg_C_120", "Heatsink_Maximum_Temparature_1_Deg_C_121", "Fan_Speed_Command_1_122", "Heatsink_Maximum_Temperature_2_Deg_C_123", "Fan_Speed_Command_2_124", "Number_of_Temperature_Feedbacks_125", "Serial_number_word_1_126", "Serial_number_word_2_127", "Serial_number_word_3_128", "Serial_number_word_4_129", "Number_of_Strings_130") TO stdout 0 0 0 0 0 0 10 46173.270403999995 4259.039129 4971.172739 4617.3270403999995 195.55230816915804 2069352 3111 296647 1807 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4984584874110114321 SELECT last_value, is_called FROM public.dl_device_type_id_seq 0 0 0 0 0 0 10 6.984858 0.56323 1.146987 0.6984858 0.16581568184933534 10 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6406474304916992974 INSERT INTO "tbl001EC605309C_53" 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 15233 1067.2524519999977 0.019962 7.501126 0.07006186909998012 0.14966533727357176 15233 95801 395 10613 1472 0 0 0 0 0 0 0 0 45741 7897 44596194
16385 13761 t 4795912698999389308 CREATE TABLE _38485d3f99d60a686d135cb5677ebeba(cmd_output text) 0 0 0 0 0 0 1 8.752267 8.752267 8.752267 8.752267 0 0 503 4 25 0 0 0 0 0 0 0 0 0 92 25 122421
16385 16384 t -3574345772349576112 INSERT INTO "tbl001EC6050D17_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 23 0.8965149999999998 0.024362 0.16485 0.03897891304347825 0.03287497637878212 23 93 0 11 2 0 0 0 0 0 0 0 0 70 8 22827
16385 16384 t -855881956657400781 INSERT INTO "tbl001EC6050B5D_2" 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 854 57.39393599999999 0.020558 1.6039649999999999 0.06720601405152227 0.12582938584970374 854 4751 16 1659 13 0 0 0 0 0 0 0 0 2565 1647 6994463
16385 16384 t -5140084181694509333 SELECT * FROM "tbl001EC6056D41_55" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.508799 1.101216 1.407583 1.2543995 0.15318349999999997 200 53 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 8222042603913169088 DROP TABLE IF EXISTS _9e8a015ca66520a82d22483a3852d4a0 0 0 0 0 0 0 1 0.093684 0.093684 0.093684 0.093684 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3761755740308266633 SELECT * FROM "tbl001EC6050B42_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 11 8.350425 0.098549 1.704825 0.7591295454545455 0.6405669513591227 857 109 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3591968514563379269 INSERT INTO "tbl001EC6050BAC_5" 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 9816 469.0519250000007 0.016893 7.451233 0.04778442593724539 0.1388886856014907 9816 59621 84 5286 187 0 0 0 0 0 0 0 0 29477 5026 23035020
16385 16384 t -4783510733089814194 SELECT * FROM "tbl001EC6056FD2_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29656 1618.9112879999948 0.019288 80.63990899999999 0.054589671162665616 0.5896696251762162 29656 88956 12 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8429569105116078946 SELECT last_value, is_called FROM _timescaledb_catalog.continuous_agg_migrate_plan_step_step_id_seq 0 0 0 0 0 0 10 5.875105 0.017824 1.290681 0.5875105 0.3499287687482268 10 2 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5191257956508041001 LOCK TABLE public."tbl001EC6050B5D_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.250324 0.017659 0.077837 0.027813777777777778 0.017812871362383985 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4518131153629829100 COPY public."tbl001EC6050F3C_1" ("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 1 0.134312 0.134312 0.134312 0.134312 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4470575414548301210 LOCK TABLE public."tbl001EC605311A_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.33847000000000005 0.018693 0.054953 0.033847 0.009896436580911333 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2530171485176522136 COPY public."tbl001EC605311A_1" ("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 1277.0750890000002 115.846942 140.808441 127.7075089 8.76656485822575 405010 78 8793 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4520662449324659228 SELECT * FROM "tbl001EC6050F3C_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 12 0.816765 0.025613 0.151715 0.06806374999999999 0.04583091835781641 247 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2029706237083038740 CREATE TABLE IF NOT EXISTS "tbl001EC6053109_3" ( 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 10.759063 10.759063 10.759063 10.759063 0 0 656 2 4 0 0 0 0 0 0 0 0 0 165 3 24422
16385 16384 t -4793303962324751791 SELECT * FROM "tbl001EC6050D16_5" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1944 54.44915200000006 0.006424 2.414659 0.028008823045267493 0.08065210732122562 1943 5822 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9036822488140725505 SELECT * FROM "tbl001EC6050B87_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 12886 495.0020279999992 0.0092 1.4830519999999998 0.03841393977960589 0.02607026530506773 12885 37844 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3432373957691947917 LOCK TABLE public."tbl001EC6050F3C_13" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.037973 0.037973 0.037973 0.037973 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8489274114428293221 INSERT INTO "tbl001EC6050B42_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 565 43.043769000000005 0.01751 4.428999999999999 0.07618366194690264 0.2291884910108045 565 2873 13 1118 13 0 0 0 0 0 0 0 0 1697 1108 4502627
16385 16384 t -8539502166968342979 SELECT * FROM "tbl001EC6050B08_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 17 15.664789999999998 0.39195 7.221349 0.9214582352941177 1.576139272063247 1700 277 0 67 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 217356186539544862 SELECT * FROM "tbl001EC6050E4D_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.613912 0.142421 0.269276 0.20463733333333334 0.05181665453200245 300 93 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4672394109459196850 SELECT * FROM "tbl001EC6053109_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 84 3027.7856819999997 0.610181 1905.682711 36.04506764285714 206.5318196267177 7794 1154690 2253 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5956594550885863276 LOCK TABLE public."tbl001EC6050E0D_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.31187000000000004 0.017825 0.053235 0.031187000000000003 0.01205270414471375 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6544331515718732469 INSERT INTO "tbl001EC6050B87_2" 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 6489 425.7018710000006 0.023883 5.860040000000001 0.06560361704422854 0.13360173908377296 6489 40670 158 7196 631 0 0 0 0 0 0 0 0 19485 6063 30038416
16385 16384 t 8413318537458888627 COPY public."tbl001EC6053CD9_5" ("time", error, lowrange, highrange, "Energy_Consumption_kWh_1", "Real_Power_kW_2") TO stdout 0 0 0 0 0 0 6 31.930222999999998 0.128779 11.770532 5.321703833333333 4.443396763951891 8118 50 50 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 431493393876066088 COPY public."tbl001EC6050E4D_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 10 275.892459 20.240985 35.409603 27.5892459 5.800815661523134 80250 383 597 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1390678842223567199 SELECT tableoid, oid, oprname, oprnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = oprowner) AS rolname, oprkind, oprleft, oprright, oprcode::oid AS oprcode FROM pg_operator 0 0 0 0 0 0 10 105.99982499999999 4.9767 34.544779999999996 10.599982500000001 8.609662201016672 8040 8180 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4541238275682153883 SELECT * FROM "tbl001EC60506E1_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 6 5.480253 0.778317 1.05593 0.9133755 0.09505228705077715 600 50 0 29 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -1111593814357904415 CREATE TABLE _ec02dd316d6eafc4e914a5fe9907570e(cmd_output text) 0 0 0 0 0 0 1 10.525858 10.525858 10.525858 10.525858 0 0 506 6 27 0 0 0 0 0 0 0 0 0 94 27 129183
16385 16384 t -8829657790587594558 COPY (SELECT id, application_name, schedule_interval, max_runtime, max_retries, retry_period, proc_schema, proc_name, owner, scheduled, fixed_schedule, initial_start, hypertable_id, config, check_schema, check_name, timezone FROM _timescaledb_config.bgw_job WHERE id >= 1000) TO stdout 0 0 0 0 0 0 10 4.1110809999999995 0.339804 0.46489 0.41110810000000003 0.04184546603743349 0 596 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7131639136824515388 INSERT INTO "tbl001EC6050BAC_8" 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 9816 517.9968580000019 0.017705000000000002 27.619548 0.05277066605541967 0.4261127720714311 9816 59641 62 5248 172 0 0 0 0 0 0 0 0 29475 5016 23252742
16385 16384 t 8913315146950725505 CREATE TABLE IF NOT EXISTS "tbl001EC6050B87_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 5.716111 5.716111 5.716111 5.716111 0 0 1112 1 1 0 0 0 0 0 0 0 0 0 276 2 36965
16385 16384 t 6952350646382508403 COPY public."tbl001EC6052F1E_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 10 6297.6742269999995 519.02297 778.588672 629.7674227 76.88030941535695 324620 23401 6856 44 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4745718956037393870 SELECT * FROM "tbl001EC6054E88_56" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 11 5.658431 0.09045399999999999 1.426922 0.5144028181818182 0.507146847932416 1100 200 6 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3212800662036744484 SELECT * FROM "tbl001EC6056D41_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.096685 1.045759 1.050926 1.0483425 0.0025834999999999053 200 56 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8533616640008351416 COPY public."tbl001EC605311A_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 10 1640.6094729999998 125.523514 277.831436 164.0609473 52.17892666368463 405000 90 8702 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8201005623832522484 CREATE TABLE IF NOT EXISTS "tbl001EC6050B87_6" ( 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 10.415363 10.415363 10.415363 10.415363 0 0 1146 6 4 0 0 0 0 0 0 0 0 0 283 3 39904
16385 16384 t -1954323238975274296 CREATE TABLE IF NOT EXISTS "tbl001EC6053075_7" ( 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 5.46599 5.46599 5.46599 5.46599 0 0 528 0 2 1 0 0 0 0 0 0 0 0 134 2 15869
16385 16384 t -4492633547483190610 COPY public."tbl001EC6050B5D_52" ("time", error, lowrange, highrange, "Analog_In_1_1", "Analog_In_2_2", "Analog_In_3_3", "Analog_In_4_4", "Pulse_1_5", "Pulse_2_6", "Pulse_3_7", "Pulse_4_8", "Status_register_9", firmware_version_10, "Uptime_Seconds_11", "Pulse_State_Register_12", "Pulse_1_ontime_Sec_sec_13", "Pulse_2_ontime_Sec_sec_14", "Pulse_3_ontime_Sec_sec_15", "Pulse_4_ontime_Sec_sec_16", "Pulse_1_last_minute_change_17", "Pulse_2_last_minute_change_18", "Pulse_3_last_minute_change_19", "Pulse_4_last_minute_change_20") TO stdout 0 0 0 0 0 0 9 17.235351 0.051523 5.277051 1.9150390000000002 1.5441360041379486 3554 93 16 7 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1524143430050448947 COPY _timescaledb_catalog.chunk_index (chunk_id, index_name, hypertable_id, hypertable_index_name) TO stdout 0 0 0 0 0 0 10 0.257081 0.018928 0.059033 0.0257081 0.011235546087752032 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7212637083182251610 CREATE TABLE IF NOT EXISTS "tbl001EC6050BAC_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 11.516289 11.516289 11.516289 11.516289 0 0 733 5 39 1 0 0 0 0 0 0 0 0 134 37 199862
16385 16384 t 584848461390861032 SELECT * FROM "tbl001EC6053075_6" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 13 2.282437 0.013617 0.885295 0.17557207692307691 0.21636091901352864 1011 132 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4712539281863558184 COPY public.dl_inverter_device_data (id, "time", serial_number, device_id, sd_id, "Total kwh (kwh) 99", "kwh Today (kwh) 101") TO stdout 0 0 0 0 0 0 10 14461.228613000001 1322.239062 1544.419276 1446.1228612999998 73.31313571081351 3488440 15 39695 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3175219885308318530 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_17" ( 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.740075 7.740075 7.740075 7.740075 0 0 1196 2 10 0 0 0 0 0 0 0 0 0 288 9 86628
16385 16384 t 5887308124586026126 GRANT SELECT ON TABLE public."tbl001EC605309C_9" TO developer 0 0 0 0 0 0 1 2.942605 2.942605 2.942605 2.942605 0 0 16 5 5 0 0 0 0 0 0 0 0 0 8 5 30487
16385 16384 t -4215296794162806679 SELECT * FROM "tbl001EC6052F1E_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29714 1294.6473999999919 0.022192 8.25179 0.04357028336810924 0.0752464046615299 29714 89124 18 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -8007691438283802768 CREATE TABLE _2af20cc85cf27bee9bcdd5f42eb4c1f8(cmd_output text) 0 0 0 0 0 0 1 7.074632 7.074632 7.074632 7.074632 0 0 502 2 24 0 0 0 0 0 0 0 0 0 93 25 126759
16385 16384 t -3465769031146828275 SELECT * FROM "tbl001EC6056D41_55" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6010 250.10422499999962 0.021781000000000002 2.693498 0.04161467970049912 0.0462344878984583 6010 18024 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8439756449974369982 LOCK TABLE public."tbl001EC6050D05_103" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.32891400000000004 0.018313 0.114398 0.0328914 0.027884304116115217 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2790187372068700242 SELECT * FROM "tbl001EC6050B5D_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 21 18.508233000000004 0.035141 3.1909170000000002 0.8813444285714286 1.0065882738904566 1683 238 17 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5070090015419087186 SELECT rel.relname AS name FROM pg_catalog.pg_class rel WHERE rel.relkind IN ($1,$2,$3,$4) AND rel.relnamespace = $5::oid AND rel.oid = $6::oid 0 0 0 0 0 0 4 0.059007 0.012812 0.017742 0.01475175 0.0018209094396756807 4 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8969534413737125473 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_19" ( 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.556735 7.556735 7.556735 7.556735 0 0 1174 0 12 1 0 0 0 0 0 0 0 0 284 12 105293
16385 16384 t -1096118051576873834 SELECT * FROM "tbl001EC6050F3C_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 166 6.573313000000004 0.010299 1.262963 0.03959827108433736 0.09701306969765186 165 329 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -435439587851619705 SELECT pg_catalog.pg_is_in_recovery() 0 0 0 0 0 0 10 0.073674 0.004987 0.018814 0.0073674 0.003942761879698038 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 462124050827380045 SELECT * FROM "tbl001EC6050D17_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 46 1.0094469999999998 0.008242 0.09855900000000001 0.021944500000000006 0.013985599857726332 45 91 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1292349291430741341 INSERT INTO "tbl001EC6050B87_6" 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 6489 386.70658899999955 0.0252 2.094907 0.05959417306210503 0.09232630375527301 6489 40720 161 7193 608 0 0 0 0 0 0 0 0 19485 6057 30178444
16385 13761 t 6032516833624269358 DROP TABLE IF EXISTS _a908b847722fa1757f671f6dff72b460 0 0 0 0 0 0 1 3.662041 3.662041 3.662041 3.662041 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0