Tables

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

pg_stat_statements

userid
oid 		dbid
oid 		toplevel
boolean 		queryid
bigint 		query
text 		plans
bigint 		total_plan_time
double precision 		min_plan_time
double precision 		max_plan_time
double precision 		mean_plan_time
double precision 		stddev_plan_time
double precision 		calls
bigint 		total_exec_time
double precision 		min_exec_time
double precision 		max_exec_time
double precision 		mean_exec_time
double precision 		stddev_exec_time
double precision 		rows
bigint 		shared_blks_hit
bigint 		shared_blks_read
bigint 		shared_blks_dirtied
bigint 		shared_blks_written
bigint 		local_blks_hit
bigint 		local_blks_read
bigint 		local_blks_dirtied
bigint 		local_blks_written
bigint 		temp_blks_read
bigint 		temp_blks_written
bigint 		blk_read_time
double precision 		blk_write_time
double precision 		wal_records
bigint 		wal_fpi
bigint 		wal_bytes
numeric
16385 16384 t 7949981054851130074 INSERT INTO "tbl001EC60537E0_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 1930 110.06885599999985 0.020604 1.8015489999999998 0.057030495336787584 0.10227963898161015 1930 11641 37 3363 39 0 0 0 0 0 0 0 0 5796 3797 16379223
16385 16384 t 65544975340227788 INSERT INTO "tbl001EC6050BAC_7" 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 9584 542.8680059999997 0.016606 80.97954899999999 0.05664315588480794 0.8702239664141838 9584 58265 101 5298 161 0 0 0 0 0 0 0 0 28779 5090 23329408
16385 16384 t 1814370596331611952 INSERT INTO "tbl001EC6053CD9_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 2854 147.47709500000016 0.017978 1.937707 0.05167382445690259 0.0777100924375875 2854 17271 24 3759 92 0 0 0 0 0 0 0 0 8570 3626 15762904
16385 16384 t 6305699317791867522 COPY public."tbl001EC6050F3C_33" ("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 1 0.117183 0.117183 0.117183 0.117183 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8965768295221661438 SELECT * FROM "tbl001EC6053093_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29206 914.7796719999963 0.018372999999999997 4.861432 0.03132163500650544 0.06571592877409639 29206 116790 34 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5933109379755905979 CREATE TABLE IF NOT EXISTS "tbl001EC60537E0_41" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.317812 5.317812 5.317812 5.317812 0 0 574 1 1 0 0 0 0 0 0 0 0 0 145 2 16904
16385 16384 t 3201703779189533466 CREATE TABLE IF NOT EXISTS "tbl001EC6050F42_2" ( 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.206942 6.206942 6.206942 6.206942 0 0 977 1 1 0 0 0 0 0 0 0 0 0 242 2 30091
16385 16384 t 6030022282230177435 INSERT INTO "tbl001EC6050F3C_12" 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 67 3.411276 0.028471 0.185651 0.050914567164179095 0.023840056878014812 67 269 0 133 2 0 0 0 0 0 0 0 0 202 130 196715
16385 16384 t 2897522876661520132 LOCK TABLE public."tbl001EC6050F3C_14" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.022681 0.022681 0.022681 0.022681 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1022216283660081612 SELECT * FROM "tbl001EC6053113_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28608 1310.7948470000053 0.028767 5.733714 0.04581917110598411 0.04780128646960489 28608 85806 18 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4559525109671902606 SELECT * FROM "tbl001EC60537E0_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3860 96.66497100000016 0.005742000000000001 3.162187 0.025042738601036327 0.06564048964542779 3859 10765 3 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3494879671813421537 INSERT INTO "tbl001EC6050BAC_3" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 9584 524.886274000001 0.015511 67.687707 0.05476693176126875 0.7121096551277554 9584 58171 87 5140 171 0 0 0 0 0 0 0 0 28779 4904 22784678
16385 16384 t -8515388520039940802 SELECT * FROM "tbl001EC6050F3A_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 8 12.483458 0.468707 4.438079999999999 1.56043225 1.5003230523252107 800 68 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2143533060631656847 SELECT * FROM "tbl001EC6050D05_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29210 938.731512999997 0.018909000000000002 4.428598 0.03213733355015398 0.044444038298325605 29210 116831 9 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1279096003048624513 COPY public."tbl001EC60537E0_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 7 35.916669999999996 0.06737 15.747395 5.130952857142857 4.892910191511633 6195 51 65 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5467053905531392763 COPY public."tbl001EC6053CD9_4" ("time", error, lowrange, highrange, "Energy_Consumption_kWh_1", "Real_Power_kW_2") TO stdout 0 0 0 0 0 0 6 31.776856 0.114701 12.909934 5.296142666666666 4.2816612545692925 8118 55 45 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7815281640518297196 LOCK TABLE public."tbl001EC6056D48_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.36109 0.01945 0.090417 0.036109 0.02313253820487497 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7251826586634779737 LOCK TABLE public."tbl001EC605309C_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.29294800000000004 0.019017 0.086496 0.029294800000000003 0.019485724681417422 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3389129273360096534 LOCK TABLE public.dl_meter_device_data IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.4968970000000001 0.020181 0.179416 0.0496897 0.04704280804129363 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6672424749522332880 COPY public.tbldevicelist (serialnumber, deviceid, devicename, devicetype, deviceclass, config, configchangetime, configchecksum, datatablename) TO stdout 0 0 0 0 0 0 10 210.91353900000001 12.804661 35.629988 21.0913539 6.700911687457885 1701 1889 124 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6802550087586260544 SELECT * FROM "tbl001EC6050189_33" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1674 90.92310900000017 0.021772 1.987768 0.054314879928315296 0.0982610202756649 1673 4193 19 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -9030696468456313006 CREATE TABLE _276d05969ee20125dee39571315bf6a1(cmd_output text) 0 0 0 0 0 0 1 10.504071 10.504071 10.504071 10.504071 0 0 501 5 24 0 0 0 0 0 0 0 0 0 92 25 122929
16385 16384 t 7451525619227643169 SELECT * FROM "tbl001EC6050BAC_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 7 0.759827 0.08570499999999999 0.125105 0.10854671428571427 0.014184532438180542 700 108 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7285949714286782777 LOCK TABLE public."tbl001EC6056300_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.381376 0.021251 0.061555 0.038137599999999994 0.012056469435120714 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7656608426194004174 SELECT * FROM "tbl001EC6053CD9_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 5 0.656455 0.117203 0.16325800000000001 0.13129100000000002 0.01688141573446967 500 375 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3118720287759231126 INSERT INTO "tbl001EC6050D16_50" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 71394 2121.078010000021 0.013601 80.504194 0.02970947152421743 0.32152266033583315 71394 432256 27 3467 2140 0 0 0 0 0 0 0 0 214379 1300 31512960
16385 16384 t 3686759338601217105 SELECT * FROM "tbl001EC6050D16_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1922 52.24334600000003 0.005687 2.269833 0.027181761706555688 0.0815021346971344 1921 5757 7 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7006951292212829354 COPY public."tbl001EC6056300_50" ("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 13896.184371000001 1097.062547 1728.1266150000001 1389.6184371 172.19518415382174 2140590 274 69296 14 10 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 485016310711430062 SELECT * FROM "tbl001EC6050F3C_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 134 5.315760999999998 0.010042 1.339273 0.0396698582089552 0.11347552782955589 133 265 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 509043065338986260 CREATE TABLE _ab6d56c31864922703c761538e38f2b8(cmd_output text) 0 0 0 0 0 0 1 6.200314 6.200314 6.200314 6.200314 0 0 504 2 3 0 0 0 0 0 0 0 0 0 92 4 23185
16385 16384 t 7406351295613100700 COPY public."tbl001EC6054E88_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 3 904.4322119999999 264.967587 348.604364 301.477404 34.96017172773201 52764 1298 2509 44 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3429958618568471424 CREATE TABLE IF NOT EXISTS "tbl001EC6053109_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 11.72393 11.72393 11.72393 11.72393 0 0 873 5 36 0 0 0 0 0 0 0 0 0 163 36 178339
16385 16384 t 6423695676518781385 COPY public."tbl001EC6050D05_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 10 35225.693124 3321.122602 3677.338995 3522.5693124 114.91457105475004 2038740 1667 159516 50 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1391901306320756083 COPY public."tbl001EC6053093_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 29351.903581 2674.736839 3372.074544 2935.1903580999997 197.93990083133895 2124140 11572 194766 49 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8299171435924775676 INSERT INTO "tbl001EC6050F42_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 73 3.976727999999999 0.012946 0.9209700000000001 0.05447572602739725 0.1032041822019812 72 291 0 143 2 0 0 0 0 0 0 0 0 217 140 395806
16385 16384 t -8693187967704674284 INSERT INTO "tbl001EC6053075_7" 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 793 38.36849100000002 0.024131 0.940908 0.048383973518285064 0.060853184333102 793 4120 6 1253 12 0 0 0 0 0 0 0 0 2382 1532 6483199
16385 16384 t -4910450954336119731 LOCK TABLE public."tbl001EC6050F3C_17" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.027899 0.027899 0.027899 0.027899 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -479604193929285912 CREATE TABLE IF NOT EXISTS "tbl001EC6050B5D_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 8.841602 8.841602 8.841602 8.841602 0 0 673 1 38 0 0 0 0 0 0 0 0 0 133 36 181381
16385 16384 t -833164884107262632 SELECT * FROM "tbl001EC6050F3C_11" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 134 6.015840999999998 0.017411 1.49262 0.04489433582089551 0.13451695102964753 133 265 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4519695517080578383 SET idle_in_transaction_session_timeout = 0 0 0 0 0 0 0 10 0.056595000000000006 0.004041 0.01156 0.0056595000000000005 0.0021261172239554435 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8536972362520461591 COPY public."tbl001EC605309C_51" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 10 3848.9138639999996 330.165482 455.634839 384.8913864 40.16514280567111 324420 1602 28456 118 3 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3328035025892249135 SELECT * FROM "tbl001EC6050B08_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2086 71.87020799999999 0.012577 4.220903 0.03445359923298173 0.16969610272470168 2086 6222 36 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5065827165977874471 INSERT INTO "tbl001EC6050F42_2" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 73 4.676282999999998 0.021985 0.275939 0.06405867123287672 0.04755406983204006 73 332 2 147 7 0 0 0 0 0 0 0 0 220 135 359078
16385 16384 t 8127049249199415116 SELECT setconfig[$1] FROM pg_db_role_setting WHERE setrole = $2 AND setdatabase = $3::oid 0 0 0 0 0 0 10 0.048915999999999994 0.004207 0.005725 0.0048916 0.00043296886724105246 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 555876327915940941 SELECT * FROM "tbl001EC6053113_53" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28608 1177.4925880000008 0.020284 6.245522 0.04115955634787458 0.06824310418311703 28608 85803 21 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 5419322566926853521 DROP TABLE IF EXISTS _5001befeeb31fb8114be059bfe6a816a 0 0 0 0 0 0 1 2.462067 2.462067 2.462067 2.462067 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -400283940301207954 INSERT INTO "tbl001EC6050F3C_4" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$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 67 4.5466789999999975 0.028147 1.484271 0.06786088059701491 0.17521891492265418 67 269 0 133 2 0 0 0 0 0 0 0 0 202 130 196715
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 4940492110182687977 SELECT * FROM "tbl001EC6050D16_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1908 54.824782000000006 0.006016 3.145933 0.028734162473794563 0.09335747001219785 1907 5714 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3887293030408696172 LOCK TABLE public."tbl001EC6053093_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.220486 0.018446 0.025202 0.0220486 0.0017851504250342598 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5591777891024624638 SELECT * FROM "tbl001EC605309C_55" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 4.203531 1.314736 2.888795 2.1017655 0.7870295 200 103 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1695433075765582741 CREATE TABLE IF NOT EXISTS "tbl001EC6050BAC_52" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 9.162309 9.162309 9.162309 9.162309 0 0 761 6 8 0 0 0 0 0 0 0 0 0 141 8 37469
16385 16384 t 2133707498480341402 INSERT INTO "tbl001EC6050F3C_18" 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 67 3.522931 0.027982 0.25732 0.05258105970149253 0.03285995390158584 67 269 0 133 2 0 0 0 0 0 0 0 0 202 130 196715
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 1586 30.925256999999984 0.0062380000000000005 0.17703400000000002 0.019498901008827244 0.010108122753192384 1585 3946 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 7 1.3079180000000001 0.026506 0.362285 0.18684542857142858 0.11068717350373032 508 77 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5088373729513854179 CREATE TABLE IF NOT EXISTS "tbl001EC6050BAC_10" ( 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.262694 6.262694 6.262694 6.262694 0 0 544 2 2 0 0 0 0 0 0 0 0 0 137 2 16235
16385 16384 t -5096014671239453740 SELECT * FROM "tbl001EC6053113_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28608 716.1005640000042 0.01448 4.524375 0.025031479446308805 0.05096597602994959 28608 85803 21 1 0 0 0 0 0 0 0 0 0 0 0 0
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 5430929091461234815 COPY public."tbl001EC6056D49_9" ("time", error, lowrange, highrange, "Active_Power_Total_kW_1", "Reactive_Power_Total_kVAR_2", "Apparent_Power_Total_kVA_3", "Voltage_Average_Volts_4", "Voltage_L_L_Average_Volts_5", "Current_Average_Amps_6", "System_Power_Factor_7", "System_Frequency_Hz_8", "Voltage_Average_Angle_Degrees_9", "System_Quadrant_10", "Voltage_A_Volts_11", "Voltage_B_Volts_12", "Voltage_C_Volts_13", "Voltage_A_B_Volts_14", "Voltage_B_C_Volts_15", "Voltage_A_C_Volts_16", "Current_A_Amps_17", "Current_B_Amps_18", "Current_C_Amps_19", "Active_Power_A_kW_20", "Active_Power_B_kW_21", "Active_Power_C_kW_22", "Reactive_Power_A_kVAR_23", "Reactive_Power_B_kVAR_24", "Reactive_Power_C_kVAR_25", "Apparent_Power_A_kVA_26", "Apparent_Power_B_kVA_27", "Apparent_Power_C_kVA_28", "Power_Factor_A_29", "Power_Factor_B_30", "Power_Factor_C_31", "Voltage_Angle_AB_Degrees_32", "Voltage_Angle_BC_Degrees_33", "Voltage_Angle_CA_Degrees_34", "Quadrant_A_35", "Quadrant_B_36", "Quadrant_C_37", "Sliding_Window_Power_kW_38", "Net_Total_Energy_Revenue_kWh_39", "Total_Net_Apparent_Energy_Revenue_kVA_40", "Total_Import_Energy_Revenue_kWh_41", "Total_Export_Energy_Revenue_kWh_42", "Total_Import_Apparent_Energy_Revenue_kVA_43", "Total_Export_Apparent_Energy_Revenue_kVA_44", "Q1_Total_Reactive_Energy_Revenue_kVAR_45", "Q2_Total_Reactive_Energy_Revenue_kVAR_46", "Q3_Total_Reactive_Energy_Revenue_kVAR_47", "Q4_Total_Reactive_Energy_Revenue_kVAR_48", "Q1_Q2_Total_Inductive_Reactive_Energy_Revenue_kVAR_49", "Q3_Q4_Total_Capacitive_Reactive_Energy_Revenue_kVAR_50", "Net_Energy_Revenue_A_kWh_51", "Net_Energy_Revenue_B_kWh_52", "Net_Energy_Revenue_C_kWh_53", "Net_Apparent_Energy_Revenue_A_kVA_54", "Net_Apparent_Energy_Revenue_B_kVA_55", "Net_Apparent_Energy_Revenue_C_kVA_56", "Import_Energy_Revenue_A_kWh_57", "Import_Energy_Revenue_B_kWh_58", "Import_Energy_Revenue_C_kWh_59", "Export_Energy_Revenue_A_kWh_60", "Export_Energy_Revenue_B_kWh_61", "Export_Energy_Revenue_C_kWh_62", "Import_Apparent_Energy_Revenue_A_kVA_63", "Import_Apparent_Energy_Revenue_B_kVA_64", "Import_Apparent_Energy_Revenue_C_kVA_65", "Export_Apparent_Energy_Revenue_A_kVA_66", "Export_Apparent_Energy_Revenue_B_kVA_67", "Export_Apparent_Energy_Revenue_C_kVA_68", "Q1_Reactive_Energy_Revenue_A_kVAR_69", "Q1_Reactive_Energy_Revenue_B_kVAR_70", "Q1_Reactive_Energy_Revenue_C_kVAR_71", "Q2_Reactive_Energy_Revenue_A_kVAR_72", "Q2_Reactive_Energy_Revenue_B_kVAR_73", "Q2_Reactive_Energy_Revenue_C_kVAR_74", "Q3_Reactive_Energy_Revenue_A_kVAR_75", "Q3_Reactive_Energy_Revenue_B_kVAR_76", "Q3_Reactive_Energy_Revenue_C_kVAR_77", "Q4_Reactive_Energy_Revenue_A_kVAR_78", "Q4_Reactive_Energy_Revenue_B_kVAR_79", "Q4_Reactive_Energy_Revenue_C_kVAR_80") TO stdout 0 0 0 0 0 0 10 5354.860044999999 342.516859 731.450687 535.4860045 118.57641054647725 213100 14 19685 60 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6875482623069882922 INSERT INTO "tbl001EC6050F3C_5" 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 67 4.383229999999999 0.028305 0.902343 0.0654213432835821 0.10721249906868972 67 269 0 133 2 0 0 0 0 0 0 0 0 202 130 196715
16385 16384 t -3743008901551969697 COPY _timescaledb_catalog.continuous_aggs_bucket_function (mat_hypertable_id, bucket_func, bucket_width, bucket_origin, bucket_offset, bucket_timezone, bucket_fixed_width) TO stdout 0 0 0 0 0 0 10 0.245847 0.02208 0.029174 0.0245847 0.0018612609193769689 0 0 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 2357379859879618926 COPY _timescaledb_catalog.dimension (id, hypertable_id, column_name, column_type, aligned, num_slices, partitioning_func_schema, partitioning_func, interval_length, compress_interval_length, integer_now_func_schema, integer_now_func) TO stdout 0 0 0 0 0 0 10 0.424215 0.038076 0.050696 0.0424215 0.004210225938117811 10 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1793748918616321286 COPY public."tbl001EC6053093_53" ("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 29776.995727999998 2635.26065 3460.946896 2977.6995728 240.53547347951468 2124170 12785 194013 48 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5659078131310015898 COPY public."tbl001EC6050F42_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 1 0.149974 0.149974 0.149974 0.149974 0 13 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8921681041354551030 LOCK TABLE public."tbl001EC6056300_15" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.40178499999999995 0.019207 0.189996 0.0401785 0.05026624920411309 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 8584207651148466389 DROP TABLE IF EXISTS _4a37bb5125f01151dc7937865e2037fe 0 0 0 0 0 0 1 1.34558 1.34558 1.34558 1.34558 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7738153563484438493 CREATE TABLE IF NOT EXISTS "tbl001EC6053075_53" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 7.505778 7.505778 7.505778 7.505778 0 0 1141 4 7 0 0 0 0 0 0 0 0 0 281 4 42708
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 -1633178077259222686 INSERT INTO "tbl001EC6050F3C_8" 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 67 3.3109530000000005 0.027777 0.175968 0.049417208955223876 0.02540846761286382 67 269 0 133 2 0 0 0 0 0 0 0 0 202 130 196715
16385 16384 t -8726540687649906607 SELECT * FROM "tbl001EC6056D47_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28976 1165.3830040000082 0.021537999999999998 3.7724830000000003 0.04021890543898416 0.04001152675001235 28976 86924 4 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1553526116437692926 INSERT INTO "tbl001EC6050B42_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 550 38.221948000000026 0.018815 1.9189980000000002 0.06949445090909097 0.12995457586867662 550 2801 12 1083 19 0 0 0 0 0 0 0 0 1652 1073 4360005
16385 16384 t 7036321271409917878 SELECT * FROM "tbl001EC6050F3C_5" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 134 5.323659 0.014346 1.298497 0.03972879850746267 0.11108499459602857 133 265 2 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 6 8.090047 0.13309300000000002 6.994403 1.3483411666666667 2.5257465863128084 600 566 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6770469974461588436 LOCK TABLE public."tbl001EC6056D48_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.32016300000000003 0.018918 0.070846 0.032016300000000004 0.013556688216891323 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1448348365787151770 LOCK TABLE public."tbl001EC6050D06_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.15880799999999998 0.018583 0.042809 0.026468 0.008253711569146737 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4221947877590446308 LOCK TABLE public."tbl001EC6056FD2_55" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.31564699999999996 0.018908 0.093134 0.0315647 0.02173667101029962 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2775730264983670673 INSERT INTO "tbl001EC6056D41_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 3005 206.36253200000002 0.020726 2.108851 0.06867305557404321 0.10082123833709619 3005 20126 29 5969 248 0 0 0 0 0 0 0 0 9024 5558 25642065
16385 16384 t 7793476847128156026 CREATE TABLE IF NOT EXISTS "tbl001EC6050B87_1" ( 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 41.037324 41.037324 41.037324 41.037324 0 0 1352 63 42 0 0 0 0 0 0 0 0 0 281 38 199061
16385 16384 t -4296785646270357210 CREATE TABLE IF NOT EXISTS "tbl001EC6050B5D_51" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.681535 5.681535 5.681535 5.681535 0 0 616 1 1 0 0 0 0 0 0 0 0 0 154 2 17759
16385 16384 t 3976813820504157459 SELECT tableoid, oid, conname, confrelid, conindid, pg_catalog.pg_get_constraintdef(oid) AS condef FROM pg_catalog.pg_constraint WHERE conrelid = $1::pg_catalog.oid AND conparentid = $2 AND contype = $3 0 0 0 0 0 0 10 0.099705 0.008932 0.011671 0.0099705 0.0009442258469243471 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1782615689316606183 COPY public."tbl001EC6056D47_50" ("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 2732.185463 205.191515 356.28325 273.2185463 55.442652629052 223706 191 20506 75 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -7987494163966368481 DROP TABLE IF EXISTS _3b5fd77e4d2a3c4e5d1599d5dc0964b9 0 0 0 0 0 0 1 2.217334 2.217334 2.217334 2.217334 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3101446195258583315 COPY public."tbl001EC6050F42_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 1 0.0842 0.0842 0.0842 0.0842 0 13 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9088758989860567972 LOCK TABLE public."tbl001EC60537E0_41" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.6288190000000001 0.017229 0.470708 0.08983128571428571 0.15597541852091795 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -30883086997045498 COPY public."tbl001EC6056FD2_10" ("time", error, lowrange, highrange, "Horizontal_Irradiance_W_m_2_1", "POA_Irradiance_W_m_2_2", "Ambient_Temperature_Degrees_F_3", "Module_Temperature_Degrees_F_4", "Future_Use_4_5", "Future_Use_5_6", "Future_Use_6_7", "Future_Use_7_8", "Burnout_0_9", "Burnout_1_10", "Burnout_2_11", "Burnout_3_12", "Burnout_4_13", "Burnout_5_14", "Burnout_6_15", "Burnout_7_16") TO stdout 0 0 0 0 0 0 10 805.129134 58.430443 117.596492 80.5129134 18.579989145532902 226930 10 5729 22 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3693731925901927705 COPY public.conditions ("time", location, temperature, humidity) TO stdout 0 0 0 0 0 0 10 0.30671899999999996 0.020653 0.061214 0.0306719 0.011186094979482336 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6659626453431793390 COPY public."tbl001EC6050B5D_51" ("time", error, lowrange, highrange, "Analog_In_1_1", "Analog_In_2_2", "Analog_In_3_3", "Analog_In_4_4", "Pulse_1_5", "Pulse_2_6", "Pulse_3_7", "Pulse_4_8", "Status_register_9", firmware_version_10, "Uptime_Seconds_11", "Pulse_State_Register_12", "Pulse_1_ontime_Sec_sec_13", "Pulse_2_ontime_Sec_sec_14", "Pulse_3_ontime_Sec_sec_15", "Pulse_4_ontime_Sec_sec_16", "Pulse_1_last_minute_change_17", "Pulse_2_last_minute_change_18", "Pulse_3_last_minute_change_19", "Pulse_4_last_minute_change_20") TO stdout 0 0 0 0 0 0 9 14.749991000000001 0.074737 3.864124 1.638887888888889 1.2721442716464062 3554 81 25 7 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5985344997607067513 SELECT * FROM "tbl001EC6056D49_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29112 1185.857237000001 0.022279 6.859843 0.04073431014701872 0.05503387733206049 29112 87332 4 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8238557535392713271 COPY public."tbl001EC6050B08_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 261.701222 14.75383 34.704764 26.170122199999998 7.235933350368146 154845 418 593 53 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2584067341849581997 LOCK TABLE public."tbl001EC6050E0D_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.27473600000000004 0.017154 0.052144 0.027473599999999997 0.010187470001919025 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3664317575481722212 LOCK TABLE public."tbl001EC6050189_33" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.207395 0.017046 0.03929 0.023043888888888885 0.006258892082370924 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2479669705263942689 SELECT last_value, is_called FROM _timescaledb_catalog.chunk_constraint_name 0 0 0 0 0 0 10 5.898623000000001 0.023774999999999998 1.107976 0.5898623000000001 0.3237967057062348 10 2 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -88842803340586162 INSERT INTO "tbl001EC6056FD2_26" 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 15024 839.5028070000002 0.015529999999999999 88.41460099999999 0.05587744988019163 0.829932293172386 15024 92509 28 8169 274 0 0 0 0 0 0 0 0 45114 7639 35563453
16385 16384 t 606364023585675241 SELECT pg_database.datname, pg_database.datconnlimit FROM pg_database 0 0 0 0 0 0 118363 1213.1032229999967 0.006094 2.0426960000000003 0.010249007063018092 0.013041146570600872 473452 118363 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2171346355479577214 LOCK TABLE public."tbl001EC6050C0B_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.23474899999999999 0.027166 0.087574 0.03912483333333333 0.02173633485216759 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -53537418072041312 SELECT tableoid, oid, prsname, prsnamespace, prsstart::oid, prstoken::oid, prsend::oid, prsheadline::oid, prslextype::oid FROM pg_ts_parser 0 0 0 0 0 0 10 10.840814000000002 0.635086 1.9703400000000002 1.0840813999999999 0.5127303876507028 10 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7054673473658507041 COPY _timescaledb_catalog.continuous_agg (mat_hypertable_id, raw_hypertable_id, parent_mat_hypertable_id, user_view_schema, user_view_name, partial_view_schema, partial_view_name, direct_view_schema, direct_view_name, materialized_only, finalized) TO stdout 0 0 0 0 0 0 10 0.28016300000000005 0.024784 0.036351 0.0280163 0.003160737035882612 0 0 0 0 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 3005 203.2110819999997 0.021710999999999998 2.2203589999999997 0.06762432013311168 0.09563504173774577 3005 20113 30 5954 251 0 0 0 0 0 0 0 0 9024 5541 25344160