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 tbl001EC6050D15_10 tbl001EC6050D15_11 tbl001EC6050D15_12 tbl001EC6050D15_7 tbl001EC6050D15_8 tbl001EC6050D15_9 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_2 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 1340390920085549112 SELECT * FROM "tbl001EC6050B87_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 36 108.71845499999999 0.45072 9.187782 3.019957083333334 2.534214489659637 3349 10330 94 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8095371386334089592 SELECT * FROM "tbl001EC6050E4D_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 10224 283.5959240000002 0.014931 5.218069 0.02773825547730826 0.0702238375187596 10224 30658 14 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5213747156078326986 SELECT * FROM "dl_device_type" ORDER BY "id" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 12 4.104540999999999 0.016644 0.787324 0.34204508333333333 0.3268861891386303 36 6 6 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7163594200886564484 SELECT * FROM "tbl001EC6056300_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.43579399999999996 0.43579399999999996 0.43579399999999996 0.43579399999999996 0 100 29 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -494030042269621887 SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace 0 0 0 0 0 0 10 0.9215419999999999 0.069503 0.16768 0.09215419999999999 0.027075282147375673 30 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5421989890966319340 COPY public."tbl001EC6056FD2_55" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 10 953.4421910000001 59.597595 164.753976 95.3442191 29.271241136098993 226930 11 4577 18 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8980699319365045175 SELECT r.oid, r.rolname, r.rolcanlogin, r.rolsuper, d.description FROM pg_catalog.pg_roles r LEFT JOIN pg_catalog.pg_shdescription d ON d.objoid = r.oid AND d.classoid = $1::regclass ORDER BY r.rolcanlogin, r.rolname 0 0 0 0 0 0 1 0.795557 0.795557 0.795557 0.795557 0 15 6 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -870956687525044168 SELECT * FROM "tbl001EC6050189_6" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1742 102.49834100000021 0.017945 3.596721 0.058839460964408744 0.1642582149193761 1741 4397 19 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2576064766088356062 SELECT * FROM "tbl001EC6050B42_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 14.948047999999998 0.11376 2.86433 0.9342529999999999 1.0571541226930914 857 267 15 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8261631252587182898 SELECT * FROM "tbl001EC6050B87_103" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 13190 536.2216270000022 0.007964 0.83611 0.04065364874905232 0.021652043260897345 13189 38756 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 4288579479466841002 CREATE TABLE _2aa7106d5df56d0970ddefac4806b437(cmd_output text) 0 0 0 0 0 0 1 11.54751 11.54751 11.54751 11.54751 0 0 502 4 24 0 0 0 0 0 0 0 0 0 93 25 125723
16385 16384 t 5860892946985947374 INSERT INTO "tbl001EC60506E1_10" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15557 508.1781600000025 0.014377 10.442034 0.03266556276917119 0.12745421788113823 15557 95610 24 2257 159 0 0 0 0 0 0 0 0 46713 2100 12098155
16385 16384 t 5364871300399187462 LOCK TABLE public."tbl001EC6056D41_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.24522700000000003 0.017231 0.046527 0.0245227 0.008037045054620509 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4112752033982950273 SELECT last_value, is_called FROM _timescaledb_catalog.hypertable_id_seq 0 0 0 0 0 0 10 4.980569 0.016911000000000002 0.690121 0.4980568999999999 0.24076876859445454 10 2 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3551099123378087474 SELECT * FROM "tbl001EC6050D21_81" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 10222 336.55218500000046 0.019534999999999997 3.059178 0.0329242990608493 0.05257653491791039 10222 30649 17 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8661985702514487758 CREATE TABLE IF NOT EXISTS "tbl001EC6050B42_2" ( 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.842775 5.842775 5.842775 5.842775 0 0 537 2 5 0 0 0 0 0 0 0 0 0 138 3 16926
16385 16384 t -3781394431702893341 SELECT * FROM "tbl001EC6056D47_50" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30046 1210.2555169999973 0.02126 4.822479 0.04028008776542636 0.04562070379576273 30046 90134 4 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7283306641897601433 COPY public."tbl001EC6050E0D_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 43.660112 1.699175 6.570814 4.3660112 1.299916968511743 10190 82 110 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -902895239498642807 COPY public."tbl001EC6050B08_2" ("time", error, lowrange, highrange, "Vln_a_Volts_1", "Vln_b_Volts_2", "Vln_c_Volts_3", "Vln_ave_Volts_4", "Vll_ab_Volts_5", "Vll_bc_Volts_6", "Vll_ca_Volts_7", "Vll_ave_Volts_8", "I_a_Amps_9", "I_b_Amps_10", "I_c_Amps_11", "I_ave_Amps_12", "V_unbal_13", "I_unbal_14", "Freq_Hz_15", "I4_Amps_16", "kW_a_kW_17", "kW_b_kW_18", "kW_c_kW_19", "kW_tot_kW_20", "kVAR_a_kVAR_21", "kVAR_b_kVAR_22", "kVAR_c_kVAR_23", "kVAR_tot_kVAR_24", "kVA_a_kVA_25", "kVA_b_kVA_26", "kVA_c_kVA_27", "kVA_tot_kVA_28", "PF_sign_a_29", "PF_sign_b_30", "PF_sign_c_31", "PF_sign_tot_32", "Vll_ave_mx_Volts_33", "I_ave_mx_Amps_34", "kW_tot_mx_kW_35", "kVAR_tot_mx_kVAR_36", "kVA_tot_mx_kVA_37", "Freq_mx_Hz_38", "Vll_ave_mn_Volts_39", "I_ave_mn_Amps_40", "Freq_mn_Hz_41", "kW_sd_del_rec_kW_42", "kVA_sd_del_rec_kVA_43", "kVAR_sd_del_rec_kVAR_44", "kW_sd_mx_d_r_kW_45", "kVA_sd_mx_d_r_kVA_46", "kVAR_sd_mx_d_r_kVAR_47", "Phase_Rev_48", "kWh_del_kWh_49", "kWh_rec_kWh_50", "kWh_del_rec_kWh_51", "kWh_del_rec_kWh_52", "kVARh_del_kVARh_53", "kVARh_rec_kVARh_54", "kVARh_del_rec_kVARh_55", "kVARh_del_rec_kVARh_56", "kVAh_del_rec_kVAh_57", "V1_THD_mx_58", "V2_THD_mx_59", "V3_THD_mx_60", "I1_THD_mx_61", "I2_THD_mx_62", "I3_THD_mx_63", unused_64) TO stdout 0 0 0 0 0 0 10 2164.0520420000003 117.462847 319.635901 216.40520420000001 61.12337135425995 154835 1460 9692 418 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3886791404132854728 SELECT db.oid as did, db.datname, db.datallowconn, pg_encoding_to_char(db.encoding) AS serverencoding, has_database_privilege(db.oid, $1) as cancreate, datistemplate FROM pg_catalog.pg_database db WHERE db.datname = current_database() 0 0 0 0 0 0 4 0.072937 0.016101999999999998 0.020194 0.01823425 0.0018524020048304862 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3504717372380556223 COPY public."tbl001EC6050F3A_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 45.387985 3.049814 5.981385 4.5387985 0.883641084904867 11160 32 172 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8357525653122270736 CREATE TABLE IF NOT EXISTS "tbl001EC6050D30_80" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Inverter_ID_ASCII_CHAR_00_01_1" DOUBLE PRECISION DEFAULT NULL, "Inverter_ID_ASCII_CHAR_02_03_2" DOUBLE PRECISION DEFAULT NULL, "Inverter_ID_ASCII_CHAR_04_05_3" DOUBLE PRECISION DEFAULT NULL, "Inverter_ID_ASCII_CHAR_06_07_4" DOUBLE PRECISION DEFAULT NULL, "Inverter_ID_ASCII_CHAR_08_09_5" DOUBLE PRECISION DEFAULT NULL, "Inverter_ID_ASCII_CHAR_10_11_6" DOUBLE PRECISION DEFAULT NULL, "Inverter_ID_ASCII_CHAR_12_13_7" DOUBLE PRECISION DEFAULT NULL, "Inverter_ID_ASCII_CHAR_14_15_8" DOUBLE PRECISION DEFAULT NULL, "Firmware_Version_ASCII_CHAR_00_01_9" DOUBLE PRECISION DEFAULT NULL, "Firmware_Version_ASCII_CHAR_02_03_10" DOUBLE PRECISION DEFAULT NULL, "Firmware_Version_ASCII_CHAR_04_05_11" DOUBLE PRECISION DEFAULT NULL, "Firmware_Version_ASCII_CHAR_06_07_12" DOUBLE PRECISION DEFAULT NULL, "Map_version_13" DOUBLE PRECISION DEFAULT NULL, "Inverter_configuration_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_00_01_15" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_02_03_16" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_04_05_17" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_06_07_18" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_08_09_19" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_10_11_20" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_12_13_21" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_14_15_22" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_16_17_23" DOUBLE PRECISION DEFAULT NULL, "Inverter_serial_ASCII_CHAR_18_19_24" DOUBLE PRECISION DEFAULT NULL, "Voltage_A_N_V_25" DOUBLE PRECISION DEFAULT NULL, "Voltage_B_N_V_26" DOUBLE PRECISION DEFAULT NULL, "Voltage_C_N_V_27" DOUBLE PRECISION DEFAULT NULL, "Current_A_A_28" DOUBLE PRECISION DEFAULT NULL, "Current_B_A_29" DOUBLE PRECISION DEFAULT NULL, "Current_C_A_30" DOUBLE PRECISION DEFAULT NULL, "DC_input_voltage_V_31" DOUBLE PRECISION DEFAULT NULL, "DC_input_current_A_32" DOUBLE PRECISION DEFAULT NULL, "Line_Frequency_Hz_33" DOUBLE PRECISION DEFAULT NULL, "Output_Generation_kW_34" DOUBLE PRECISION DEFAULT NULL, "Total_Energy_Generation_kWh_35" DOUBLE PRECISION DEFAULT NULL, "PV_Input_Voltage_V_36" DOUBLE PRECISION DEFAULT NULL, "Input_Generation_calculated_kW_37" DOUBLE PRECISION DEFAULT NULL, "Inverter_operating_status_state_38" DOUBLE PRECISION DEFAULT NULL, "Main_fault_39" DOUBLE PRECISION DEFAULT NULL, "Drive_fault_40" DOUBLE PRECISION DEFAULT NULL, "Voltage_fault_41" DOUBLE PRECISION DEFAULT NULL, "Grid_fault_42" DOUBLE PRECISION DEFAULT NULL, "Temperature_fault_43" DOUBLE PRECISION DEFAULT NULL, "System_fault_44" DOUBLE PRECISION DEFAULT NULL, "System_warnings_45" DOUBLE PRECISION DEFAULT NULL, "PVM_status_codes_46" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 8.397913 8.397913 8.397913 8.397913 0 0 1033 6 41 1 0 0 0 0 0 0 0 0 207 39 191230
16385 16384 t 2767202467205079659 SELECT * FROM "tblacquisuite" ORDER BY "password" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.43930199999999997 0.43930199999999997 0.43930199999999997 0.43930199999999997 0 43 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1284722884186219978 SELECT * FROM "tbl001EC6050B08_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 20 3.7511350000000006 0.09262799999999999 0.322171 0.18755675000000002 0.07412040174599364 2000 220 0 40 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1862923392537172191 SELECT * FROM "tbl001EC6056FD2_26" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.969098 0.20216099999999998 0.405907 0.3230326666666667 0.08741073974569082 300 173 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8722326962669804660 SELECT * FROM "tbl001EC60506E1_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2146 282.25298500000054 0.033892 88.474217 0.13152515610438056 1.9326706084496705 2146 8543 41 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5247917312176264958 COPY public."tbl001EC6050C0B_51" ("time", error, lowrange, highrange, "umtLastMeasTime_1", "2", "umtWindSpeed_MPH_3", "4", "umtRawWindDir_Degrees_5", "6", "umtAdjWindDir_Degrees_7", "8", "umtRelHumidity_9", "10", "umtRawBaromPress_Inches_Hg_11", "12", "umtAdjBaromPress_Inches_Hg_13", "14", "umtTrueNorthOffset_Degrees_15", "16", "umtLastRain_Date_and_Time_17", "18", "umtTemp1_Degrees_F_19", "20", "umtWindChill_Degrees_F_21", "22", "umtHeatIndex_Degrees_F_23", "24", "umtDewPoint_Degrees_F_25", "26", "umtDensityAltitude_Feet_27", "28", "umtRainToday_Inches_29", "umtTemp2_Degrees_F_30", "umtTemp3_Degrees_F_31", "umtTemp4_Degrees_F_32", "umtSolarRadiation_W_m_2_33", "umtSolarRadiation_2_W_m_2_34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52") TO stdout 0 0 0 0 0 0 6 4.639756 0.086828 1.376118 0.7732926666666666 0.45370382649759033 1536 15 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4961951880313788572 SELECT pg_catalog.pg_get_viewdef($1::pg_catalog.oid) AS viewdef 0 0 0 0 0 0 18 8.840586 0.253315 1.266068 0.49114366666666665 0.2519276444261549 18 433 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8696966397904200089 SELECT * FROM "tbl001EC6053CD9_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6058 168.42083999999986 0.006503 2.5486079999999998 0.027801393199075642 0.06760436734207032 6057 17355 15 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -626351057216241997 SET row_security = off 0 0 0 0 0 0 10 0.05713700000000001 0.004084 0.01035 0.0057136999999999995 0.0019342243432445986 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9111916465278248676 SELECT * FROM "tbl001EC6050B87_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 37 75.484067 0.446056 8.143874 2.0401099189189185 1.8774193808715254 3449 10495 62 6 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4203037273535236514 SELECT * FROM "tbl001EC6050BAC_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 20140 551.452075000002 0.00708 21.311819 0.02738093718967245 0.22056933565473474 20139 59610 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8543711025614443074 SELECT * FROM "tbl001EC6050D30_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 154 598.2137789999998 0.36062099999999997 27.863466 3.8845050584415572 3.063213166057525 15400 23727 556 7 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6850111221199914092 SELECT * FROM "tbl001EC605309C_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.823079 1.346298 1.476781 1.4115395 0.06524149999999995 200 112 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6102374784573001818 SELECT * FROM "tbl001EC6050BAC_6" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 17 11.247041 0.087765 6.715324 0.6615906470588235 1.5209187274748246 1700 1739 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1826133028999487256 SELECT c.oid, conname as name, relname, nspname, description as comment, pg_catalog.pg_get_expr(conbin, conrelid, $1) as consrc, connoinherit, NOT convalidated as convalidated, conislocal FROM pg_catalog.pg_constraint c JOIN pg_catalog.pg_class cl ON cl.oid=conrelid JOIN pg_catalog.pg_namespace nl ON nl.oid=relnamespace LEFT OUTER JOIN pg_catalog.pg_description des ON (des.objoid=c.oid AND des.classoid=$2::regclass) WHERE contype = $3 AND conrelid = $4::oid 0 0 0 0 0 0 10 0.16861199999999998 0.011601 0.044544 0.0168612 0.009376733064346025 0 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1834454130821365460 SELECT DISTINCT att.attname as name, att.attnum as OID, pg_catalog.format_type(ty.oid,$1) AS datatype, att.attnotnull as not_null, CASE WHEN att.atthasdef OR att.attidentity != $2 OR ty.typdefault IS NOT NULL THEN $3 ELSE $4 END as has_default_val, des.description, seq.seqtypid FROM pg_catalog.pg_attribute att JOIN pg_catalog.pg_type ty ON ty.oid=atttypid JOIN pg_catalog.pg_namespace tn ON tn.oid=ty.typnamespace JOIN pg_catalog.pg_class cl ON cl.oid=att.attrelid JOIN pg_catalog.pg_namespace na ON na.oid=cl.relnamespace LEFT OUTER JOIN pg_catalog.pg_type et ON et.oid=ty.typelem LEFT OUTER JOIN pg_catalog.pg_attrdef def ON adrelid=att.attrelid AND adnum=att.attnum LEFT OUTER JOIN (pg_catalog.pg_depend JOIN pg_catalog.pg_class cs ON classid=$5::regclass AND objid=cs.oid AND cs.relkind=$6) ON refobjid=att.attrelid AND refobjsubid=att.attnum LEFT OUTER JOIN pg_catalog.pg_namespace ns ON ns.oid=cs.relnamespace LEFT OUTER JOIN pg_catalog.pg_index pi ON pi.indrelid=att.attrelid AND indisprimary LEFT OUTER JOIN pg_catalog.pg_description des ON (des.objoid=att.attrelid AND des.objsubid=att.attnum AND des.classoid=$7::regclass) LEFT OUTER JOIN pg_catalog.pg_sequence seq ON cs.oid=seq.seqrelid WHERE att.attrelid = $8::oid AND att.attnum > $9 AND att.attisdropped IS FALSE ORDER BY att.attnum 0 0 0 0 0 0 1 6.155709 6.155709 6.155709 6.155709 0 9 741 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6500923973944084869 INSERT INTO "tbl001EC6050D17_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 326 14.107847000000001 0.020891 0.500989 0.04327560429447852 0.04086641628615701 326 1365 2 181 18 0 0 0 0 0 0 0 0 979 168 651602
16385 16384 t -8561462118216554770 SELECT * FROM "tbl001EC6056D41_53" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.321674 1.132644 1.18903 1.160837 0.02819300000000008 200 50 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4774376544451253706 SELECT * FROM "tbl001EC6056FD2_54" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30262 764.8399319999959 0.012797 14.420209999999999 0.025273938668957687 0.09641314290601509 30262 90778 8 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -2563412158741520104 SELECT version() 0 0 0 0 0 0 46 0.519752 0.00751 0.02189 0.011298956521739128 0.0030122485531469223 46 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2511186360781544908 SELECT * FROM "tbl001EC6053113_9" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 33 103.73062699999998 1.4431669999999999 8.398299999999999 3.1433523333333335 1.93827479728133 3300 13588 33 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -3133452872774184123 DROP TABLE IF EXISTS _c6e7f4721c84c25caed25a9991d5b1f6 0 0 0 0 0 0 1 0.113908 0.113908 0.113908 0.113908 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 128621451631603492 SELECT * FROM tbldevicelist WHERE serialnumber = $1 0 0 0 0 0 0 247603 52256.86420099939 0.004721 49.170288 0.21105101392551742 0.2554426408664135 1440212 2352720 2 0 0 0 0 0 0 0 0 0 0 12 0 692
16385 16384 t -1498804828724369307 LOCK TABLE public."tbl001EC6050B42_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.167917 0.023565 0.038289 0.027986166666666666 0.004891126026341536 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2986801956434889176 LOCK TABLE public."tbl001EC6052F1E_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.23972500000000002 0.019217 0.03763 0.0239725 0.005020544517280969 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4009613486209723503 SELECT * FROM "tbl001EC6050BAC_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 17 5.035321 0.084362 0.842387 0.2961953529411765 0.20389863604827282 1700 1579 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3353571375877802626 INSERT INTO "tbl001EC6050BAC_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 10119 551.4033460000012 0.016377 44.528787 0.05449188121355872 0.4600775483756324 10119 61601 140 5629 198 0 0 0 0 0 0 0 0 30385 5336 24876203
16385 16384 t 6977812588676891255 LOCK TABLE public."tbl001EC6053093_55" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.298765 0.019661 0.053324 0.0298765 0.010817308734153794 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7895196853005353742 SELECT * FROM "tbl001EC6050F42_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 214 4.6263179999999995 0.005324000000000001 0.554215 0.021618308411214943 0.03799160208984983 213 425 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8628271162960416843 SELECT * FROM "tbl001EC6056D49_9" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 5.413816 2.190295 3.223521 2.706908 0.516613 200 123 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -257990099519632198 SELECT * FROM "tbl001EC60537E0_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 8.430752 0.139328 1.724446 0.526922 0.44834857243151227 1600 4950 3 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8877653541812745942 SELECT * FROM "tbl001EC6050F3C_9" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 15 0.810804 0.029727 0.128583 0.05405360000000001 0.03558916255603664 184 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3269963500179978303 CREATE TABLE IF NOT EXISTS "tbl001EC6050BAC_8" ( 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.611488 6.611488 6.611488 6.611488 0 0 542 3 6 0 0 0 0 0 0 0 0 0 138 4 17823
16385 16384 t 8099611460031656254 SELECT * FROM "tbl001EC605311A_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6134 156.3451629999994 0.0126 2.369532 0.02548828871861752 0.045145327392827284 6134 18395 7 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3807398390925618140 CREATE TABLE IF NOT EXISTS "tbl001EC6053109_11" ( 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.634993 10.634993 10.634993 10.634993 0 0 877 8 10 0 0 0 0 0 0 0 0 0 165 8 44205
16385 16384 t 5167781977366854516 SELECT * FROM "tbl001EC6056300_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.293509 0.293509 0.293509 0.293509 0 100 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4114490522262863009 SELECT * FROM "tbl001EC6050B5D_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1728 49.01773000000008 0.009840000000000002 6.402473 0.028366741898148157 0.17491432223076 1727 4375 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7699078362443148092 LOCK TABLE public."tbl001EC6050E4D_80" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.26965700000000004 0.017956 0.057643 0.0269657 0.01109532233015337 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3443076231544724149 SELECT * FROM "tbl001EC6050BAC_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 17 5.195225 0.087148 0.624213 0.30560147058823534 0.19289145867441423 1700 1574 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5558153244154307186 SELECT * FROM "tbl001EC6050B5D_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1674 45.57401999999993 0.005874 1.923868 0.027224623655913948 0.08085971897240082 1673 4245 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6725907279475143812 SELECT n.nspname, r.relname FROM pg_catalog.pg_class r LEFT JOIN pg_catalog.pg_namespace n ON (r.relnamespace = n.oid) WHERE r.oid = $1 0 0 0 0 0 0 1 0.024655 0.024655 0.024655 0.024655 0 1 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7019256061890656683 INSERT INTO "tbl001EC6056D47_10" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15558 632.3530029999976 0.014501 5.392965 0.04064487742640457 0.06701843573963746 15558 96045 29 8903 428 0 0 0 0 0 0 0 0 46716 8140 38320342
16385 13761 t -9016916208729423717 DROP TABLE IF EXISTS _eb533f27f16f0838b165fa84200e9973 0 0 0 0 0 0 1 3.740121 3.740121 3.740121 3.740121 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8045472926476844391 SELECT * FROM "tbl001EC6056D41_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6132 294.5805210000013 0.022859 3.698089 0.048039876223092144 0.06096572763576043 6132 18391 5 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4663767991290876829 LOCK TABLE public."tbl001EC6050C0B_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.38712399999999997 0.045308 0.095347 0.06452066666666667 0.01950596909210671 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9000419771340478498 SELECT * FROM "tbl001EC6050B87_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 38 100.33194899999998 0.445198 21.385231 2.640314447368421 3.614617489380124 3549 10752 48 6 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 825154149197784083 INSERT INTO "tbl001EC6050D17_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 326 13.452274 0.022796999999999998 0.292277 0.04126464417177913 0.03402072803592312 326 1361 2 184 18 0 0 0 0 0 0 0 0 979 160 633334
16385 16384 t -7382854459159488550 SELECT * FROM "tbl001EC6053093_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 4 7.363183 0.9482959999999999 4.34142 1.8407957500000003 1.444767298155031 400 213 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6359050026629502943 LOCK TABLE public."tbl001EC6054E88_103" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.07298 0.018104 0.031916 0.024326666666666667 0.005720936364694935 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2010864093603536362 INSERT INTO "tbl001EC6050189_32" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 878 78.14007400000013 0.027402999999999997 2.095975 0.08899780637813207 0.14174156056550033 878 5186 20 1848 128 0 0 0 0 0 0 0 0 2637 1614 7439558
16385 16384 t -2680168081236125065 GRANT SELECT ON TABLE public."tbl001EC60530AB_9" TO developer 0 0 0 0 0 0 1 0.365475 0.365475 0.365475 0.365475 0 0 9 0 4 0 0 0 0 0 0 0 0 0 4 4 20965
16385 16384 t -7949265479564901183 SELECT * FROM "tbl001EC6050B42_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 20 8.963989000000003 0.059932 2.329485 0.4481994500000001 0.5867788639659302 1169 203 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -504182335973093965 COPY public."tbl001EC6056D41_54" ("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 576.599268 36.671938 78.504363 57.65992680000001 12.191761404541966 44930 63 5132 11 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5271777238519108401 COPY public."tbl001EC6050F3C_3" ("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.105593 0.105593 0.105593 0.105593 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5257188998907202339 SELECT pg_roles.rolname, pg_roles.rolconnlimit FROM pg_roles 0 0 0 0 0 0 122642 1803.3071360000395 0.009174 1.2869400000000002 0.014703830139756435 0.011320882740213895 1839630 122642 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6648139170136145298 SELECT * FROM "dl_inverter_device_data" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 10 36.049886 0.103155 7.074978 3.6049886000000004 2.874882334823643 1000 58 42 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2888506741548886025 INSERT INTO "tbl001EC60537AE_41" 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 3114 314.342852 0.017324 3.256588 0.10094503917790618 0.22027424663938408 3114 20035 238 5994 93 0 0 0 0 0 0 0 0 9351 5950 25131410
16385 16384 t -8629156980114918718 COPY public."tbl001EC6050D16_6" ("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 1143.743921 143.156338 215.38656 190.62398683333333 23.193648710229805 400417 1173 5077 179 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6746710403892883980 CREATE TABLE IF NOT EXISTS "tbl001EC6050B42_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 9.727576 9.727576 9.727576 9.727576 0 0 673 6 40 1 0 0 0 0 0 0 0 0 134 38 172403
16385 16384 t -2534842500058277218 LOCK TABLE public."tbl001EC6056FD2_60" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.264694 0.016733 0.041103 0.0264694 0.008396823211191241 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4858777605192961403 SELECT * FROM "tbl001EC6053093_9" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.588727 0.728483 1.860244 1.2943635 0.5658805 200 65 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2954216581073452720 SELECT pg_database.datname, tmp.state, tmp2.usename, tmp2.application_name, COALESCE(count,$1) as count, COALESCE(max_tx_duration,$2) as max_tx_duration FROM ( VALUES ($3), ($4), ($5), ($6), ($7), ($8) ) AS tmp(state) CROSS JOIN pg_database LEFT JOIN ( SELECT datname, state, usename, application_name, count(*) AS count, MAX(EXTRACT($9 FROM now() - xact_start))::float AS max_tx_duration FROM pg_stat_activity GROUP BY datname,state,usename,application_name) AS tmp2 ON tmp.state = tmp2.state AND pg_database.datname = tmp2.datname 0 0 0 0 0 0 62053 20640.247694000078 0.116683 96.530806 0.332622881955749 1.6849298814747409 1490944 186165 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2735027724332309544 SELECT * FROM "tbl001EC6056300_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30318 823.3215219999987 0.015946 3.0187030000000004 0.027156195065637507 0.041063753833889514 30318 121237 35 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6032960572365534161 COPY public."tbl001EC6050F3C_6" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 1 0.111147 0.111147 0.111147 0.111147 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8964346831280137895 SELECT * FROM "tbl001EC6050F3C_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 1.0290450000000002 0.027427999999999998 0.15945700000000002 0.0643153125 0.04212755217449554 235 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7102354125485349389 INSERT INTO "tbl001EC6050D21_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 5188 490.0948050000003 0.018862 3.007344 0.09446700173477272 0.20388723671011877 5188 33035 359 7101 289 0 0 0 0 0 0 0 0 15578 6498 30733818
16385 16384 t -7169294697585467220 SELECT * FROM "tbl001EC605309C_54" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28984 1184.4797309999979 0.021609 3.459829 0.040866675786640785 0.04953349255817933 28984 86928 24 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -8385857661538100584 DROP TABLE IF EXISTS _ae34d7a132cde6ea96e92ab14063050a 0 0 0 0 0 0 1 0.099311 0.099311 0.099311 0.099311 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -2450602143069974326 DROP TABLE IF EXISTS _4672b97ec8f992b9fe0b00b4879ed49a 0 0 0 0 0 0 1 0.107169 0.107169 0.107169 0.107169 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8868283171486367736 COPY public."tbl001EC6053093_55" ("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 28847.897589 2668.462956 3385.15627 2884.7897589 222.9389400056911 2124170 11515 194693 48 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8507764079609434084 COPY public."tbl001EC6050B87_103" ("time", error, lowrange, highrange, "Vln_a_Volts_1", "Vln_b_Volts_2", "Vln_c_Volts_3", "Vln_ave_Volts_4", "Vll_ab_Volts_5", "Vll_bc_Volts_6", "Vll_ca_Volts_7", "Vll_ave_Volts_8", "I_a_Amps_9", "I_b_Amps_10", "I_c_Amps_11", "I_ave_Amps_12", "V_unbal_13", "I_unbal_14", "Freq_Hz_15", "I4_Amps_16", "kW_a_kW_17", "kW_b_kW_18", "kW_c_kW_19", "kW_tot_kW_20", "kVAR_a_kVAR_21", "kVAR_b_kVAR_22", "kVAR_c_kVAR_23", "kVAR_tot_kVAR_24", "kVA_a_kVA_25", "kVA_b_kVA_26", "kVA_c_kVA_27", "kVA_tot_kVA_28", "PF_sign_a_29", "PF_sign_b_30", "PF_sign_c_31", "PF_sign_tot_32", "Vll_ave_mx_Volts_33", "I_ave_mx_Amps_34", "kW_tot_mx_kW_35", "kVAR_tot_mx_kVAR_36", "kVA_tot_mx_kVA_37", "Freq_mx_Hz_38", "Vll_ave_mn_Volts_39", "I_ave_mn_Amps_40", "Freq_mn_Hz_41", "kW_sd_del_rec_kW_42", "kVA_sd_del_rec_kVA_43", "kVAR_sd_del_rec_kVAR_44", "kW_sd_mx_d_r_kW_45", "kVA_sd_mx_d_r_kVA_46", "kVAR_sd_mx_d_r_kVAR_47", "Phase_Rev_48", "kWh_del_kWh_49", "kWh_rec_kWh_50", "kWh_del_rec_kWh_51", "kWh_del_rec_kWh_52", "kVARh_del_kVARh_53", "kVARh_rec_kVARh_54", "kVARh_del_rec_kVARh_55", "kVARh_del_rec_kVARh_56", "kVAh_del_rec_kVAh_57", "V1_THD_mx_58", "V2_THD_mx_59", "V3_THD_mx_60", "I1_THD_mx_61", "I2_THD_mx_62", "I3_THD_mx_63", unused_64) TO stdout 0 0 0 0 0 0 9 349.15770499999996 1.823164 78.197664 38.795300555555556 24.405729553508476 27378 738 1077 3 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 7583218366193534547 CREATE TABLE _f775c74462a3a72bfa20636bf74231a5(cmd_output text) 0 0 0 0 0 0 1 11.339328 11.339328 11.339328 11.339328 0 0 504 4 25 1 0 0 0 0 0 0 0 0 93 25 123861
16385 16384 t -463994618235655280 INSERT INTO "tbl001EC6056FD2_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 15560 1065.7357150000007 0.017868 77.23070999999999 0.06849201253213348 0.7767549469769457 15560 98268 55 11142 1135 0 0 0 0 0 0 0 0 46723 8736 48142300
16385 16384 t 3191969801125819197 INSERT INTO "tbl001EC60537E0_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 2037 122.83018000000013 0.020015 2.840313 0.060299548355424636 0.12385017842500673 2037 12398 54 3605 38 0 0 0 0 0 0 0 0 6117 4018 17232439
16385 16384 t 5178675256718892078 COPY public."tbl001EC6050189_33" ("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 34.001203 0.296984 7.4437 3.7779114444444444 2.2856587248674485 3555 33 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7939919501308767074 CREATE TABLE IF NOT EXISTS "tbl001EC6054E88_2" ( 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 12.866487 12.866487 12.866487 12.866487 0 0 794 6 40 1 0 0 0 0 0 0 0 0 165 36 180193
16385 16384 t 7965491392036753350 LOCK TABLE public."tbl001EC60537E0_21" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.211638 0.016625 0.055513 0.030233999999999997 0.01383623491313401 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7699229737235277349 LOCK TABLE public."tbl001EC6053075_54" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.10474499999999999 0.018052 0.061033 0.034914999999999995 0.018727570744760252 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 8412100369504386690 DROP TABLE IF EXISTS _d66ebbbedcc1b109647008da003a6441 0 0 0 0 0 0 1 0.836717 0.836717 0.836717 0.836717 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0