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 tbl001EC605376F_1 tbl001EC605376F_2 tbl001EC605376F_21 tbl001EC605376F_3 tbl001EC605376F_37 tbl001EC605376F_42 tbl001EC60537AE_1 tbl001EC60537AE_2 tbl001EC60537AE_21 tbl001EC60537AE_41 tbl001EC60537E0_1 tbl001EC60537E0_2 tbl001EC60537E0_21 tbl001EC60537E0_3 tbl001EC60537E0_41 tbl001EC6053CD9_1 tbl001EC6053CD9_10 tbl001EC6053CD9_2 tbl001EC6053CD9_4 tbl001EC6053CD9_5 tbl001EC6054E7A_1 tbl001EC6054E88_103 tbl001EC6054E88_11 tbl001EC6054E88_2 tbl001EC6054E88_56 tbl001EC6056300_10 tbl001EC6056300_15 tbl001EC6056300_50 tbl001EC6056300_51 tbl001EC6056300_52 tbl001EC6056300_53 tbl001EC6056300_55 tbl001EC6056D41_51 tbl001EC6056D41_52 tbl001EC6056D41_53 tbl001EC6056D41_54 tbl001EC6056D41_55 tbl001EC6056D41_9 tbl001EC6056D47_10 tbl001EC6056D47_50 tbl001EC6056D47_51 tbl001EC6056D47_52 tbl001EC6056D47_9 tbl001EC6056D48_51 tbl001EC6056D48_52 tbl001EC6056D48_53 tbl001EC6056D48_54 tbl001EC6056D48_55 tbl001EC6056D48_9 tbl001EC6056D49_10 tbl001EC6056D49_51 tbl001EC6056D49_52 tbl001EC6056D49_53 tbl001EC6056D49_9 tbl001EC6056FD2_10 tbl001EC6056FD2_23 tbl001EC6056FD2_26 tbl001EC6056FD2_27 tbl001EC6056FD2_28 tbl001EC6056FD2_51 tbl001EC6056FD2_52 tbl001EC6056FD2_54 tbl001EC6056FD2_55 tbl001EC6056FD2_59 tbl001EC6056FD2_60 tbl001EC6056FD2_61 tbl001EC6056FD2_62 tbl001EC6056FD2_63 tbl001EC6056FD2_64 tbl001EC6056FD2_65 tbl001EC6056FD2_66 tbl001EC6056FD2_67 tbl001EC6056FD2_68 tbl001EC6056FD2_69 tbl001EC6056FD2_9 tbl001EC6057D26_4 tblacquisuite tbldevicelist

pg_stat_statements

userid
oid 		dbid
oid 		toplevel
boolean 		queryid
bigint 		query
text 		plans
bigint 		total_plan_time
double precision 		min_plan_time
double precision 		max_plan_time
double precision 		mean_plan_time
double precision 		stddev_plan_time
double precision 		calls
bigint 		total_exec_time
double precision 		min_exec_time
double precision 		max_exec_time
double precision 		mean_exec_time
double precision 		stddev_exec_time
double precision 		rows
bigint 		shared_blks_hit
bigint 		shared_blks_read
bigint 		shared_blks_dirtied
bigint 		shared_blks_written
bigint 		local_blks_hit
bigint 		local_blks_read
bigint 		local_blks_dirtied
bigint 		local_blks_written
bigint 		temp_blks_read
bigint 		temp_blks_written
bigint 		blk_read_time
double precision 		blk_write_time
double precision 		wal_records
bigint 		wal_fpi
bigint 		wal_bytes
numeric
16385 16384 t -3807398390925618140 CREATE TABLE IF NOT EXISTS "tbl001EC6053109_11" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "AC_Current_Amps_1" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_Amps_2" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_Amps_3" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_Amps_4" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_AB_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_BC_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_CA_Volts_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_AN_Volts_8" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_BN_Volts_9" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_CN_Volts_10" DOUBLE PRECISION DEFAULT NULL, "AC_Power_W_11" DOUBLE PRECISION DEFAULT NULL, "Line_Frequency_Hz_12" DOUBLE PRECISION DEFAULT NULL, "AC_Apparent_Power_VA_13" DOUBLE PRECISION DEFAULT NULL, "AC_Reactive_Power_VAR_14" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Factor_15" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_Wh_16" DOUBLE PRECISION DEFAULT NULL, "DC_Amps_Amps_17" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_Volts_18" DOUBLE PRECISION DEFAULT NULL, "DC_Power_W_19" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_Degrees_20" DOUBLE PRECISION DEFAULT NULL, "Heat_Sink_Temperature_Degrees_21" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_Degrees_22" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_Degrees_23" DOUBLE PRECISION DEFAULT NULL, "Operating_State_24" DOUBLE PRECISION DEFAULT NULL, "Vendor_Specific_Operating_State_25" DOUBLE PRECISION DEFAULT NULL, "Event_Field_26" DOUBLE PRECISION DEFAULT NULL, "Reserved_for_Future_27" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_1_28" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_2_29" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_3_30" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_4_31" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 10.634993 10.634993 10.634993 10.634993 0 0 877 8 10 0 0 0 0 0 0 0 0 0 165 8 44205
16385 16384 t 5167781977366854516 SELECT * FROM "tbl001EC6056300_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.293509 0.293509 0.293509 0.293509 0 100 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4114490522262863009 SELECT * FROM "tbl001EC6050B5D_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1736 54.63040800000009 0.009840000000000002 6.402473 0.031469129032258084 0.19889040900973146 1735 4396 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7699078362443148092 LOCK TABLE public."tbl001EC6050E4D_80" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.29816200000000004 0.017956 0.057643 0.027105636363636363 0.010588225950406401 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3443076231544724149 SELECT * FROM "tbl001EC6050BAC_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 18 5.820131 0.087148 0.6249060000000001 0.3233406111111112 0.20122018712073678 1800 1949 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5558153244154307186 SELECT * FROM "tbl001EC6050B5D_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1680 48.275103999999935 0.005874 2.596765 0.028735180952380923 0.10219036064883942 1679 4260 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6725907279475143812 SELECT n.nspname, r.relname FROM pg_catalog.pg_class r LEFT JOIN pg_catalog.pg_namespace n ON (r.relnamespace = n.oid) WHERE r.oid = $1 0 0 0 0 0 0 1 0.024655 0.024655 0.024655 0.024655 0 1 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7019256061890656683 INSERT INTO "tbl001EC6056D47_10" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15617 636.0697139999974 0.014501 5.392965 0.04072931510533407 0.06740442809749583 15617 96404 31 8934 430 0 0 0 0 0 0 0 0 46893 8168 38453165
16385 13761 t -9016916208729423717 DROP TABLE IF EXISTS _eb533f27f16f0838b165fa84200e9973 0 0 0 0 0 0 1 3.740121 3.740121 3.740121 3.740121 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8045472926476844391 SELECT * FROM "tbl001EC6056D41_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6156 296.7464970000013 0.022859 3.698089 0.048204434210526496 0.06260760861754537 6156 18461 7 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4663767991290876829 LOCK TABLE public."tbl001EC6050C0B_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.435015 0.045308 0.095347 0.062145000000000006 0.018973425965205726 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9000419771340478498 SELECT * FROM "tbl001EC6050B87_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 39 106.08508199999999 0.445198 21.385231 2.720130307692308 3.6017397920045076 3649 11358 55 6 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 825154149197784083 INSERT INTO "tbl001EC6050D17_2" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 385 16.76975499999999 0.022796999999999998 0.729822 0.043557805194805184 0.05849722262165756 385 1602 4 215 20 0 0 0 0 0 0 0 0 1156 188 793021
16385 16384 t -7122099020601682371 COPY public."tbl001EC6050D17_6" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "SolZone_DC_Current_1_A_15", "Critical_Alarms_16", "SolZone_DC_Current_2_A_17", "SolZone_DC_Current_3_A_18", "SolZone_DC_Current_4_A_19", "SolZone_DC_Current_5_A_20", "SolZone_DC_Current_6_A_21", "SolZone_DC_Current_7_A_22", "SolZone_DC_Current_8_A_23", "SolZone_DC_Current_Total_A_24", "Inverter_AC_Output_Current_A_25") TO stdout 0 0 0 0 0 0 1 1.962944 1.962944 1.962944 1.962944 0 328 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7382854459159488550 SELECT * FROM "tbl001EC6053093_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 4 7.363183 0.9482959999999999 4.34142 1.8407957500000003 1.444767298155031 400 213 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6359050026629502943 LOCK TABLE public."tbl001EC6054E88_103" IN ACCESS SHARE MODE 0 0 0 0 0 0 4 0.095831 0.018104 0.031916 0.02395775 0.004995511303910742 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2010864093603536362 INSERT INTO "tbl001EC6050189_32" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91,$92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104,$105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117,$118,$119,$120) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 882 79.00182300000013 0.027402999999999997 2.095975 0.0895712278911564 0.14303358541183794 882 5211 21 1856 128 0 0 0 0 0 0 0 0 2649 1622 7470098
16385 16384 t -2680168081236125065 GRANT SELECT ON TABLE public."tbl001EC60530AB_9" TO developer 0 0 0 0 0 0 1 0.365475 0.365475 0.365475 0.365475 0 0 9 0 4 0 0 0 0 0 0 0 0 0 4 4 20965
16385 16384 t -7949265479564901183 SELECT * FROM "tbl001EC6050B42_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 21 15.243129000000003 0.059932 6.27914 0.7258632857142858 1.3674274609931616 1169 206 22 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3935205920651636779 SELECT * FROM "tbl001EC605376F_21" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.059051 0.059051 0.059051 0.059051 0 2 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -504182335973093965 COPY public."tbl001EC6056D41_54" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 11 667.9357960000001 36.671938 91.336528 60.721436000000004 15.127947362529515 51007 65 5720 11 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5271777238519108401 COPY public."tbl001EC6050F3C_3" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 2 0.417246 0.105593 0.311653 0.208623 0.10303000000000001 110 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5257188998907202339 SELECT pg_roles.rolname, pg_roles.rolconnlimit FROM pg_roles 0 0 0 0 0 0 123119 1810.4212130000426 0.009174 1.2869400000000002 0.014704645205045603 0.011313333220855709 1846785 123119 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6648139170136145298 SELECT * FROM "dl_inverter_device_data" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 10 36.049886 0.103155 7.074978 3.6049886000000004 2.874882334823643 1000 58 42 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2888506741548886025 INSERT INTO "tbl001EC60537AE_41" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 3126 318.0966579999999 0.017324 3.256588 0.1017583678822776 0.22277317814651587 3126 20110 244 6018 93 0 0 0 0 0 0 0 0 9387 5974 25241358
16385 16384 t -8629156980114918718 COPY public."tbl001EC6050D16_6" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 7 1397.642429 143.156338 253.898508 199.66320414285715 30.84381143033547 472196 1212 6151 181 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6746710403892883980 CREATE TABLE IF NOT EXISTS "tbl001EC6050B42_1" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "DC_Voltage_V_1" DOUBLE PRECISION DEFAULT NULL, "Apparent_AC_Power_VA_2" DOUBLE PRECISION DEFAULT NULL, "AC_Grid_Frequency_Hz_3" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Stage_Current_A_4" DOUBLE PRECISION DEFAULT NULL, "L1_to_L2_AC_Voltage_V_5" DOUBLE PRECISION DEFAULT NULL, "L2_to_L3_AC_Voltage_V_6" DOUBLE PRECISION DEFAULT NULL, "L1_to_L3_AC_Voltage_V_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Sequence_8" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_kWh_9" DOUBLE PRECISION DEFAULT NULL, "On_Grid_Hours_Hrs_10" DOUBLE PRECISION DEFAULT NULL, "Fan_On_Time_Hours_Hrs_11" DOUBLE PRECISION DEFAULT NULL, "AC_Contactors_Cycles_12" DOUBLE PRECISION DEFAULT NULL, "Network_ID_13" DOUBLE PRECISION DEFAULT NULL, "Informative_Alarms_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 9.727576 9.727576 9.727576 9.727576 0 0 673 6 40 1 0 0 0 0 0 0 0 0 134 38 172403
16385 16384 t -2534842500058277218 LOCK TABLE public."tbl001EC6056FD2_60" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.303158 0.016733 0.041103 0.027559818181818182 0.008717055902270317 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4858777605192961403 SELECT * FROM "tbl001EC6053093_9" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.588727 0.728483 1.860244 1.2943635 0.5658805 200 65 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2954216581073452720 SELECT pg_database.datname, tmp.state, tmp2.usename, tmp2.application_name, COALESCE(count,$1) as count, COALESCE(max_tx_duration,$2) as max_tx_duration FROM ( VALUES ($3), ($4), ($5), ($6), ($7), ($8) ) AS tmp(state) CROSS JOIN pg_database LEFT JOIN ( SELECT datname, state, usename, application_name, count(*) AS count, MAX(EXTRACT($9 FROM now() - xact_start))::float AS max_tx_duration FROM pg_stat_activity GROUP BY datname,state,usename,application_name) AS tmp2 ON tmp.state = tmp2.state AND pg_database.datname = tmp2.datname 0 0 0 0 0 0 62292 20694.100927000058 0.116683 96.530806 0.3322112137513662 1.681892264445648 1496684 186882 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2735027724332309544 SELECT * FROM "tbl001EC6056300_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30436 828.074887999998 0.015946 3.0187030000000004 0.027207086607964195 0.04193359667406917 30436 121706 38 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6032960572365534161 COPY public."tbl001EC6050F3C_6" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 2 0.630569 0.111147 0.519422 0.3152845 0.20413750000000003 110 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8964346831280137895 SELECT * FROM "tbl001EC6050F3C_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 17 1.0650380000000002 0.027427999999999998 0.15945700000000002 0.06264929411764705 0.041409474851798474 235 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7102354125485349389 INSERT INTO "tbl001EC6050D21_81" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 5207 492.2968070000003 0.018862 3.007344 0.09454519051277144 0.20441347294949258 5207 33153 364 7128 289 0 0 0 0 0 0 0 0 15635 6525 30850454
16385 16384 t -7169294697585467220 SELECT * FROM "tbl001EC605309C_54" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29102 1189.7612259999976 0.021609 3.459829 0.0408824557075114 0.04957280247278058 29102 87281 25 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -8385857661538100584 DROP TABLE IF EXISTS _ae34d7a132cde6ea96e92ab14063050a 0 0 0 0 0 0 1 0.099311 0.099311 0.099311 0.099311 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -2450602143069974326 DROP TABLE IF EXISTS _4672b97ec8f992b9fe0b00b4879ed49a 0 0 0 0 0 0 1 0.107169 0.107169 0.107169 0.107169 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8868283171486367736 COPY public."tbl001EC6053093_55" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 11 31695.7303 2668.462956 3385.15627 2881.4300272727273 212.8292886832103 2344507 11755 215908 48 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8507764079609434084 COPY public."tbl001EC6050B87_103" ("time", error, lowrange, highrange, "Vln_a_Volts_1", "Vln_b_Volts_2", "Vln_c_Volts_3", "Vln_ave_Volts_4", "Vll_ab_Volts_5", "Vll_bc_Volts_6", "Vll_ca_Volts_7", "Vll_ave_Volts_8", "I_a_Amps_9", "I_b_Amps_10", "I_c_Amps_11", "I_ave_Amps_12", "V_unbal_13", "I_unbal_14", "Freq_Hz_15", "I4_Amps_16", "kW_a_kW_17", "kW_b_kW_18", "kW_c_kW_19", "kW_tot_kW_20", "kVAR_a_kVAR_21", "kVAR_b_kVAR_22", "kVAR_c_kVAR_23", "kVAR_tot_kVAR_24", "kVA_a_kVA_25", "kVA_b_kVA_26", "kVA_c_kVA_27", "kVA_tot_kVA_28", "PF_sign_a_29", "PF_sign_b_30", "PF_sign_c_31", "PF_sign_tot_32", "Vll_ave_mx_Volts_33", "I_ave_mx_Amps_34", "kW_tot_mx_kW_35", "kVAR_tot_mx_kVAR_36", "kVA_tot_mx_kVA_37", "Freq_mx_Hz_38", "Vll_ave_mn_Volts_39", "I_ave_mn_Amps_40", "Freq_mn_Hz_41", "kW_sd_del_rec_kW_42", "kVA_sd_del_rec_kVA_43", "kVAR_sd_del_rec_kVAR_44", "kW_sd_mx_d_r_kW_45", "kVA_sd_mx_d_r_kVA_46", "kVAR_sd_mx_d_r_kVAR_47", "Phase_Rev_48", "kWh_del_kWh_49", "kWh_rec_kWh_50", "kWh_del_rec_kWh_51", "kWh_del_rec_kWh_52", "kVARh_del_kVARh_53", "kVARh_rec_kVARh_54", "kVARh_del_rec_kVARh_55", "kVARh_del_rec_kVARh_56", "kVAh_del_rec_kVAh_57", "V1_THD_mx_58", "V2_THD_mx_59", "V3_THD_mx_60", "I1_THD_mx_61", "I2_THD_mx_62", "I3_THD_mx_63", unused_64) TO stdout 0 0 0 0 0 0 10 427.362105 1.823164 78.2044 42.7362105 25.99716546562504 34020 885 1386 3 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 7583218366193534547 CREATE TABLE _f775c74462a3a72bfa20636bf74231a5(cmd_output text) 0 0 0 0 0 0 1 11.339328 11.339328 11.339328 11.339328 0 0 504 4 25 1 0 0 0 0 0 0 0 0 93 25 123861
16385 16384 t -463994618235655280 INSERT INTO "tbl001EC6056FD2_9" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15619 1070.6096089999996 0.017868 77.23070999999999 0.06854533638517171 0.7753553866583173 15619 98637 57 11179 1142 0 0 0 0 0 0 0 0 46900 8767 48318198
16385 16384 t 3191969801125819197 INSERT INTO "tbl001EC60537E0_1" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 2049 125.46812600000013 0.020015 2.840313 0.061233834065397744 0.13180662400990342 2049 12479 58 3631 38 0 0 0 0 0 0 0 0 6153 4042 17375391
16385 16384 t 5178675256718892078 COPY public."tbl001EC6050189_33" ("time", error, lowrange, highrange, "Volts_A_N_Volts_1", "Volts_B_N_Volts_2", "Volts_C_N_Volts_3", "Volts_A_B_Volts_4", "Volts_B_C_Volts_5", "Volts_C_A_Volts_6", "Amps_A_Amps_7", "Amps_B_Amps_8", "Amps_C_Amps_9", "Watts_3_Ph_total_kW_10", "VARs_3_Ph_total_kVAR_11", "VAs_3_Ph_total_kVA_12", "Power_Factor_3_Ph_total_13", "Frequency_Hz_14", "Neutral_Current_Amps_15", "W_hours_Received_kWh_16", "W_hours_Delivered_kWh_17", "W_hours_Net_kWh_18", "W_hours_Total_kWh_19", "VAR_hours_Positive_kVARh_20", "VAR_hours_Negative_kVARh_21", "VAR_hours_Net_kVARh_22", "VAR_hours_Total_kVARh_23", "VA_hours_Total_kVAh_24", "Amps_A_Average_Amps_25", "Amps_B_Average_Amps_26", "Amps_C_Average_Amps_27", "Positive_Watts_3_Ph_Average_kW_28", "Positive_VARs_3_Ph_Average_kVAR_29", "Negative_Watts_3_Ph_Average_kW_30", "Negative_VARs_3_Ph_Average_kVAR_31", "VAs_3_Ph_Average_kVA_32", "Positive_PF_3_Ph_Average_33", "Negative_PF_3_Ph_Average_34", "Volts_A_N_Min_Volts_35", "Volts_B_N_Min_Volts_36", "Volts_C_N_Min_Volts_37", "Volts_A_B_Min_Volts_38", "Volts_B_C_Min_Volts_39", "Volts_C_A_Min_Volts_40", "Amps_A_Min_Avg_Demand_Amps_41", "Amps_B_Min_Avg_Demand_Amps_42", "Amps_C_Min_Avg_Demand_Amps_43", "Positive_Watts_3_Ph_Min_Avg_Demand_kW_44", "Positive_VARs_3_Ph_Min_Avg_Demand_kVAR_45", "Negative_Watts_3_Ph_Min_Avg_Demand_kW_46", "Negative_VARs_3_Ph_Min_Avg_Demand_kVAR_47", "VAs_3_Ph_Min_Avg_Demand_kVA_48", "Positive_PF_3_Ph_Min_Avg_Demand_49", "Negative_PF_3_Ph_Min_Avg_Demand_50", "Frequency_Min_Hz_51", "Volts_A_N_Max_Volts_52", "Volts_B_N_Max_Volts_53", "Volts_C_N_Max_Volts_54", "Volts_A_B_Max_Volts_55", "Volts_B_C_Max_Volts_56", "Volts_C_A_Max_Volts_57", "Amps_A_Max_Avg_Demand_Amps_58", "Amps_B_Max_Avg_Demand_Amps_59", "Amps_C_Max_Avg_Demand_Amps_60", "Positive_Watts_3_Ph_Max_Avg_Demand_kW_61", "Positive_VARs_3_Ph_Max_Avg_Demand_kVAR_62", "Negative_Watts_3_Ph_Max_Avg_Demand_kW_63", "Negative_VARs_3_Ph_Max_Avg_Demand_kVAR_64", "VAs_3_Ph_Max_Avg_Demand_kVA_65", "Positive_PF_3_Ph_Max_Avg_Demand_66", "Negative_PF_3_Ph_Max_Avg_Demand_67", "Frequency_Max_Hz_68", "Volts_A_N_THD_69", "Volts_B_N_THD_70", "Volts_C_N_THD_71", "Amps_A_THD_72", "Amps_B_THD_73", "Amps_C_THD_74", "Phase_A_Current_0th_harmonic_magnitude_75", "Phase_A_Current_1st_harmonic_magnitude_76", "Phase_A_Current_2nd_harmonic_magnitude_77", "Phase_A_Current_3rd_harmonic_magnitude_78", "Phase_A_Current_4th_harmonic_magnitude_79", "Phase_A_Current_5th_harmonic_magnitude_80", "Phase_A_Current_6th_harmonic_magnitude_81", "Phase_A_Current_7th_harmonic_magnitude_82", "Phase_A_Voltage_0th_harmonic_magnitude_83", "Phase_A_Voltage_1st_harmonic_magnitude_84", "Phase_A_Voltage_2nd_harmonic_magnitude_85", "Phase_A_Voltage_3rd_harmonic_magnitude_86", "Phase_B_Current_0th_harmonic_magnitude_87", "Phase_B_Current_1st_harmonic_magnitude_88", "Phase_B_Current_2nd_harmonic_magnitude_89", "Phase_B_Current_3rd_harmonic_magnitude_90", "Phase_B_Current_4th_harmonic_magnitude_91", "Phase_B_Current_5th_harmonic_magnitude_92", "Phase_B_Current_6th_harmonic_magnitude_93", "Phase_B_Current_7th_harmonic_magnitude_94", "Phase_B_Voltage_0th_harmonic_magnitude_95", "Phase_B_Voltage_1st_harmonic_magnitude_96", "Phase_B_Voltage_2nd_harmonic_magnitude_97", "Phase_B_Voltage_3rd_harmonic_magnitude_98", "Phase_C_Current_0th_harmonic_magnitude_99", "Phase_C_Current_1st_harmonic_magnitude_100", "Phase_C_Current_2nd_harmonic_magnitude_101", "Phase_C_Current_3rd_harmonic_magnitude_102", "Phase_C_Current_4th_harmonic_magnitude_103", "Phase_C_Current_5th_harmonic_magnitude_104", "Phase_C_Current_6th_harmonic_magnitude_105", "Phase_C_Current_7th_harmonic_magnitude_106", "Phase_C_Voltage_0th_harmonic_magnitude_107", "Phase_C_Voltage_1st_harmonic_magnitude_108", "Phase_C_Voltage_2nd_harmonic_magnitude_109", "Phase_C_Voltage_3rd_harmonic_magnitude_110", "Angle_Phase_A_Current_Degrees_111", "Angle_Phase_B_Current_Degrees_112", "Angle_Phase_C_Current_Degrees_113", "Angle_Volts_A_B_Degrees_114", "Angle_Volts_B_C_Degrees_115", "Angle_Volts_C_A_Degrees_116") TO stdout 0 0 0 0 0 0 10 48.313171 0.296984 14.311968 4.8313171 3.832594878449102 4430 43 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7939919501308767074 CREATE TABLE IF NOT EXISTS "tbl001EC6054E88_2" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "AC_Current_Amps_1" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_Amps_2" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_Amps_3" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_Amps_4" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_AB_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_BC_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_CA_Volts_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_AN_Volts_8" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_BN_Volts_9" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_CN_Volts_10" DOUBLE PRECISION DEFAULT NULL, "AC_Power_W_11" DOUBLE PRECISION DEFAULT NULL, "Line_Frequency_Hz_12" DOUBLE PRECISION DEFAULT NULL, "AC_Apparent_Power_VA_13" DOUBLE PRECISION DEFAULT NULL, "AC_Reactive_Power_VAR_14" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Factor_15" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_Wh_16" DOUBLE PRECISION DEFAULT NULL, "DC_Amps_Amps_17" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_Volts_18" DOUBLE PRECISION DEFAULT NULL, "DC_Power_W_19" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_Degrees_20" DOUBLE PRECISION DEFAULT NULL, "Heat_Sink_Temperature_Degrees_21" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_Degrees_22" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_Degrees_23" DOUBLE PRECISION DEFAULT NULL, "Operating_State_24" DOUBLE PRECISION DEFAULT NULL, "Vendor_Specific_Operating_State_25" DOUBLE PRECISION DEFAULT NULL, "Event_Field_26" DOUBLE PRECISION DEFAULT NULL, "Reserved_for_Future_27" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_1_28" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_2_29" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_3_30" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_4_31" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 12.866487 12.866487 12.866487 12.866487 0 0 794 6 40 1 0 0 0 0 0 0 0 0 165 36 180193
16385 16384 t 7965491392036753350 LOCK TABLE public."tbl001EC60537E0_21" IN ACCESS SHARE MODE 0 0 0 0 0 0 8 0.22919699999999998 0.016625 0.055513 0.028649624999999998 0.013604518770775207 0 48 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7699229737235277349 LOCK TABLE public."tbl001EC6053075_54" IN ACCESS SHARE MODE 0 0 0 0 0 0 4 0.125579 0.018052 0.061033 0.03139475 0.0173267974446376 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 8412100369504386690 DROP TABLE IF EXISTS _d66ebbbedcc1b109647008da003a6441 0 0 0 0 0 0 1 0.836717 0.836717 0.836717 0.836717 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2685102694372454242 INSERT INTO "tbl001EC6050D16_9" 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 72938 1828.4912839999997 0.01349 5.980048 0.025069117387370117 0.04821433149449592 72938 441307 79 2883 1279 0 0 0 0 0 0 0 0 219016 1488 25543390
16385 13761 t 1713736910649542189 DROP TABLE IF EXISTS _b0c5ff84e749de726ebd5920410e1afd 0 0 0 0 0 0 1 0.099245 0.099245 0.099245 0.099245 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4266456230485837525 CREATE TABLE IF NOT EXISTS "tbl001EC6053075_60" ( 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.698422 5.698422 5.698422 5.698422 0 0 621 0 1 0 0 0 0 0 0 0 0 0 154 2 17439
16385 16384 t 8000028355267691109 LOCK TABLE public."tbl001EC6054E88_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.020493 0.020493 0.020493 0.020493 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4062507763463816976 COPY public."tbl001EC6050B87_4" ("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 427.344319 1.79076 87.535355 42.734431900000004 28.11567699539473 34020 1040 2213 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5287983820714132079 SELECT * FROM "tbl001EC6056FD2_60" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.543374 0.198543 0.344831 0.271687 0.07314400000000001 200 105 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5882820203611940075 SELECT * FROM "tbl001EC6050D16_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2050 55.103445999999934 0.009404000000000001 1.4567189999999999 0.026879729756097547 0.05697809662673029 2049 6140 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5237540971498400285 LOCK TABLE public."tbl001EC6056D41_54" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.377812 0.017036 0.156046 0.03434654545454545 0.03895867854619963 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1354607080239260987 SELECT * FROM "tbl001EC6056300_55" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30436 1005.6705919999982 0.018661999999999998 5.244669 0.03304214062294653 0.05389662039130306 30436 121704 40 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6305849122312557933 LOCK TABLE public."tbl001EC6050F3C_54" IN ACCESS SHARE MODE 0 0 0 0 0 0 2 0.06113300000000001 0.027917 0.033216 0.030566500000000003 0.0026495 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8493576625560240586 LOCK TABLE public."tbl001EC60537E0_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 8 0.8865050000000001 0.022426 0.660722 0.11081312500000003 0.2080506065386722 0 48 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8452380229501441220 INSERT INTO "tbl001EC6056D41_53" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 3124 213.818804 0.019291 3.146608 0.0684439193341868 0.11431526807726115 3124 20937 33 6217 247 0 0 0 0 0 0 0 0 9381 5793 26778669
16385 16384 t 1866502492983705850 LOCK TABLE public."tbl001EC60537AE_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.287172 0.017075 0.04474 0.026106545454545455 0.009505386007786576 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4917772935881710087 INSERT INTO "tbl001EC6053075_53" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 912 50.77305100000003 0.024542 2.247345 0.0556722050438596 0.09478686398967072 912 4891 7 1487 19 0 0 0 0 0 0 0 0 2739 1760 7078870
16385 16384 t 948751100081819979 COPY public."tbl001EC6050BAC_5" ("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 8 113.498912 0.125799 30.039547 14.187363999999999 9.601088946960429 40656 446 185 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2311564133346184679 SELECT * FROM "tbl001EC6056FD2_69" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.575516 0.169598 0.405918 0.287758 0.11816000000000002 200 114 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6468746178116121976 SELECT * FROM "tbl001EC6050BAC_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 20260 634.2996560000032 0.01102 18.761881000000002 0.03130797907206333 0.23538907424767191 20259 59970 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2861465238507975545 LOCK TABLE public."tbl001EC6056FD2_10" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.23734799999999998 0.018143 0.033593 0.021577090909090914 0.003977442610397824 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3421974195165996239 INSERT INTO "tbl001EC60537E0_2" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 2049 122.74948099999986 0.018349 3.881549 0.05990701854563203 0.12726919438819148 2049 12477 50 3634 40 0 0 0 0 0 0 0 0 6153 4042 17466171
16385 16384 t 7424602414218672213 SELECT * FROM "tbl001EC6053CD9_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 10.897476 0.24040699999999998 1.686099 0.68109225 0.3733300056581141 1600 3219 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1185033151231285014 SELECT * FROM "tbl001EC6056FD2_26" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30380 886.1792150000044 0.012386 61.003955 0.02916982274522691 0.3685673144446941 30380 91128 12 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3389268267033571623 COPY _timescaledb_catalog.continuous_aggs_invalidation_threshold (hypertable_id, watermark) TO stdout 0 0 0 0 0 0 11 0.242442 0.018337 0.026051 0.022040181818181816 0.002217776602331993 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 816326308906158071 LOCK TABLE public."tbl001EC6053109_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 4 1.169034 0.026285 1.071564 0.29225850000000003 0.4499486662301045 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8445171353202245224 SELECT * FROM "tbl001EC6056D48_9" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 8.455589 1.7447949999999999 3.862792 2.8185296666666666 0.8649197599879167 300 158 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7487144296934911636 SELECT * FROM "tbl001EC6054E88_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 44 0.8948850000000002 0.007131 0.058434 0.020338295454545453 0.007033791013837628 43 87 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2234164682071750410 SELECT pg_database.datname, tmp.state, tmp2.usename, tmp2.application_name, tmp2.backend_type, tmp2.wait_event_type, tmp2.wait_event, COALESCE(count,$1) as count, COALESCE(max_tx_duration,$2) as max_tx_duration FROM ( VALUES ($3), ($4), ($5), ($6), ($7), ($8) ) AS tmp(state) CROSS JOIN pg_database LEFT JOIN ( SELECT datname, state, usename, application_name, backend_type, wait_event_type, wait_event, count(*) AS count, MAX(EXTRACT($9 FROM now() - xact_start))::float AS max_tx_duration FROM pg_stat_activity GROUP BY datname,state,usename,application_name,backend_type,wait_event_type,wait_event) AS tmp2 ON tmp.state = tmp2.state AND pg_database.datname = tmp2.datname 0 0 0 0 0 0 123165 31863.665903999867 0.10867399999999999 11.293045 0.25870714816709084 0.2819099959282997 2961121 369499 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4337756129632943798 SELECT * FROM "tbl001EC6050B42_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 18 46.22303900000001 0.15657600000000002 13.714274999999999 2.567946611111111 3.5718564892695066 872 599 39 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4849130448645965842 CREATE TABLE IF NOT EXISTS "tbl001EC6050B87_4" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 6.073179 6.073179 6.073179 6.073179 0 0 1188 4 4 0 0 0 0 0 0 0 0 0 282 3 42556
16385 16384 t -7031529706220198399 INSERT INTO "tbl001EC6056D47_52" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$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 15617 827.9990460000039 0.019045000000000003 2.6707050000000003 0.053019084715374316 0.0580839973798455 15617 98712 29 10926 1459 0 0 0 0 0 0 0 0 46895 8329 46728336
16385 16384 t -9172064478907096889 SELECT * FROM "tbl001EC60537AE_41" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6156 178.073583000001 0.014889 3.268839 0.028926832846003947 0.08405167231525346 6156 18455 13 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5050801751044497527 LOCK TABLE public."tbl001EC6050189_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.245538 0.018599 0.040716 0.0245538 0.006416326905636901 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -674038025542622133 SELECT * FROM "tbl001EC60506E1_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 4 10.247734000000001 1.8254860000000002 3.995549 2.5619335000000003 0.8554342479187106 400 75 0 62 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7912229323653662776 COPY public."tbl001EC6050D15_8" ("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", "SolZone_DC_Current_1_A_15", "Critical_Alarms_16", "SolZone_DC_Current_2_A_17", "SolZone_DC_Current_3_A_18", "SolZone_DC_Current_4_A_19", "SolZone_DC_Current_5_A_20", "SolZone_DC_Current_6_A_21", "SolZone_DC_Current_7_A_22", "SolZone_DC_Current_8_A_23", "SolZone_DC_Current_Total_A_24", "Inverter_AC_Output_Current_A_25") TO stdout 0 0 0 0 0 0 1 0.960676 0.960676 0.960676 0.960676 0 190 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7759290256693114698 INSERT INTO "tbl001EC6050D16_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 71634 1720.6448990000051 0.013413 5.041658 0.02401994721780171 0.039529834141691145 71634 430653 16 2053 667 0 0 0 0 0 0 0 0 215100 1400 19542698
16385 16384 t -1147076646617766500 INSERT INTO "tbl001EC6050F3C_17" 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 107 5.300168000000004 0.028126 0.181213 0.04953428037383178 0.022842683813624892 107 429 0 213 2 0 0 0 0 0 0 0 0 323 210 485505
16385 13761 t 8766662049460185223 DROP TABLE IF EXISTS _c9a3c9c4c96f52739fc931dd3c85fea5 0 0 0 0 0 0 1 0.099895 0.099895 0.099895 0.099895 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7920840661849931591 LOCK TABLE public."tbl001EC6050F3C_19" IN ACCESS SHARE MODE 0 0 0 0 0 0 2 0.040278 0.018356 0.021922 0.020139 0.0017829999999999999 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5219821731494902451 SELECT * FROM "tbl001EC605376F_37" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.036185 0.036185 0.036185 0.036185 0 13 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7042608471921534433 SELECT * FROM "tbl001EC6050B42_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1176 41.74530800000003 0.006266 3.717879 0.03549771088435374 0.14476203622901204 1175 2709 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6759341487788057522 CREATE TABLE IF NOT EXISTS "tbl001EC6050B5D_3" ( 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.088426 6.088426 6.088426 6.088426 0 0 741 2 9 0 0 0 0 0 0 0 0 0 133 10 45755
16385 16384 t 3880042997025571215 COPY public."tbl001EC6050189_3" ("time", error, lowrange, highrange, "Air_Temperture_Degrees_F_1", "Air_Temperture_Ave_Degrees_F_2", "Air_Temperture_Min_Degrees_F_3", "Air_Temperture_Max_Degrees_F_4", "5", "Air_Humidity_Percent_RH_6", "Air_Humidity_Ave_Percent_RH_7", "Air_Humidity_Min_Percent_RH_8", "Air_Humidity_Max_Percent_RH_9", "10", "Solar_Radiation_W_m_2_11", "Solar_Radiation_Ave_W_m_2_12", "Solar_Radiation_Min_W_m_2_13", "Solar_Radiation_Max_W_m_2_14", "15", "Cell_Temp_Degrees_F_16", "Cell_Temp_Ave_Degrees_F_17", "Cell_Temp_Min_Degrees_F_18", "Cell_Temp_Max_Degrees_F_19", "20", "Input_5_21", "22", "23", "24", "25", "Input_6_26", "27", "28", "29", "30", "Input_7_31", "32", "33", "34", "35", "Input_8_36", "37", "38", "39", "40", "Output_01_41", "Output_02_42") TO stdout 0 0 0 0 0 0 10 17.985835 0.092648 3.645465 1.7985835000000001 1.3523104165185782 4430 38 4 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1621546755950763065 LOCK TABLE public."tbl001EC6050D15_10" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.020639 0.020639 0.020639 0.020639 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3261792993074736256 LOCK TABLE public."tbl001EC6053113_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.3158 0.018175 0.053598 0.02870909090909091 0.010731448224342115 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1411430376214230471 COPY public."tbl001EC6050B42_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 7 11.107116 0.119083 3.075298 1.586730857142857 0.9425259082388935 2086 99 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8900078187842424798 SELECT * FROM "tbl001EC6053109_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 19.433052 0.474397 4.577703 1.21456575 1.0106853094271913 1600 4403 9 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3749377945714295245 SELECT * FROM "tbl001EC6053109_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 19.682293 0.43711500000000003 3.727664 1.2301433125 0.8352557202367517 1600 5354 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4639381243785674786 SELECT pg_cancel_backend($1) 0 0 0 0 0 0 1 0.088241 0.088241 0.088241 0.088241 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1400290634027824155 INSERT INTO "tbl001EC6050D16_4" 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 71866 1858.325659000009 0.013004 4.913194 0.025858203587231957 0.046038964733915354 71866 435303 94 2989 1310 0 0 0 0 0 0 0 0 215797 1519 25989289
16385 16384 t 7734487139114747469 COPY public."tbl001EC605309C_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 11 4267.4764860000005 303.020591 478.706757 387.9524078181818 65.13370709222592 364754 1820 32078 118 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4675717232608707480 INSERT INTO "tbl001EC605376F_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 13 0.544945 0.025301 0.13838699999999998 0.041918846153846154 0.029117282493778242 13 53 0 25 2 0 0 0 0 0 0 0 0 40 22 21457
16385 16384 t -4241135643122138936 SELECT * FROM "tbl001EC6050BAC_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 20260 473.31531800000005 0.0057209999999999995 3.682004 0.023362059131293293 0.0495206540600317 20259 59970 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4028695448042013440 SELECT * FROM "tbl001EC6050B5D_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 39 81.763328 0.026588999999999998 13.643412000000001 2.0964955897435895 2.8701715566844688 2145 980 62 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1783371210659433190 SELECT * FROM "tbl001EC6050F3C_8" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 1.031948 0.027803 0.231765 0.06449674999999999 0.05520743309385521 184 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0