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_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 -5595710800441349580 INSERT INTO "tbl001EC60537E0_21" 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 2008 138.88834399999988 0.021852 2.4289929999999997 0.0691675019920319 0.1153036481378469 2008 12390 99 3687 163 0 0 0 0 0 0 0 0 6030 3829 17340337
16385 16384 t 2858289407752068825 LOCK TABLE public."tbl001EC6050B08_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.304676 0.019514 0.06263 0.030467600000000004 0.013780451307558837 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5319718725369918811 LOCK TABLE public."tbl001EC6050B87_4" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.224754 0.017896 0.037753 0.02497266666666667 0.0066947710275341845 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2903019351194623448 SELECT * FROM "tbl001EC6050BAC_8" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 3.6646780000000003 0.086806 0.5652079999999999 0.22904237499999996 0.13899531726638986 1600 1227 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2640901887234002746 LOCK TABLE public."tbl001EC6050F3C_4" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.020202 0.020202 0.020202 0.020202 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1747314206963845971 SELECT * FROM "tbl001EC6053093_55" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 4.658082 4.658082 4.658082 4.658082 0 100 51 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8665989202865055199 SELECT * FROM "tbl001EC6050D16_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2022 52.32639699999994 0.006295 1.323339 0.02587853461918895 0.04703489918970692 2021 6057 7 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1340815256189189032 COPY public."tbl001EC60506E1_3" ("time", error, lowrange, highrange, "Real_Energy_Consumption_kWh_1", "Total_Instantaneous_Real_Power_kW_2", "Total_Instantaneous_Reactive_Power_kVAR_3", "Total_Instantaneous_Apparent_Power_kVA_4", "Total_Power_Factor_5", "Voltage_L_L_3p_Ave_Volts_6", "Voltage_L_N_3p_Ave_Volts_7", "Current_3p_Ave_Amps_8", "Real_Power_Phase_A_kW_9", "Real_Power_Phase_B_kW_10", "Real_Power_Phase_C_kW_11", "Power_Factor_Phase_A_12", "Power_Factor_Phase_B_13", "Power_Factor_Phase_C_14", "Voltage_Phase_A_B_Volts_15", "Voltage_Phase_B_C_Volts_16", "Voltage_Phase_A_C_Volts_17", "Voltage_Phase_A_N_Volts_18", "Voltage_Phase_B_N_Volts_19", "Voltage_Phase_C_N_Volts_20", "Current_Instantaneous_Phase_A_Amps_21", "Current_Instantaneous_Phase_B_Amps_22", "Current_Instantaneous_Phase_C_Amps_23", "Frequency_Hz_24", "Apparent_Energy_Consumption_kVAh_25", "Reactive_Energy_Consumption_kVARh_26", "Apparent_Power_Phase_A_kVA_27", "Apparent_Power_Phase_B_kVA_28", "Apparent_Power_Phase_C_kVA_29", "Reactive_Power_Phase_A_kVAR_30", "Reactive_Power_Phase_B_kVAR_31", "Reactive_Power_Phase_C_kVAR_32", "Total_Real_Power_Present_Demand_kW_33", "Total_Reactive_Power_Present_Demand_kVAR_34", "Total_Apparent_Power_Present_Demand_kVA_35", "Total_Real_Power_Max_Demand_kW_36", "Total_Reactive_Power_Max_Demand_kVAR_37") TO stdout 0 0 0 0 0 0 10 38042.011287 3512.006094 3966.173293 3804.2011287 127.05034231534736 2069352 977 95885 599 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6583726746227148814 SELECT * FROM "tblacquisuite" ORDER BY "serialnumber" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 21 10.065593 0.17993800000000001 3.1305709999999998 0.4793139523809524 0.6713257767323428 709 272 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1697528191539421659 LOCK TABLE public."tbl001EC6050BAC_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.20392800000000003 0.022957 0.046287 0.02913257142857143 0.00823849876853688 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 228979088722466758 COPY public."tbl001EC6056D48_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 6187.9778240000005 357.949518 844.592507 618.7977824000001 149.51458132108075 226360 16 20809 63 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3997116843154597970 SELECT * FROM "tbl001EC6056FD2_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29974 766.0469910000032 0.012728999999999999 4.291805999999999 0.02555704914259031 0.06115097334723137 29974 89914 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1119721483267988313 SELECT * FROM "tbl001EC6050F3C_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 14 0.938885 0.027032 0.174316 0.06706321428571428 0.0434406530521462 183 32 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2000320538335994435 SELECT * FROM "tbl001EC6050F3C_15" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 186 7.388077 0.019511 1.308989 0.039720844086021494 0.09811009593343128 185 369 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7740093282257742299 COPY public."tbl001EC60537AE_41" ("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 10 249.402928 15.546208 54.258304 24.940292799999998 10.856235701053299 48326 272 1667 7 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6602561912392307441 COPY public."tbl001EC6050189_6" ("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 9 110.25630599999998 0.290654 24.473042 12.250700666666667 7.785690939779063 3555 149 214 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8587688206451063531 LOCK TABLE public."tbl001EC6050F3C_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.01882 0.01882 0.01882 0.01882 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3784425624046025024 INSERT INTO "tbl001EC6056D48_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 15418 805.2313160000045 0.01787 2.079257 0.05222670359320294 0.06124515061410611 15418 97415 32 11014 1414 0 0 0 0 0 0 0 0 46296 8295 46861675
16385 16384 t -4846289431997237364 INSERT INTO "tbl001EC6050D21_80" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 5140 491.432751 0.018085999999999998 3.9458080000000004 0.09560948463035031 0.2126868466751698 5140 32762 384 7072 277 0 0 0 0 0 0 0 0 15434 6494 30742064
16385 16384 t 6269218868464709517 INSERT INTO "tbl001EC6053075_6" 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 871 40.435145000000006 0.019511 1.562236 0.04642381745120556 0.06981177671332668 871 4613 6 1415 13 0 0 0 0 0 0 0 0 2616 1690 6826529
16385 16384 t -2563412158741520104 SELECT version() 0 0 0 0 0 0 364394 3957.73623700011 0.002465 31.077859 0.010861145455194137 0.1390795444880541 364394 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3498326236040789832 SELECT tableoid, oid, castsource, casttarget, castfunc, castcontext, castmethod FROM pg_cast c WHERE NOT EXISTS ( SELECT $1 FROM pg_range r WHERE c.castsource = r.rngtypid AND c.casttarget = r.rngmultitypid ) ORDER BY 3,4 0 0 0 0 0 0 10 26.979523 1.082072 5.6487300000000005 2.6979523 1.408678319749619 2240 320 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3846584520724164248 CREATE TABLE IF NOT EXISTS "tbl001EC6050189_1" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Total_kWh_Delivered_kWh_1" DOUBLE PRECISION DEFAULT NULL, "Volts_A_L_N_Volts_2" DOUBLE PRECISION DEFAULT NULL, "Volts_B_L_N_Volts_3" DOUBLE PRECISION DEFAULT NULL, "Volts_C_L_N_Volts_4" DOUBLE PRECISION DEFAULT NULL, "Current_A_Amps_5" DOUBLE PRECISION DEFAULT NULL, "Current_B_Amps_6" DOUBLE PRECISION DEFAULT NULL, "Current_C_Amps_7" DOUBLE PRECISION DEFAULT NULL, "DC_Input_Voltage_Volts_8" DOUBLE PRECISION DEFAULT NULL, "DC_Input_Current_Amps_9" DOUBLE PRECISION DEFAULT NULL, "Line_Frequency_Hz_10" DOUBLE PRECISION DEFAULT NULL, "Line_kW_kW_11" DOUBLE PRECISION DEFAULT NULL, "Inverter_Operating_Status_State_12" DOUBLE PRECISION DEFAULT NULL, "Inverter_Fault_Word_0_13" DOUBLE PRECISION DEFAULT NULL, "Inverter_Fault_Word_1_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_Fault_Word_2_15" DOUBLE PRECISION DEFAULT NULL, "Data_Comm_Status_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 4.755438 4.755438 4.755438 4.755438 0 0 528 0 37 0 0 0 0 0 0 0 0 0 133 37 187620
16385 16384 t -4503355124116637762 SELECT * FROM "tbl001EC6050F3C_14" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 13 0.7016990000000002 0.026533 0.12396 0.05397684615384615 0.036604176173777585 184 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8407289788603474140 INSERT INTO "tbl001EC6050EFC_213" 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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 3085 155.26611799999986 0.015906 3.0247949999999997 0.050329373743922254 0.14009722914283318 3085 19171 50 1513 64 0 0 0 0 0 0 0 0 9264 1380 7051957
16385 16384 t -5056560252719617479 SELECT * FROM "tbl001EC6056FD2_27" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.617521 0.18587700000000001 0.431644 0.3087605 0.12288349999999999 200 123 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5073005297833497994 SELECT * FROM "tbl001EC6050F3C_17" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 13 0.747244 0.027 0.14098100000000002 0.05748030769230769 0.03941942048979766 184 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7654655468798197847 COPY public."tbl001EC6056D41_52" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 10 563.0128719999999 36.88955 74.193709 56.3012872 12.973221219094686 44930 71 5083 10 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4269161718898731167 COPY public."tbl001EC6053075_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 3 4.103298 0.222346 2.445992 1.367766 0.909042228045907 972 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4453992619914241038 SELECT * FROM "tbl001EC6050C0B_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 42.61909899999999 0.064873 9.124141 2.6636936875000004 3.0318850489340314 876 501 40 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9121879057788891294 INSERT INTO "tbl001EC6050F3A_4" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 1028 87.70194500000001 0.022511 3.933613 0.08531317607003888 0.182476057050618 1028 6888 24 2056 86 0 0 0 0 0 0 0 0 3088 1900 8926572
16385 16384 t 898583860446654525 COPY public."tbl001EC605309C_52" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 10 3952.8821449999996 321.6061 490.23047 395.28821450000004 52.35696557088739 324420 1623 28465 116 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -5041281711439439177 DROP TABLE IF EXISTS _276d05969ee20125dee39571315bf6a1 0 0 0 0 0 0 1 0.79281 0.79281 0.79281 0.79281 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6940932957231368635 LOCK TABLE public."tbl001EC6050D05_80" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.23661000000000001 0.018648 0.038569 0.023661 0.005885911773039076 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3056796129964297839 SELECT gss_authenticated, encrypted FROM pg_catalog.pg_stat_gssapi WHERE pid = pg_backend_pid() 0 0 0 0 0 0 4 0.545503 0.091332 0.176865 0.13637575 0.030332589951857055 4 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1483896435590753858 INSERT INTO "tbl001EC6056300_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15418 736.5030309999994 0.017730000000000003 2.4171650000000002 0.04776903820210118 0.05947638885538625 15418 97171 26 9369 1040 0 0 0 0 0 0 0 0 46297 7766 39865874
16385 16384 t -3196964284402692026 COPY public."tbl001EC6056FD2_65" ("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 868.563629 62.163478 103.162998 86.85636290000001 14.280205641298624 226930 10 4636 21 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8482833367443690749 LOCK TABLE public."tbl001EC6050D16_50" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 1.50606 0.022765 1.369816 0.25101 0.5003559515917976 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7305685532470098333 SELECT * FROM "tbl001EC6050D30_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 153 981.0875619999998 0.8936630000000001 48.756394 6.4123370065359495 4.074362640976937 15300 36873 1002 7 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3559954335897267432 SELECT * FROM "tbl001EC6050F3A_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 17 21.007013 0.17322400000000002 5.545258 1.2357066470588236 1.504362783003173 1700 242 23 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3675974718356284932 SELECT * FROM "tbl001EC6056FD2_59" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.566577 0.157735 0.40884200000000004 0.2832885 0.1255535 200 104 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7660261688079897519 SELECT * FROM "tbl001EC6050B87_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 36 116.22457600000003 0.31984999999999997 33.752102 3.2284604444444445 5.678002706951061 3284 9063 79 6 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5975558315411078851 INSERT INTO "tbl001EC6050BAC_6" 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 9975 483.59729600000077 0.018564999999999998 11.179508 0.04848093192982467 0.16827582416583806 9975 60712 84 5490 195 0 0 0 0 0 0 0 0 29953 5213 24344920
16385 16384 t -3718602518408235275 INSERT INTO "tbl001EC6053093_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 15418 866.2357579999992 0.018484 3.477581 0.05618340627837601 0.07560575012655253 15418 98391 36 10603 1653 0 0 0 0 0 0 0 0 46296 7892 44145410
16385 16384 t 6934168885443855957 SELECT * FROM "tbl001EC6056FD2_27" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29974 833.2348719999928 0.012565999999999999 12.557749 0.02779858784279699 0.12683464385836402 29974 89913 9 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8624072025265664390 LOCK TABLE public."tbl001EC6053CD9_10" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.130606 0.017684 0.028179 0.021767666666666664 0.003897938842801696 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -513314514156394914 SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != $1 AND deptype != $2 UNION ALL SELECT $3::regclass AS classid, amopfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ($4, $5, $6) AND classid = $7::regclass AND objid = o.oid AND NOT (refclassid = $8::regclass AND amopfamily = refobjid) UNION ALL SELECT $9::regclass AS classid, amprocfamily AS objid, refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype NOT IN ($10, $11, $12) AND classid = $13::regclass AND objid = p.oid AND NOT (refclassid = $14::regclass AND amprocfamily = refobjid) ORDER BY 1,2 0 0 0 0 0 0 10 134.263193 12.165289 14.110764 13.426319300000001 0.6617473766119589 46849 1070 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4278819794610134327 LOCK TABLE public."tbl001EC6050BAC_8" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.13821799999999998 0.017991 0.023104 0.01974542857142857 0.0017436835277360274 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8112883250443562310 SELECT format_type(seqtypid, $1), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = $2::oid 0 0 0 0 0 0 40 0.8819049999999998 0.018085999999999998 0.039248 0.022047624999999998 0.003860909301495568 40 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5331062177372951712 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_33" ( 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 7.578662 7.578662 7.578662 7.578662 0 0 1057 1 10 1 0 0 0 0 0 0 0 0 251 9 80010
16385 16384 t 5598750748352356913 SELECT tableoid, oid, dictname, dictnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = dictowner) AS rolname, dicttemplate, dictinitoption FROM pg_ts_dict 0 0 0 0 0 0 10 13.41117 0.7648149999999999 4.4277 1.3411170000000001 1.0699507275687978 290 290 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5918460508800085194 COPY public."tbl001EC6050D21_52" ("time", error, lowrange, highrange, "umtLastMeasTime_1", "2", "umtWindSpeed_MPH_3", "4", "umtRawWindDir_Degrees_5", "6", "umtAdjWindDir_Degrees_7", "8", "umtRelHumidity_9", "10", "umtRawBaromPress_Inches_Hg_11", "12", "umtAdjBaromPress_Inches_Hg_13", "14", "umtTrueNorthOffset_Degrees_15", "16", "umtLastRain_Date_and_Time_17", "18", "umtTemp1_Degrees_F_19", "20", "umtWindChill_Degrees_F_21", "22", "umtHeatIndex_Degrees_F_23", "24", "umtDewPoint_Degrees_F_25", "26", "umtDensityAltitude_Feet_27", "28", "umtRainToday_Inches_29", "umtTemp2_Degrees_F_30", "umtTemp3_Degrees_F_31", "umtTemp4_Degrees_F_32", "umtSolarRadiation_W_m_2_33", "umtSolarRadiation_2_W_m_2_34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52") TO stdout 0 0 0 0 0 0 10 491.359766 29.756178 59.214843 49.1359766 8.84207292093352 74820 532 3067 10 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4843409424276465682 COPY public."tbl001EC6056FD2_23" ("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 501.271122 29.898687 69.323452 50.127112200000006 13.568514889508688 226930 9 2209 13 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3252903639800037311 SELECT * FROM "tbl001EC6053109_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 4664 137.36075599999972 0.006331 6.503136 0.02945127701543737 0.10133894433643045 4663 13177 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 532008296989156445 CREATE TABLE IF NOT EXISTS "tbl001EC6053109_5" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Total_Active_Power_kW_1" DOUBLE PRECISION DEFAULT NULL, "Total_Apparent_Power_kVA_2" DOUBLE PRECISION DEFAULT NULL, "Reserved_3" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_4" DOUBLE PRECISION DEFAULT NULL, "Grid_Voltage_Vab_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Grid_Voltage_Vbc_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Grid_Voltage_Vca_Volts_7" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_Amps_8" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_Amps_9" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_Amps_10" DOUBLE PRECISION DEFAULT NULL, "PV_Voltage_Volts_11" DOUBLE PRECISION DEFAULT NULL, "PV_Current_Amps_12" DOUBLE PRECISION DEFAULT NULL, "Frequency_Hz_13" DOUBLE PRECISION DEFAULT NULL, "Int_Ambient_Temperature_Degrees_C_14" DOUBLE PRECISION DEFAULT NULL, "Mode_Status_15" DOUBLE PRECISION DEFAULT NULL, "PFault_16" DOUBLE PRECISION DEFAULT NULL, "Warn_Code_17" DOUBLE PRECISION DEFAULT NULL, "Fault_0_18" DOUBLE PRECISION DEFAULT NULL, "Fault_1_19" DOUBLE PRECISION DEFAULT NULL, "Fault_2_20" DOUBLE PRECISION DEFAULT NULL, "Fault_3_21" DOUBLE PRECISION DEFAULT NULL, "Fault_4_22" DOUBLE PRECISION DEFAULT NULL, "Total_Energy_kWh_23" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 50.013426 50.013426 50.013426 50.013426 0 0 728 71 37 0 0 0 0 0 0 0 0 0 147 36 175743
16385 16384 t 5182719633096003040 SELECT * FROM "tbl001EC60537AE_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6074 155.29475699999992 0.012368 3.777745 0.02556713154428711 0.0678805284150964 6074 18211 11 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2186161206805743315 SELECT * FROM "tbl001EC6050F3A_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 23.221088 0.153891 4.2209389999999996 1.4513179999999999 1.1552879092904178 1600 235 21 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5402570621399736271 SELECT * FROM "tbl001EC6053109_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 4722 137.66207800000032 0.009066 2.736858 0.02915334138077085 0.060967690012538545 4721 13351 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 531551942583742237 SELECT * FROM "tbl001EC605309C_55" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28696 1171.3924859999984 0.02145 7.852385 0.04082075850292692 0.06733452007063444 28696 86065 23 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6129574922832005922 COPY public.dl_meter_device_data (id, "time", serial_number, device_id, sd_id, "Net Energy (kwh) 1", "Import Energy (kwh) 2", "Export Energy (kwh) 3") TO stdout 0 0 0 0 0 0 10 7850.943566 637.195692 981.173948 785.0943566 102.66445830566836 2041760 12 27068 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4438085428874792167 INSERT INTO "tbl001EC6053109_3" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 2366 103.89482499999984 0.019769 1.442072 0.043911591293322005 0.05749965908360758 2366 13916 13 1416 102 0 0 0 0 0 0 0 0 7105 1258 5959178
16385 16384 t -6075114815365001113 SELECT * FROM "tbl001EC6050BAC_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 15 3.1199929999999996 0.084058 0.47881399999999996 0.20799953333333332 0.11565269522258825 1500 779 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5242628803077053627 COPY public."tbl001EC6050B87_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 9 323.942615 1.687113 69.668815 35.99362388888889 23.675321891233278 27378 777 1663 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1251921055881146051 SELECT * FROM "tbl001EC6050BAC_5" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 19852 526.453322 0.006224 19.863142 0.026518906004432803 0.20638934661213862 19851 58746 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9115338240134872005 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_7" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 9.229113 9.229113 9.229113 9.229113 0 0 1299 4 15 0 0 0 0 0 0 0 0 0 282 15 107236
16385 16384 t 277118790170829126 CREATE TABLE IF NOT EXISTS "tbl001EC6050D30_51" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "umtLastMeasTime_1" DOUBLE PRECISION DEFAULT NULL, "2" DOUBLE PRECISION DEFAULT NULL, "umtWindSpeed_MPH_3" DOUBLE PRECISION DEFAULT NULL, "4" DOUBLE PRECISION DEFAULT NULL, "umtRawWindDir_Degrees_5" DOUBLE PRECISION DEFAULT NULL, "6" DOUBLE PRECISION DEFAULT NULL, "umtAdjWindDir_Degrees_7" DOUBLE PRECISION DEFAULT NULL, "8" DOUBLE PRECISION DEFAULT NULL, "umtRelHumidity_9" DOUBLE PRECISION DEFAULT NULL, "10" DOUBLE PRECISION DEFAULT NULL, "umtRawBaromPress_Inches_Hg_11" DOUBLE PRECISION DEFAULT NULL, "12" DOUBLE PRECISION DEFAULT NULL, "umtAdjBaromPress_Inches_Hg_13" DOUBLE PRECISION DEFAULT NULL, "14" DOUBLE PRECISION DEFAULT NULL, "umtTrueNorthOffset_Degrees_15" DOUBLE PRECISION DEFAULT NULL, "16" DOUBLE PRECISION DEFAULT NULL, "umtLastRain_Date_and_Time_17" DOUBLE PRECISION DEFAULT NULL, "18" DOUBLE PRECISION DEFAULT NULL, "umtTemp1_Degrees_F_19" DOUBLE PRECISION DEFAULT NULL, "20" DOUBLE PRECISION DEFAULT NULL, "umtWindChill_Degrees_F_21" DOUBLE PRECISION DEFAULT NULL, "22" DOUBLE PRECISION DEFAULT NULL, "umtHeatIndex_Degrees_F_23" DOUBLE PRECISION DEFAULT NULL, "24" DOUBLE PRECISION DEFAULT NULL, "umtDewPoint_Degrees_F_25" DOUBLE PRECISION DEFAULT NULL, "26" DOUBLE PRECISION DEFAULT NULL, "umtDensityAltitude_Feet_27" DOUBLE PRECISION DEFAULT NULL, "28" DOUBLE PRECISION DEFAULT NULL, "umtRainToday_Inches_29" DOUBLE PRECISION DEFAULT NULL, "umtTemp2_Degrees_F_30" DOUBLE PRECISION DEFAULT NULL, "umtTemp3_Degrees_F_31" DOUBLE PRECISION DEFAULT NULL, "umtTemp4_Degrees_F_32" DOUBLE PRECISION DEFAULT NULL, "umtSolarRadiation_W_m_2_33" DOUBLE PRECISION DEFAULT NULL, "umtSolarRadiation_2_W_m_2_34" DOUBLE PRECISION DEFAULT NULL, "35" DOUBLE PRECISION DEFAULT NULL, "36" DOUBLE PRECISION DEFAULT NULL, "37" DOUBLE PRECISION DEFAULT NULL, "38" DOUBLE PRECISION DEFAULT NULL, "39" DOUBLE PRECISION DEFAULT NULL, "40" DOUBLE PRECISION DEFAULT NULL, "41" DOUBLE PRECISION DEFAULT NULL, "42" DOUBLE PRECISION DEFAULT NULL, "43" DOUBLE PRECISION DEFAULT NULL, "44" DOUBLE PRECISION DEFAULT NULL, "45" DOUBLE PRECISION DEFAULT NULL, "46" DOUBLE PRECISION DEFAULT NULL, "47" DOUBLE PRECISION DEFAULT NULL, "48" DOUBLE PRECISION DEFAULT NULL, "49" DOUBLE PRECISION DEFAULT NULL, "50" DOUBLE PRECISION DEFAULT NULL, "51" DOUBLE PRECISION DEFAULT NULL, "52" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 16.576706 16.576706 16.576706 16.576706 0 0 886 1 39 0 0 0 0 0 0 0 0 0 218 37 196536
16385 16384 t 2870309890210432733 SELECT * FROM "tbl001EC60537E0_21" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 4016 178.6472369999999 0.009975 1.526763 0.04448387375498014 0.04529865061571734 4015 11233 3 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6297619664603229700 LOCK TABLE public."tbl001EC6050E4D_81" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.24156000000000002 0.019017 0.035194 0.024156 0.005668314017412939 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 796943977391521392 SELECT * FROM "tbl001EC6053109_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 4664 132.17052099999984 0.006264 2.542214 0.0283384478987994 0.043877490569055023 4663 13177 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4379423067294003965 LOCK TABLE public."tbl001EC6053093_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.29333699999999996 0.019529 0.04648 0.029333699999999997 0.00813392050674212 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8150836875747258729 SELECT cls.oid, cls.relname as name, indnkeyatts as col_count, CASE WHEN length(spcname::text) > $1 THEN spcname ELSE (SELECT sp.spcname FROM pg_catalog.pg_database dtb JOIN pg_catalog.pg_tablespace sp ON dtb.dattablespace=sp.oid WHERE dtb.oid = $2::oid) END as spcname, CASE contype WHEN $3 THEN desp.description WHEN $4 THEN desp.description WHEN $5 THEN desp.description ELSE des.description END AS comment, condeferrable, condeferred, conislocal, substring(pg_catalog.array_to_string(cls.reloptions, $6) from $7) AS fillfactor FROM pg_catalog.pg_index idx JOIN pg_catalog.pg_class cls ON cls.oid=indexrelid LEFT OUTER JOIN pg_catalog.pg_tablespace ta on ta.oid=cls.reltablespace LEFT JOIN pg_catalog.pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid = cls.oid AND dep.refobjsubid = $8 AND dep.refclassid=(SELECT oid FROM pg_catalog.pg_class WHERE relname=$9) AND dep.deptype=$10) LEFT OUTER JOIN pg_catalog.pg_constraint con ON (con.tableoid = dep.refclassid AND con.oid = dep.refobjid) LEFT OUTER JOIN pg_catalog.pg_description des ON (des.objoid=cls.oid AND des.classoid=$11::regclass) LEFT OUTER JOIN pg_catalog.pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = $12 AND desp.classoid=$13::regclass) WHERE indrelid = $14::oid AND contype=$15 ORDER BY cls.relname 0 0 0 0 0 0 20 2.1304889999999994 0.04598 0.738512 0.10652444999999999 0.1483277536745821 10 358 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 213989262279307712 LOCK TABLE public."tbl001EC6052F1E_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.257531 0.018377 0.041764 0.0257531 0.00814320660980673 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6154335076514956852 SELECT * FROM "tbl001EC6050D17_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 5 1.310498 0.065329 0.467005 0.2620996 0.16936924658933805 248 131 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2291304468277800628 LOCK TABLE public."tbl001EC6056D49_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 13.045033 0.02387 12.746496 1.3045033 3.8140041843983092 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8435621889981035010 SELECT * FROM "tbl001EC6050F3C_19" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 13 0.7383240000000001 0.026768 0.125137 0.05679415384615385 0.035850004014260375 184 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1214249536456541410 SELECT * FROM "tbl001EC60537AE_21" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 1.6172529999999998 1.6172529999999998 1.6172529999999998 1.6172529999999998 0 100 26 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5604826883881500556 SELECT * FROM "tbl001EC6050F3C_33" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 186 8.708193999999995 0.024487000000000002 1.312005 0.04681824731182794 0.09477807719673828 185 369 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3073447643408730005 LOCK TABLE public."tbl001EC6056300_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.27677300000000005 0.017692 0.040094 0.0276773 0.007588864606118625 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5641595971789316020 INSERT INTO "tbl001EC60537E0_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 2008 133.02861499999995 0.019226 2.512326 0.06624931025896426 0.14009293008391926 2008 12205 53 3535 64 0 0 0 0 0 0 0 0 6030 3931 17222415
16385 16384 t -5936347277077973357 INSERT INTO "tbl001EC6050D21_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 5140 489.2087720000012 0.019375999999999997 4.3916379999999995 0.09517680389105071 0.20832563234519624 5140 32594 349 6810 226 0 0 0 0 0 0 0 0 15435 6466 30203510
16385 16384 t -6241383384800274617 CREATE TABLE IF NOT EXISTS "tbl001EC6054E7A_1" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Active_Power_Total_kWh_1" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_Total_kVAR_2" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_Total_kVA_3" DOUBLE PRECISION DEFAULT NULL, "Voltage_Average_Volts_4" DOUBLE PRECISION DEFAULT NULL, "Voltage_L_L_Average_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Current_Average_Amps_6" DOUBLE PRECISION DEFAULT NULL, "System_Power_Factor_7" DOUBLE PRECISION DEFAULT NULL, "System_Frequency_Hz_8" DOUBLE PRECISION DEFAULT NULL, "Voltage_Average_Angle_Degrees_9" DOUBLE PRECISION DEFAULT NULL, "System_Quadrant_10" DOUBLE PRECISION DEFAULT NULL, "Voltage_A_Volts_11" DOUBLE PRECISION DEFAULT NULL, "Voltage_B_Volts_12" DOUBLE PRECISION DEFAULT NULL, "Voltage_C_Volts_13" DOUBLE PRECISION DEFAULT NULL, "Voltage_A_B_Volts_14" DOUBLE PRECISION DEFAULT NULL, "Voltage_B_C_Volts_15" DOUBLE PRECISION DEFAULT NULL, "Voltage_A_C_Volts_16" DOUBLE PRECISION DEFAULT NULL, "Current_A_Amps_17" DOUBLE PRECISION DEFAULT NULL, "Current_B_Amps_18" DOUBLE PRECISION DEFAULT NULL, "Current_C_Amps_19" DOUBLE PRECISION DEFAULT NULL, "Active_Power_A_kW_20" DOUBLE PRECISION DEFAULT NULL, "Active_Power_B_kW_21" DOUBLE PRECISION DEFAULT NULL, "Active_Power_C_kW_22" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_A_kVAR_23" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_B_kVAR_24" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_C_kVAR_25" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_A_kVA_26" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_B_kVA_27" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_C_kVA_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_A_29" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_B_30" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_C_31" DOUBLE PRECISION DEFAULT NULL, "Voltage_Angle_AB_Degrees_32" DOUBLE PRECISION DEFAULT NULL, "Voltage_Angle_BC_Degrees_33" DOUBLE PRECISION DEFAULT NULL, "Voltage_Angle_CA_Degrees_34" DOUBLE PRECISION DEFAULT NULL, "Quadrant_A_35" DOUBLE PRECISION DEFAULT NULL, "Quadrant_B_36" DOUBLE PRECISION DEFAULT NULL, "Quadrant_C_37" DOUBLE PRECISION DEFAULT NULL, "Sliding_Window_Power_kW_38" DOUBLE PRECISION DEFAULT NULL, "Net_Total_Energy_Revenue_kWh_39" DOUBLE PRECISION DEFAULT NULL, "Total_Net_Apparent_Energy_Revenue_kVA_40" DOUBLE PRECISION DEFAULT NULL, "Total_Import_Energy_Revenue_kWh_41" DOUBLE PRECISION DEFAULT NULL, "Total_Export_Energy_Revenue_kWh_42" DOUBLE PRECISION DEFAULT NULL, "Total_Import_Apparent_Energy_Revenue_kVA_43" DOUBLE PRECISION DEFAULT NULL, "Total_Export_Apparent_Energy_Revenue_kVA_44" DOUBLE PRECISION DEFAULT NULL, "Q1_Total_Reactive_Energy_Revenue_kVAR_45" DOUBLE PRECISION DEFAULT NULL, "Q2_Total_Reactive_Energy_Revenue_kVAR_46" DOUBLE PRECISION DEFAULT NULL, "Q3_Total_Reactive_Energy_Revenue_kVAR_47" DOUBLE PRECISION DEFAULT NULL, "Q4_Total_Reactive_Energy_Revenue_kVAR_48" DOUBLE PRECISION DEFAULT NULL, "Q1_Q2_Total_Inductive_Reactive_Energy_Revenue_kVAR_49" DOUBLE PRECISION DEFAULT NULL, "Q3_Q4_Total_Capacitive_Reactive_Energy_Revenue_kVAR_50" DOUBLE PRECISION DEFAULT NULL, "Net_Energy_Revenue_A_kWh_51" DOUBLE PRECISION DEFAULT NULL, "Net_Energy_Revenue_B_kWh_52" DOUBLE PRECISION DEFAULT NULL, "Net_Energy_Revenue_C_kWh_53" DOUBLE PRECISION DEFAULT NULL, "Net_Apparent_Energy_Revenue_A_kVA_54" DOUBLE PRECISION DEFAULT NULL, "Net_Apparent_Energy_Revenue_B_kVA_55" DOUBLE PRECISION DEFAULT NULL, "Net_Apparent_Energy_Revenue_B_kVA_56" DOUBLE PRECISION DEFAULT NULL, "Import_Energy_Revenue_A_kWh_57" DOUBLE PRECISION DEFAULT NULL, "Import_Energy_Revenue_B_kWh_58" DOUBLE PRECISION DEFAULT NULL, "Import_Energy_Revenue_C_kWh_59" DOUBLE PRECISION DEFAULT NULL, "Export_Energy_Revenue_A_kWh_60" DOUBLE PRECISION DEFAULT NULL, "Export_Energy_Revenue_B_kWh_61" DOUBLE PRECISION DEFAULT NULL, "Export_Energy_Revenue_C_kWh_62" DOUBLE PRECISION DEFAULT NULL, "Import_Apparent_Energy_Revenue_A_kVA_63" DOUBLE PRECISION DEFAULT NULL, "Import_Apparent_Energy_Revenue_B_kVA_64" DOUBLE PRECISION DEFAULT NULL, "Import_Apparent_Energy_Revenue_C_kVA_65" DOUBLE PRECISION DEFAULT NULL, "Export_Apparent_Energy_Revenue_A_kVA_66" DOUBLE PRECISION DEFAULT NULL, "Export_Apparent_Energy_Revenue_B_kVA_67" DOUBLE PRECISION DEFAULT NULL, "Export_Apparent_Energy_Revenue_C_kVA_68" DOUBLE PRECISION DEFAULT NULL, "Q1_Reactive_Energy_Revenue_A_kVAR_69" DOUBLE PRECISION DEFAULT NULL, "Q1_Reactive_Energy_Revenue_B_kVAR_70" DOUBLE PRECISION DEFAULT NULL, "Q1_Reactive_Energy_Revenue_C_kVAR_71" DOUBLE PRECISION DEFAULT NULL, "Q2_Reactive_Energy_Revenue_A_kVAR_72" DOUBLE PRECISION DEFAULT NULL, "Q2_Reactive_Energy_Revenue_B_kVAR_73" DOUBLE PRECISION DEFAULT NULL, "Q2_Reactive_Energy_Revenue_C_kVAR_74" DOUBLE PRECISION DEFAULT NULL, "Q3_Reactive_Energy_Revenue_A_kVAR_75" DOUBLE PRECISION DEFAULT NULL, "Q3_Reactive_Energy_Revenue_B_kVAR_76" DOUBLE PRECISION DEFAULT NULL, "Q3_Reactive_Energy_Revenue_C_kVAR_77" DOUBLE PRECISION DEFAULT NULL, "Q4_Reactive_Energy_Revenue_A_kVAR_78" DOUBLE PRECISION DEFAULT NULL, "Q4_Reactive_Energy_Revenue_B_kVAR_79" DOUBLE PRECISION DEFAULT NULL, "Q4_Reactive_Energy_Revenue_C_kVAR_80" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 88.002721 88.002721 88.002721 88.002721 0 0 1178 73 39 0 0 0 0 0 0 0 0 0 275 36 204917
16385 16384 t 3648052541483179029 COPY public."tbl001EC6050F3C_9" ("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.188702 0.188702 0.188702 0.188702 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9097132484277967898 COPY public."tbl001EC6050E4D_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 1176.6496149999998 81.179205 162.316758 117.66496149999999 24.42384810273281 80250 732 6524 14 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6446333969950469897 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_9" ( 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 18.055471 18.055471 18.055471 18.055471 0 0 1255 3 14 0 0 0 0 0 0 0 0 0 291 12 119661
16385 16384 t 6329167495238439826 SELECT * FROM "tbl001EC6050E0D_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 27 94.424128 0.93118 9.069935 3.4971899259259263 2.7296910953139397 2700 721 83 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6352405307059009777 INSERT INTO "tbl001EC6053109_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 2337 103.78238000000003 0.021534 2.04191 0.04440837826272988 0.07410918756746107 2337 13736 15 1392 99 0 0 0 0 0 0 0 0 7018 1239 5865164
16385 16384 t 4412257652391128852 SELECT * FROM "tbl001EC6050D21_103" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 10126 452.7617159999993 0.024332 4.047028 0.044712790440450345 0.0651182610240635 10126 30364 14 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6430365395680776529 LOCK TABLE public."tbl001EC6050B42_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.178161 0.016021 0.073933 0.029693499999999998 0.020009230967647576 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8823957638715032361 COPY public."tbl001EC6053109_3" ("time", error, lowrange, highrange, "AC_Current_Amps_1", "Phase_A_Current_Amps_2", "Phase_B_Current_Amps_3", "Phase_C_Current_Amps_4", "Phase_Voltage_AB_Volts_5", "Phase_Voltage_BC_Volts_6", "Phase_Voltage_CA_Volts_7", "Phase_Voltage_AN_Volts_8", "Phase_Voltage_BN_Volts_9", "Phase_Voltage_CN_Volts_10", "AC_Power_W_11", "Line_Frequency_Hz_12", "AC_Apparent_Power_VA_13", "AC_Reactive_Power_VAR_14", "AC_Power_Factor_15", "AC_Energy_Wh_16", "DC_Amps_Amps_17", "DC_Voltage_Volts_18", "DC_Power_W_19", "Cabinet_Temperature_Degrees_20", "Heat_Sink_Temperature_Degrees_21", "Transformer_Temperature_Degrees_22", "Other_Temperature_Degrees_23", "Operating_State_24", "Vendor_Specific_Operating_State_25", "Event_Field_26", "Reserved_for_Future_27", "Vendor_Event_1_28", "Vendor_Event_2_29", "Vendor_Event_3_30", "Vendor_Event_4_31") TO stdout 0 0 0 0 0 0 3 22.879661 1.989813 12.450032 7.626553666666666 4.308912631519646 3199 94 44 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 4172133007794251205 DROP TABLE IF EXISTS _3eb965d5de91b869d392d074e8c7251e 0 0 0 0 0 0 1 0.086189 0.086189 0.086189 0.086189 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4382635450067796333 SELECT * FROM "tbl001EC6056D41_54" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6074 257.2927889999998 0.020971999999999998 2.734306 0.042359695258478804 0.05121093889606864 6074 18216 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3311181806856466566 SELECT * FROM "tbl001EC6050D05_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 1.198616 0.553827 0.644789 0.599308 0.045480999999999994 200 91 0 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3836640283520556399 COPY public."tbl001EC6053113_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 3759.6464609999994 304.602023 438.903228 375.96464610000004 48.92123104623298 317537 1522 27915 71 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 2958157407650037299 CREATE TABLE _4a37bb5125f01151dc7937865e2037fe(cmd_output text) 0 0 0 0 0 0 1 10.842361 10.842361 10.842361 10.842361 0 0 506 6 27 0 0 0 0 0 0 0 0 0 94 27 134995
16385 16384 t 6488896354026242178 INSERT INTO "tbl001EC6050C0B_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 582 36.84914900000002 0.023618 1.3860000000000001 0.06331468900343647 0.10092877677480766 582 2919 8 1156 8 0 0 0 0 0 0 0 0 1748 1148 4480694
16385 16384 t -160145296185112948 SELECT * FROM "tbl001EC6053093_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29988 1264.3377469999946 0.021688 5.087136 0.042161456149125996 0.06378751950614608 29988 119919 33 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -1524620577522043838 DROP TABLE IF EXISTS _690b4cc4b44f444fb0c18263b1450ac0 0 0 0 0 0 0 1 0.092213 0.092213 0.092213 0.092213 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3251763472184851507 SELECT * FROM "tbl001EC6050B5D_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 23 5.746465 0.031323 1.066603 0.2498463043478261 0.26250889764124263 1637 287 2 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5762485275245656394 SELECT * FROM "tbl001EC6056FD2_64" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.9068399999999999 0.16911199999999998 0.36960699999999996 0.30228 0.09416595002795154 300 146 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 377152378701384568 UPDATE tbldevicelist SET configchangetime = $1, configchecksum = $2, config = $3 WHERE serialnumber = $4 AND deviceid = $5 0 0 0 0 0 0 158 31.471202999999996 0.028366 3.995381 0.19918482911392402 0.46182655077611323 158 1218 17 138 28 0 0 0 0 0 0 0 0 607 85 764833