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 -8515388520039940802 SELECT * FROM "tbl001EC6050F3A_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 9 16.474284 0.468707 4.438079999999999 1.830476 1.6075604439481168 900 89 16 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6697749064237325391 CREATE TABLE IF NOT EXISTS "tbl001EC6050C0B_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 6.63966 6.63966 6.63966 6.63966 0 0 919 1 2 0 0 0 0 0 0 0 0 0 231 2 29041
16385 16384 t 1147616880456321454 select $1 0 0 0 0 0 0 12876 85.31328800000007 0.002529 2.5454369999999997 0.006625760173967062 0.040140959604490656 12876 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1925131941256678950 COPY public."tbl001EC6050F3C_11" ("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.113406 0.113406 0.113406 0.113406 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7813956922670189257 SELECT * FROM "tbl001EC6050B87_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 12696 502.4794739999998 0.009829000000000001 11.060923 0.03957777835538749 0.10006659401240925 12695 37274 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7138112801914314736 COPY public."tbl001EC6050F3C_7" ("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.153831 0.153831 0.153831 0.153831 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -9146164936648527847 CREATE TABLE _d66ebbbedcc1b109647008da003a6441(cmd_output text) 0 0 0 0 0 0 1 9.918533 9.918533 9.918533 9.918533 0 0 509 10 30 0 0 0 0 0 0 0 0 0 96 28 150062
16385 16384 t 528332470491693265 INSERT INTO "tbl001EC6053CD9_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 2868 165.02515700000012 0.022899 2.582117 0.05754015237099021 0.1146304623018859 2868 17437 57 3827 59 0 0 0 0 0 0 0 0 8612 3742 16167320
16385 16384 t 4469410350386105843 LOCK TABLE public."tbl001EC6053109_11" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.09114900000000001 0.022978 0.044328 0.030383 0.009866925390752007 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6318586177638953746 SELECT tableoid, oid, amname, amtype, amhandler::pg_catalog.regproc AS amhandler FROM pg_am 0 0 0 0 0 0 10 20.650985000000002 0.898222 4.478457 2.0650985000000004 1.1870711540291299 90 533 17 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7832173538386086072 COPY public."tbl001EC6050F3C_16" ("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.147318 0.147318 0.147318 0.147318 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5906382256541712782 COPY public."tbl001EC6056300_52" ("time", error, lowrange, highrange, "VAB_V_1", "VBC_V_2", "VCA_V_3", "Current_A_A_4", "Current_B_A_5", "Current_C_A_6", "Real_Power_kW_7", "PV_Voltage_V_8", "PV_Current_A_9", "PV_Power_kW_10", "Grid_Frequency_Hz_11", "System_State_12", "Goal_State_13", "Fault_Code_14", "Accumulated_Energy_kWh_15", "R_Matrix_Temp_Degrees_C_16", "L_Matrix_Temp_Degrees_C_17", "Intake_Air_Temperature_Degrees_C_18") TO stdout 0 0 0 0 0 0 10 12686.431788 1154.915453 1897.631174 1268.6431788 213.74949864979567 2140590 218 59710 15 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6156484424927834411 INSERT INTO "tbl001EC6056FD2_52" 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 15066 650.065407 0.014646 6.942157 0.04314784328952609 0.09865577271439908 15066 93220 45 8646 297 0 0 0 0 0 0 0 0 45239 7966 39047954
16385 16384 t -5665416323045123137 COPY public."tbl001EC605311A_3" ("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 1273.665496 113.113369 141.334066 127.36654959999998 9.268090539853334 405010 95 8733 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -671103341530859201 SELECT * FROM "tbl001EC6053075_6" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1602 31.234725999999988 0.0062380000000000005 0.17703400000000002 0.01949733208489388 0.010063282581205564 1601 3994 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7404312500466120700 SELECT provider, label FROM pg_catalog.pg_shseclabel WHERE classoid = $1::pg_catalog.regclass AND objoid = $2 0 0 0 0 0 0 10 0.078907 0.006304 0.009492 0.007890700000000002 0.0009334975147262044 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1348311984683174184 SELECT * FROM "tbl001EC6053075_54" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 8 2.162814 0.026506 0.854896 0.27035175 0.24399453705090918 608 101 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -766830977261832433 INSERT INTO "tbl001EC6050B5D_1" 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 842 57.063598999999925 0.018715 1.397014 0.06777149524940626 0.12226726122263536 842 4694 18 1641 18 0 0 0 0 0 0 0 0 2529 1616 7041660
16385 16384 t 8679524522967577531 LOCK TABLE public."tbl001EC6050D16_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.14518899999999998 0.017192 0.03684 0.024198166666666666 0.00775950813339494 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6321992910413967866 INSERT INTO "tbl001EC6050B42_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 552 39.817029999999995 0.019457 2.8517740000000003 0.07213230072463775 0.17506994546716734 552 2790 15 1095 12 0 0 0 0 0 0 0 0 1658 1082 4442744
16385 16384 t 1756723268131439378 INSERT INTO "tbl001EC6050F3C_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 70 3.276786 0.026224 0.220557 0.04681122857142857 0.02706292432048552 70 281 0 139 2 0 0 0 0 0 0 0 0 211 136 194060
16385 16384 t 8737305739057262910 LOCK TABLE public."tbl001EC6056FD2_54" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 1.365387 0.017037 0.760135 0.13653869999999999 0.23562981058391147 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6386363180368678463 LOCK TABLE public."tbl001EC6053109_7" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.075461 0.018563 0.03451 0.025153666666666668 0.006797714632302699 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7126306129629372151 CREATE TABLE IF NOT EXISTS "tbl001EC6050BAC_9" ( 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 6.21807 6.21807 6.21807 6.21807 0 0 526 0 0 0 0 0 0 0 0 0 0 0 133 1 14988
16385 16384 t -9184683826705905035 SELECT * FROM "tbl001EC6050F3C_54" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 140 4.485455999999998 0.014367 1.279051 0.03203897142857144 0.10679719617453463 139 277 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2603265693240875346 SELECT *, (case pg_is_in_recovery() when $1 then pg_last_wal_receive_lsn() else pg_current_wal_lsn() end) AS pg_current_wal_lsn, (case pg_is_in_recovery() when $2 then pg_wal_lsn_diff(pg_last_wal_receive_lsn(), pg_lsn($3))::float else pg_wal_lsn_diff(pg_current_wal_lsn(), pg_lsn($4))::float end) AS pg_current_wal_lsn_bytes, (case pg_is_in_recovery() when $5 then pg_wal_lsn_diff(pg_last_wal_receive_lsn(), replay_lsn)::float else pg_wal_lsn_diff(pg_current_wal_lsn(), replay_lsn)::float end) AS pg_wal_lsn_diff FROM pg_stat_replication 0 0 0 0 0 0 118739 12320.547627999804 0.039757 18.494588999999998 0.10376159162532927 0.17328065675880602 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5721938458941409627 SELECT * FROM "tbl001EC6053113_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 1.912614 0.707211 1.205403 0.956307 0.24909599999999998 200 105 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7415312029009403757 COPY public."tbl001EC6053CD9_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 6 53.07885 0.418795 15.426488 8.846475000000002 6.44528349415294 8118 101 68 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6767376687663829001 SELECT * FROM "tbl001EC6050D06_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 7 9.536955 0.13309300000000002 6.994403 1.3624221428571428 2.3386413153497254 700 812 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -344862433477869160 INSERT INTO "tbl001EC6050D06_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 1651 103.98710000000018 0.018221 1.9439769999999998 0.06298431253785577 0.12013538298355796 1651 9814 45 2640 38 0 0 0 0 0 0 0 0 4958 3212 12964243
16385 16384 t -8649352417678043315 CREATE TABLE IF NOT EXISTS "tbl001EC6053075_51" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 8.239034 8.239034 8.239034 8.239034 0 0 1111 4 5 0 0 0 0 0 0 0 0 0 268 4 44623
16385 16384 t 6580032306928099853 COPY public."tbl001EC6050D16_7" ("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 606.750661 90.553808 118.292124 101.12511016666667 9.35756921403209 399188 463 2126 63 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5154023323298851465 COPY public."tbl001EC6050B87_2" ("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 336.294082 1.889601 72.292232 37.36600911111111 24.017989696112473 27378 798 1747 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8838362926510110960 INSERT INTO "tbl001EC6056D41_55" 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 3013 203.55351899999968 0.021710999999999998 2.2203589999999997 0.06755841984732844 0.09551719891466204 3013 20166 30 5971 251 0 0 0 0 0 0 0 0 9048 5557 25405008
16385 16384 t 1205527832959063458 SELECT * FROM "tbl001EC6050F42_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 146 6.416636000000002 0.007859 0.640653 0.0439495616438356 0.057964302573643905 145 289 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4362494592698048597 CREATE TABLE IF NOT EXISTS "tbl001EC6050C0B_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 13.813663 13.813663 13.813663 13.813663 0 0 737 6 41 1 0 0 0 0 0 0 0 0 134 37 171442
16385 16384 t -350276456921446411 SELECT at.attname, at.attnum, ty.typname FROM pg_catalog.pg_attribute at LEFT JOIN pg_catalog.pg_type ty ON (ty.oid = at.atttypid) JOIN pg_catalog.pg_class as cl ON cl.oid=AT.attrelid JOIN pg_catalog.pg_namespace as nsp ON nsp.oid=cl.relnamespace WHERE cl.relname = $1 AND nsp.nspname=$2 AND attnum = ANY ( (SELECT con.conkey FROM pg_catalog.pg_class rel LEFT OUTER JOIN pg_catalog.pg_constraint con ON con.conrelid=rel.oid JOIN pg_catalog.pg_namespace as nsp ON nsp.oid=REL.relnamespace AND con.contype=$3 WHERE rel.relkind IN ($4,$5,$6, $7) AND rel.relname = $8 AND nsp.nspname=$9 )::oid[]) 0 0 0 0 0 0 2 0.291138 0.086993 0.204145 0.145569 0.058575999999999996 4 46 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8891863587933273823 SELECT * FROM "tbl001EC6050B5D_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1610 45.610261999999956 0.0059819999999999995 2.135978 0.028329355279503116 0.08427167520695682 1609 4049 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1912963454269304371 LOCK TABLE public."tbl001EC6050F3C_18" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.020224 0.020224 0.020224 0.020224 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5601425196814916798 SELECT * FROM "tbl001EC6053093_54" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29288 1222.9311689999952 0.021225 3.9124140000000005 0.04175536632750615 0.056864613243442524 29288 117119 33 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1083959216749029324 SELECT * FROM "tbl001EC6053075_60" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1602 33.899819 0.010816 0.30337000000000003 0.021160935705368283 0.016400039627368638 1601 3994 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3556529206787501542 SELECT l.oid, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = l.lomowner) AS rolname, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(l.lomacl,pg_catalog.acldefault($1,l.lomowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,l.lomowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS lomacl, (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,l.lomowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(l.lomacl,pg_catalog.acldefault($6,l.lomowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) AS rlomacl, $7 AS initlomacl, $8 AS initrlomacl FROM pg_largeobject_metadata l LEFT JOIN pg_init_privs pip ON (l.oid = pip.objoid AND pip.classoid = $9::regclass AND pip.objsubid = $10) 0 0 0 0 0 0 10 0.09134300000000001 0.008333 0.010189 0.009134300000000001 0.0006154156400352527 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2190513480015438458 SELECT * FROM "tbl001EC6056300_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29330 1760.3829979999987 0.032705 12.777135 0.06001987719058991 0.09707651464932486 29330 117286 34 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9146034279553306384 SELECT last_value, is_called FROM public.dl_meter_device_data_id_seq 0 0 0 0 0 0 10 6.512602000000001 0.578026 0.7523610000000001 0.6512602000000001 0.059181437182278716 10 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2631945879788793805 INSERT INTO "tbl001EC6050E4D_81" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 5023 582.7742710000001 0.019018999999999998 4.121541000000001 0.11602115687835969 0.24591832374257447 5023 32019 476 7115 211 0 0 0 0 0 0 0 0 15083 6489 29973932
16385 16384 t -10637612914751176 SELECT pg_database_size($1) 0 0 0 0 0 0 708710 3436389.9257983947 0.597112 191.038768 4.84879559452797 5.012386531904744 708710 2480486 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1663206667411303115 INSERT INTO "tbl001EC6052F1E_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 15068 1040.2443230000003 0.018701 7.360646999999999 0.0690366553623576 0.14458181193909583 15068 94774 289 10634 1461 0 0 0 0 0 0 0 0 45246 7962 44996156
16385 16384 t 5877624454313594148 SELECT a.attnum, a.attname, a.atttypmod, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid, a.atttypmod) AS atttypname, array_to_string(a.attoptions, $1) AS attoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE $2 END AS attcollation, a.attcompression AS attcompression, pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(option_name) || $3 || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), $4) AS attfdwoptions, a.attidentity, CASE WHEN a.atthasmissing AND NOT a.attisdropped THEN a.attmissingval ELSE $5 END AS attmissingval, a.attgenerated FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = $6::pg_catalog.oid AND a.attnum > $7::pg_catalog.int2 ORDER BY a.attnum 0 0 0 0 0 0 1959 907.9811759999976 0.042429 9.696138999999999 0.46349217764165435 0.6658181930265474 87416 85874 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8964275897284179474 INSERT INTO "tbl001EC6050D30_3" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 8962 376.8362409999996 0.016143 5.651797 0.04204823041731741 0.10558114344929502 8962 54933 27 2577 675 0 0 0 0 0 0 0 0 26911 1825 14132343
16385 16384 t 6205127235980390441 LOCK TABLE public."tbl001EC6056D48_55" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.300713 0.020159 0.044731 0.0300713 0.006494145071524042 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -8046268409171700158 CREATE TABLE _d77af18ac3c1ce7e583ede0a8f904197(cmd_output text) 0 0 0 0 0 0 1 7.7319 7.7319 7.7319 7.7319 0 0 501 5 24 0 0 0 0 0 0 0 0 0 92 25 118709
16385 16384 t -7149998903834283460 CREATE TABLE IF NOT EXISTS "tbl001EC6050B87_7" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 6.392176 6.392176 6.392176 6.392176 0 0 1187 4 6 0 0 0 0 0 0 0 0 0 281 4 44791
16385 16384 t -1762758732810530806 SELECT * FROM "tbl001EC60537AE_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.19921699999999998 0.19921699999999998 0.19921699999999998 0.19921699999999998 0 100 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4562635154046073478 LOCK TABLE public."tbl001EC6050F42_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.018768 0.018768 0.018768 0.018768 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1328844990116483517 SELECT * FROM "tbl001EC6050F3C_17" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 140 5.776682000000001 0.01821 1.281835 0.04126201428571429 0.1067455178722464 139 277 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1353058424408335585 LOCK TABLE public."tbl001EC6050B87_7" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.23829500000000003 0.017191 0.044906 0.026477222222222225 0.010442926811725808 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3196603689379148377 SELECT * FROM pg_stat_database_conflicts 0 0 0 0 0 0 178818 1099449.395818005 0.065527 207.385693 6.14842686876034 5.744199445032708 715272 178818 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7259059839401016012 SELECT * FROM "tbl001EC6050F3A_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 21 37.187565000000006 0.15940400000000002 9.057572 1.7708364285714289 2.384123556747418 2100 274 22 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2570909912959527909 COPY public."tbl001EC6050B5D_3" ("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 9 6.621848 0.034782 1.83918 0.7357608888888889 0.5856831925952316 3548 27 4 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7129965142229186101 SELECT datid ,datname ,numbackends ,xact_commit ,xact_rollback ,blks_read ,blks_hit ,tup_returned ,tup_fetched ,tup_inserted ,tup_updated ,tup_deleted ,conflicts ,temp_files ,temp_bytes ,deadlocks ,blk_read_time ,blk_write_time ,stats_reset FROM pg_stat_database 0 0 0 0 0 0 58487 280184.3421260012 0.165216 106.864029 4.790540498332983 5.739480944678354 292435 58487 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5357413121830611143 SELECT * FROM "tbl001EC6050E0D_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 10 4.750085 0.16267 1.839876 0.4750085000000001 0.5100363405704048 1000 113 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5299266603066551248 SELECT * FROM "tbl001EC6050B87_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 12696 446.7768719999996 0.01472 1.8908289999999999 0.035190364839319595 0.027633772422189423 12695 37273 1 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8951947008961658025 SELECT * FROM "tbl001EC6050B08_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2092 109.49667599999997 0.020151000000000002 19.379048 0.052340667304015195 0.4465781829161353 2092 6240 36 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9117855755238782286 SELECT * FROM "tbl001EC6050B42_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 7 15.756939 0.505538 4.148168 2.2509912857142855 1.4595460487106173 700 73 16 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8347632181829244141 INSERT INTO "tbl001EC6053113_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15042 1011.9155679999967 0.01865 4.190401 0.0672726743784067 0.12634566758937857 15042 94531 321 10569 1426 0 0 0 0 0 0 0 0 45168 7902 44534144
16385 16384 t 6208962007635167111 CREATE TABLE IF NOT EXISTS "tbl001EC6053CD9_5" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Energy_Consumption_kWh_1" DOUBLE PRECISION DEFAULT NULL, "Real_Power_kW_2" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 4.722887 4.722887 4.722887 4.722887 0 0 415 0 0 0 0 0 0 0 0 0 0 0 105 1 11064
16385 16384 t 3228175474821286670 LOCK TABLE public."tbl001EC6050B5D_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.29401900000000003 0.024166 0.049192 0.032668777777777776 0.007118824400103306 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3855621884648895582 SELECT * FROM "tbl001EC6056D47_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 3.4817080000000002 0.929502 1.2934050000000001 1.1605693333333333 0.1639988691105995 300 154 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3008799328338101810 LOCK TABLE public."tbl001EC6050F3A_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.301406 0.017504 0.058717 0.0301406 0.012978449038309624 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8952720130018122930 INSERT INTO "tbl001EC6053093_55" 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 15068 843.4276610000029 0.020566 3.7326859999999997 0.05597475849482326 0.07897568964691613 15068 96140 36 10250 1617 0 0 0 0 0 0 0 0 45246 7642 42720410
16385 16384 t -802287773578263999 SELECT * FROM "tbl001EC6056D48_55" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29194 1166.0303689999985 0.02196 6.034558 0.03994075388778504 0.047862999024581944 29194 87576 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4960955850395131556 CREATE TABLE IF NOT EXISTS "tbl001EC6050BAC_6" ( 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.449209 5.449209 5.449209 5.449209 0 0 537 1 1 0 0 0 0 0 0 0 0 0 136 2 15263
16385 16384 t 3696515394032386122 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_4" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 6.85263 6.85263 6.85263 6.85263 0 0 1151 1 7 1 0 0 0 0 0 0 0 0 280 6 61437
16385 16384 t -361368321428642523 COPY public."tbl001EC6050189_32" ("time", error, lowrange, highrange, "Volts_A_N_Volts_1", "Volts_B_N_Volts_2", "Volts_C_N_Volts_3", "Volts_A_B_Volts_4", "Volts_B_C_Volts_5", "Volts_C_A_Volts_6", "Amps_A_Amps_7", "Amps_B_Amps_8", "Amps_C_Amps_9", "Watts_3_Ph_total_kW_10", "VARs_3_Ph_total_kVAR_11", "VAs_3_Ph_total_kVA_12", "Power_Factor_3_Ph_total_13", "Frequency_Hz_14", "Neutral_Current_Amps_15", "W_hours_Received_kWh_16", "W_hours_Delivered_kWh_17", "W_hours_Net_kWh_18", "W_hours_Total_kWh_19", "VAR_hours_Positive_kVARh_20", "VAR_hours_Negative_kVARh_21", "VAR_hours_Net_kVARh_22", "VAR_hours_Total_kVARh_23", "VA_hours_Total_kVAh_24", "Amps_A_Average_Amps_25", "Amps_B_Average_Amps_26", "Amps_C_Average_Amps_27", "Positive_Watts_3_Ph_Average_kW_28", "Positive_VARs_3_Ph_Average_kVAR_29", "Negative_Watts_3_Ph_Average_kW_30", "Negative_VARs_3_Ph_Average_kVAR_31", "VAs_3_Ph_Average_kVA_32", "Positive_PF_3_Ph_Average_33", "Negative_PF_3_Ph_Average_34", "Volts_A_N_Min_Volts_35", "Volts_B_N_Min_Volts_36", "Volts_C_N_Min_Volts_37", "Volts_A_B_Min_Volts_38", "Volts_B_C_Min_Volts_39", "Volts_C_A_Min_Volts_40", "Amps_A_Min_Avg_Demand_Amps_41", "Amps_B_Min_Avg_Demand_Amps_42", "Amps_C_Min_Avg_Demand_Amps_43", "Positive_Watts_3_Ph_Min_Avg_Demand_kW_44", "Positive_VARs_3_Ph_Min_Avg_Demand_kVAR_45", "Negative_Watts_3_Ph_Min_Avg_Demand_kW_46", "Negative_VARs_3_Ph_Min_Avg_Demand_kVAR_47", "VAs_3_Ph_Min_Avg_Demand_kVA_48", "Positive_PF_3_Ph_Min_Avg_Demand_49", "Negative_PF_3_Ph_Min_Avg_Demand_50", "Frequency_Min_Hz_51", "Volts_A_N_Max_Volts_52", "Volts_B_N_Max_Volts_53", "Volts_C_N_Max_Volts_54", "Volts_A_B_Max_Volts_55", "Volts_B_C_Max_Volts_56", "Volts_C_A_Max_Volts_57", "Amps_A_Max_Avg_Demand_Amps_58", "Amps_B_Max_Avg_Demand_Amps_59", "Amps_C_Max_Avg_Demand_Amps_60", "Positive_Watts_3_Ph_Max_Avg_Demand_kW_61", "Positive_VARs_3_Ph_Max_Avg_Demand_kVAR_62", "Negative_Watts_3_Ph_Max_Avg_Demand_kW_63", "Negative_VARs_3_Ph_Max_Avg_Demand_kVAR_64", "VAs_3_Ph_Max_Avg_Demand_kVA_65", "Positive_PF_3_Ph_Max_Avg_Demand_66", "Negative_PF_3_Ph_Max_Avg_Demand_67", "Frequency_Max_Hz_68", "Volts_A_N_THD_69", "Volts_B_N_THD_70", "Volts_C_N_THD_71", "Amps_A_THD_72", "Amps_B_THD_73", "Amps_C_THD_74", "Phase_A_Current_0th_harmonic_magnitude_75", "Phase_A_Current_1st_harmonic_magnitude_76", "Phase_A_Current_2nd_harmonic_magnitude_77", "Phase_A_Current_3rd_harmonic_magnitude_78", "Phase_A_Current_4th_harmonic_magnitude_79", "Phase_A_Current_5th_harmonic_magnitude_80", "Phase_A_Current_6th_harmonic_magnitude_81", "Phase_A_Current_7th_harmonic_magnitude_82", "Phase_A_Voltage_0th_harmonic_magnitude_83", "Phase_A_Voltage_1st_harmonic_magnitude_84", "Phase_A_Voltage_2nd_harmonic_magnitude_85", "Phase_A_Voltage_3rd_harmonic_magnitude_86", "Phase_B_Current_0th_harmonic_magnitude_87", "Phase_B_Current_1st_harmonic_magnitude_88", "Phase_B_Current_2nd_harmonic_magnitude_89", "Phase_B_Current_3rd_harmonic_magnitude_90", "Phase_B_Current_4th_harmonic_magnitude_91", "Phase_B_Current_5th_harmonic_magnitude_92", "Phase_B_Current_6th_harmonic_magnitude_93", "Phase_B_Current_7th_harmonic_magnitude_94", "Phase_B_Voltage_0th_harmonic_magnitude_95", "Phase_B_Voltage_1st_harmonic_magnitude_96", "Phase_B_Voltage_2nd_harmonic_magnitude_97", "Phase_B_Voltage_3rd_harmonic_magnitude_98", "Phase_C_Current_0th_harmonic_magnitude_99", "Phase_C_Current_1st_harmonic_magnitude_100", "Phase_C_Current_2nd_harmonic_magnitude_101", "Phase_C_Current_3rd_harmonic_magnitude_102", "Phase_C_Current_4th_harmonic_magnitude_103", "Phase_C_Current_5th_harmonic_magnitude_104", "Phase_C_Current_6th_harmonic_magnitude_105", "Phase_C_Current_7th_harmonic_magnitude_106", "Phase_C_Voltage_0th_harmonic_magnitude_107", "Phase_C_Voltage_1st_harmonic_magnitude_108", "Phase_C_Voltage_2nd_harmonic_magnitude_109", "Phase_C_Voltage_3rd_harmonic_magnitude_110", "Angle_Phase_A_Current_Degrees_111", "Angle_Phase_B_Current_Degrees_112", "Angle_Phase_C_Current_Degrees_113", "Angle_Volts_A_B_Degrees_114", "Angle_Volts_B_C_Degrees_115", "Angle_Volts_C_A_Degrees_116") TO stdout 0 0 0 0 0 0 9 100.114579 0.429781 21.651467 11.123842111111111 6.975856546487519 3561 281 225 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -155908022337956364 SELECT * FROM "tbl001EC6056FD2_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.595137 0.16927899999999999 0.425858 0.2975685 0.12828950000000003 200 118 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4199849316459484872 DISCARD ALL 0 0 0 0 0 0 3613364 94724.99498500764 0.008329 149.909952 0.026215182025668762 0.1672626975463534 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8652130620705086090 LOCK TABLE public."tbl001EC6050F3A_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 1.467808 0.019546 1.228498 0.14678080000000004 0.36067644840460544 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -651826919375886170 INSERT INTO "tbl001EC6050B87_3" 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 6394 432.05229000000026 0.023095 2.350257 0.06757151861119833 0.1246420390524834 6394 40075 205 7131 589 0 0 0 0 0 0 0 0 19201 6019 29936025
16385 16384 t 3360188281562576558 SELECT * FROM "tbl001EC6050D21_80" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 2.6989080000000003 0.717149 1.249019 0.899636 0.24713306852382186 300 72 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8135777336684366393 SELECT * FROM "tbl001EC6053019_53" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 9 3.927219 0.022713 0.570368 0.4363576666666667 0.15646901718160622 803 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1698795857077071261 SELECT * FROM "tbl001EC6050E4D_81" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 4.358727 0.67696 2.172027 1.452909 0.6116800119577773 300 140 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5398647473872158721 SELECT * FROM "tbl001EC605311A_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 5936 147.15378 0.011367 2.1968199999999998 0.024790057277628102 0.04367155741113084 5936 17800 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3772327304764377348 SELECT t.tgname, t.tgfoid::pg_catalog.regproc AS tgfname, pg_catalog.pg_get_triggerdef(t.oid, $1) AS tgdef, t.tgenabled, t.tableoid, t.oid, t.tgisinternal FROM pg_catalog.pg_trigger t LEFT JOIN pg_catalog.pg_trigger u ON u.oid = t.tgparentid WHERE t.tgrelid = $2::pg_catalog.oid AND (NOT t.tgisinternal OR t.tgenabled != u.tgenabled) 0 0 0 0 0 0 10 8.185785 0.663986 1.259842 0.8185785 0.20223632998660254 10 120 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -278428233097029137 SELECT * FROM "tbl001EC6056300_50" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29330 859.6660340000045 0.015662 46.635176 0.029310127309921604 0.277169899403244 29330 117285 35 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8577855113613826634 LOCK TABLE public.dl_inverter_device_data IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.40558700000000003 0.023691 0.085856 0.0405587 0.02268313245144947 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5899020838019676558 LOCK TABLE public."tbl001EC6056D41_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.259006 0.018299 0.062009 0.0259006 0.012331847308493567 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2278296749139447712 CREATE TABLE IF NOT EXISTS "tbl001EC6053019_53" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Volts_AB_Volts_1" DOUBLE PRECISION DEFAULT NULL, "Volts_BC_Volts_2" DOUBLE PRECISION DEFAULT NULL, "Volts_CA_Volts_3" DOUBLE PRECISION DEFAULT NULL, "Volts_LL_Average_Volts_4" DOUBLE PRECISION DEFAULT NULL, "Volts_A_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Volts_B_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Volts_C_Volts_7" DOUBLE PRECISION DEFAULT NULL, "Volts_LN_Average_Volts_8" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Amps_9" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Amps_10" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Amps_11" DOUBLE PRECISION DEFAULT NULL, "Frequency_Hz_12" DOUBLE PRECISION DEFAULT NULL, "KW_A_kW_13" DOUBLE PRECISION DEFAULT NULL, "KW_B_kW_14" DOUBLE PRECISION DEFAULT NULL, "KW_C_KW_15" DOUBLE PRECISION DEFAULT NULL, "PF_Sign_A_PF_16" DOUBLE PRECISION DEFAULT NULL, "PF_Sign_B_PF_17" DOUBLE PRECISION DEFAULT NULL, "PF_Sign_C_PF_18" DOUBLE PRECISION DEFAULT NULL, "Volt_Unbalance_19" DOUBLE PRECISION DEFAULT NULL, "Current_Unbalance_20" DOUBLE PRECISION DEFAULT NULL, "Delivered_Energy_kWh_21" DOUBLE PRECISION DEFAULT NULL, "Received_Energy_kWh_22" DOUBLE PRECISION DEFAULT NULL, "Real_Power_kW_23" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_PF_24" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_kVAR_25" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 10.141104 10.141104 10.141104 10.141104 0 0 926 2 51 2 0 0 0 0 0 0 0 0 172 47 253436
16385 16384 t -6046448516502485600 INSERT INTO "tbl001EC6050BAC_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 9626 523.5836179999993 0.017786 15.827875000000002 0.054392646789943905 0.23186806055745618 9626 58693 113 5559 317 0 0 0 0 0 0 0 0 28905 5157 24364459
16385 16384 t 7912770291323265081 SELECT * FROM "tbl001EC6050B08_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 9 14.705986 1.0991 2.914765 1.6339984444444446 0.5740833455193517 900 147 0 47 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2162775994501661309 SELECT * FROM "tbl001EC6056D47_9" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 3.482795 1.5892009999999999 1.893594 1.7413975 0.15219650000000007 200 116 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7682482127983211317 COPY public."tbl001EC6050F3C_13" ("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.110203 0.110203 0.110203 0.110203 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2909072935829659850 SELECT * FROM "tbl001EC6050BAC_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 19154 514.7684809999975 0.00594 38.007600000000004 0.026875246998015977 0.2919303550023845 19153 56652 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4628838447869404653 LOCK TABLE public."tbl001EC6050D16_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.15696300000000002 0.017338 0.043306 0.0261605 0.010135634444046082 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3442726470276445912 SELECT oid, pg_catalog.format_type(oid, $2) AS typname FROM pg_catalog.pg_type WHERE oid = ANY($1) ORDER BY oid 0 0 0 0 0 0 1 0.035169 0.035169 0.035169 0.035169 0 4 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4543281955003066313 COPY public."tbl001EC6053109_1" ("time", error, lowrange, highrange, "Net_Energy_kWh_1", "Import_Energy_kWh_2", "Export_Energy_kWh_3", "Real_Power_kW_4", "Reactive_Power_kVAR_5", "Apparent_Power_kVA_6", "Voltage_Average_V_7", "Voltage_L_L_Average_V_8", "Current_Average_A_9", "Total_Power_Factor_10", "Frequency_Hz_11", "Voltage_A_V_12", "Voltage_B_V_13", "Voltage_C_V_14", "Voltage_AB_V_15", "Voltage_BC_V_16", "Votlage_AC_V_17", "Current_A_A_18", "Current_B_A_19", "Current_C_A_20", "Power_Factor_A_21", "Power_Factor_B_22", "Power_Factor_C_23", "Import_Energy_Phase_A_kWh_24", "Import_Energy_Phase_B_kWh_25", "Import_Energy_Phase_C_kWh_26", "Export_Energy_Phase_A_kWh_27", "Export_Energy_Phase_B_kWh_28", "Export_Energy_Phase_C_kWh_29") TO stdout 0 0 0 0 0 0 10 6873.232637 386.669322 860.127974 687.3232636999999 118.8634003508935 457053 2970 19051 36 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4755594565471483866 SELECT * FROM "tbl001EC6056300_50" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.49635100000000004 0.49635100000000004 0.49635100000000004 0.49635100000000004 0 100 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1818291803630412711 SELECT * FROM "tbl001EC6053093_55" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29288 1226.0985259999952 0.022779999999999998 4.199442 0.04186351154056275 0.056979428328169324 29288 117118 34 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5252035872888520135 LOCK TABLE public."tbl001EC6050D16_6" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.458531 0.018262 0.34737 0.07642183333333334 0.12124284568091248 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 6775835418052206827 DROP TABLE IF EXISTS _de27fadfbf2fd0a1680b9a5f0e1ef373 0 0 0 0 0 0 1 0.886649 0.886649 0.886649 0.886649 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4343719152629286573 SELECT * FROM "tbl001EC6056D48_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29194 1174.4945929999963 0.021846 2.4359 0.04023068414742755 0.03239045824297949 29194 87576 6 1 0 0 0 0 0 0 0 0 0 0 0 0