Tables

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

pg_stat_statements

userid
oid 		dbid
oid 		toplevel
boolean 		queryid
bigint 		query
text 		plans
bigint 		total_plan_time
double precision 		min_plan_time
double precision 		max_plan_time
double precision 		mean_plan_time
double precision 		stddev_plan_time
double precision 		calls
bigint 		total_exec_time
double precision 		min_exec_time
double precision 		max_exec_time
double precision 		mean_exec_time
double precision 		stddev_exec_time
double precision 		rows
bigint 		shared_blks_hit
bigint 		shared_blks_read
bigint 		shared_blks_dirtied
bigint 		shared_blks_written
bigint 		local_blks_hit
bigint 		local_blks_read
bigint 		local_blks_dirtied
bigint 		local_blks_written
bigint 		temp_blks_read
bigint 		temp_blks_written
bigint 		blk_read_time
double precision 		blk_write_time
double precision 		wal_records
bigint 		wal_fpi
bigint 		wal_bytes
numeric
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 127 2524.4664770000004 2.4509250000000002 439.053924 19.877688795275592 43.869244452641055 181298 55723 18638 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 127 2469.096461999998 2.127703 438.149625 19.44170442519685 44.46564574038528 181298 55400 18605 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 868 3872.1964840000023 0.005625000000000001 89.527405 4.461055857142854 12.777797926358145 305555 115827 21261 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 5 1.398395 0.233459 0.369466 0.279679 0.04752397981230109 125 142 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 4625 23.401035999999998 0.00024 1.840486 0.0050596834594594485 0.04589060720702814 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 6.567773 0.215477 6.352296 3.2838865 3.0684095 2 44 17 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 1 0.191437 0.191437 0.191437 0.191437 0 5 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 3 0.017157 0.005171 0.006729000000000001 0.005719 0.0007150403252031784 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 868 3793.352421000005 0.005666 91.925464 4.370221683179721 12.716994828241655 305720 125229 21396 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 68 30.29906999999999 0.09011000000000001 5.095478 0.44557455882352937 0.8621521081063973 5482 803 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 23.732022999999998 11.551976999999999 12.180046 11.866011499999999 0.31403450000000044 2 811 394 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 4.581715 0.17993 4.401785 2.2908575 2.1109275000000003 2 49 15 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 1 0.025491 0.025491 0.025491 0.025491 0 1 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 3004 4.8272290000000035 0.000331 0.096442 0.001606933754993341 0.0023446792288834032 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 1 0.5070209999999999 0.5070209999999999 0.5070209999999999 0.5070209999999999 0 108 28 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 16.444405 0.686154 15.758251000000001 8.222202500000002 7.536048500000001 2 879 147 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 1 0.014199999999999999 0.014199999999999999 0.014199999999999999 0.014199999999999999 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 1 8.862406 8.862406 8.862406 8.862406 0 24 90 51 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 1 11.672167 11.672167 11.672167 11.672167 0 1 3 217 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 10.690767000000001 0.900078 9.790689 5.3453835000000005 4.4453055 2 816 142 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 5 57.161001 0.5599510000000001 40.923659 11.4322002 14.877526191758543 5 2086 291 1 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 96.96646 20.172684 76.793776 48.48323 28.310545999999995 2 566 114 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 2.173508 0.12475 2.048758 1.086754 0.962004 2 7 6 2 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 3 3.0853070000000002 1.013419 1.0455130000000001 1.0284356666666667 0.013183094460541361 3 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 17.140813 6.070653 11.070160000000001 8.5704065 2.4997535000000006 2 701 190 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 3 0.295783 0.082249 0.12965700000000002 0.09859433333333334 0.02197467544444944 3 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 7 17.241995000000003 0.485879 5.793801 2.4631421428571434 2.1280110415883944 7 319 276 24 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 3 0.007155 0.001686 0.003566 0.002385 0.0008397789391659371 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 127 2960.924025 2.025845 432.902336 23.31436240157481 50.22682823233219 181298 55396 18639 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 127 2362.176907000001 2.094433 460.28686000000005 18.599818165354325 48.50249086358929 181292 55832 18583 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 1 0.021001000000000002 0.021001000000000002 0.021001000000000002 0.021001000000000002 0 3 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16439 16384 t <insufficient privilege> 0 0 0 0 0 0 2 7.870943 0.096057 7.7748859999999995 3.9354715 3.8394144999999997 2 13 12 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1097640641922135359 SELECT * FROM "tbl001EC6050B5D_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 14 2.376304 0.028876 1.321146 0.169736 0.32249589869042183 965 57 1 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 1955960838628559790 DROP TABLE IF EXISTS _ccafc861c6b1d39fc441af1df7a5aec0 0 0 0 0 0 0 1 0.102606 0.102606 0.102606 0.102606 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5802710290161220595 LOCK TABLE public."tbl001EC6056FD2_62" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.340359 0.017795 0.083578 0.0340359 0.022103789373996485 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 2324359234509408544 CREATE TABLE _144aa827a4fad492647307df85afaedc(cmd_output text) 0 0 0 0 0 0 1 9.253317 9.253317 9.253317 9.253317 0 0 503 4 25 0 0 0 0 0 0 0 0 0 92 25 106797
16385 16384 t 4438480536054507265 SELECT * FROM "tbl001EC6056D47_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28794 1295.916665999998 0.021686 4.862877 0.04500648280891852 0.044498397920338266 28794 86377 5 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4051327114397289912 COPY public."tbl001EC6050F3C_10" ("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.164647 0.164647 0.164647 0.164647 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2859277235430319612 SELECT name, setting, COALESCE(unit, $1), short_desc, vartype FROM pg_settings WHERE vartype IN ($2, $3, $4) AND name != $5 0 0 0 0 0 0 177228 389713.29090199544 1.055172 119.26013300000001 2.198937475466618 2.049565713242469 53168400 16 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2507011100384492216 COPY public."tbl001EC6054E88_11" ("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 3 217.460438 27.918041 157.718367 72.48681266666667 60.28890211901355 52725 124 224 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1172132525418181604 SELECT * FROM "tbl001EC6056D47_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.551272 1.201197 1.3500750000000001 1.275636 0.07443900000000009 200 118 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4328456496576460561 SELECT * FROM "tbl001EC6050189_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1660 50.773465999999985 0.010315 1.8763059999999998 0.030586425301204836 0.09786231147310427 1659 4151 19 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -640465209022114382 COPY public."tbl001EC6050B42_51" ("time", error, lowrange, highrange, "Analog_In_1_1", "Analog_In_2_2", "Analog_In_3_3", "Analog_In_4_4", "Pulse_1_5", "Pulse_2_6", "Pulse_3_7", "Pulse_4_8", "Status_register_9", firmware_version_10, "Uptime_Seconds_11", "Pulse_State_Register_12", "Pulse_1_ontime_Sec_sec_13", "Pulse_2_ontime_Sec_sec_14", "Pulse_3_ontime_Sec_sec_15", "Pulse_4_ontime_Sec_sec_16", "Pulse_1_last_minute_change_17", "Pulse_2_last_minute_change_18", "Pulse_3_last_minute_change_19", "Pulse_4_last_minute_change_20") TO stdout 0 0 0 0 0 0 6 5.081419 0.051853 1.57274 0.8469031666666667 0.5094028317485801 1500 45 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3592683811462456317 LOCK TABLE public.dl_device_type IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.45711599999999997 0.035344 0.060139 0.0457116 0.007246492837228228 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4799179982342805770 SELECT name, setting::numeric AS setting FROM pg_catalog.pg_show_all_settings() WHERE name IN($1,$2,$3,$4,$5,$6,$7,$8,$9) ORDER BY name 0 0 0 0 0 0 1 1.013272 1.013272 1.013272 1.013272 0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1674390874603308315 SELECT * FROM "tbl001EC6050B5D_5" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1592 75.073639 0.009829000000000001 1.951633 0.04715680841708546 0.08343299330261997 1591 4001 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3726855867855014023 LOCK TABLE public."tbl001EC6056FD2_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.270401 0.019188 0.048033 0.027040099999999997 0.008764475551337912 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7547780484281152998 SET client_encoding='utf-8' 0 0 0 0 0 0 4 0.021768000000000003 0.004574 0.006797 0.005442000000000001 0.0008810468205492831 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4252400313008616439 COPY public."tbl001EC6053019_53" ("time", error, lowrange, highrange, "Volts_AB_Volts_1", "Volts_BC_Volts_2", "Volts_CA_Volts_3", "Volts_LL_Average_Volts_4", "Volts_A_Volts_5", "Volts_B_Volts_6", "Volts_C_Volts_7", "Volts_LN_Average_Volts_8", "Amps_A_Amps_9", "Amps_B_Amps_10", "Amps_C_Amps_11", "Frequency_Hz_12", "KW_A_kW_13", "KW_B_kW_14", "KW_C_KW_15", "PF_Sign_A_PF_16", "PF_Sign_B_PF_17", "PF_Sign_C_PF_18", "Volt_Unbalance_19", "Current_Unbalance_20", "Delivered_Energy_kWh_21", "Received_Energy_kWh_22", "Real_Power_kW_23", "Power_Factor_PF_24", "Reactive_Power_kVAR_25") TO stdout 0 0 0 0 0 0 3 6.510424 0.15747 3.240975 2.1701413333333335 1.4241475611795134 966 52 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3656337661882901967 CREATE TABLE IF NOT EXISTS "tbl001EC6050189_6" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Active_Power_Total_kW_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_C_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 64.359033 64.359033 64.359033 64.359033 0 0 1072 3 7 0 0 0 0 0 0 0 0 0 266 5 44050
16385 16384 t -3048878174632196812 SELECT * FROM "tbl001EC6050F3C_13" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 5 0.443526 0.025910000000000002 0.143431 0.0887052 0.044060661998658164 182 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1977002247549568647 SELECT * FROM "tbl001EC6050D06_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3244 79.82029400000008 0.006992 2.137028 0.024605516029593034 0.04733364470649854 3243 8920 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9134371259352253247 CREATE TABLE IF NOT EXISTS "tbl001EC60537E0_21" ( 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 5.520495 5.520495 5.520495 5.520495 0 0 918 1 1 0 0 0 0 0 0 0 0 0 231 2 29101
16385 16384 t -2532864466293132459 SELECT * FROM "tbl001EC6050B08_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2074 126.16900999999986 0.025384 9.1254 0.06083365959498561 0.25787540570900375 2074 6186 36 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4951009737071786457 SET statement_timeout = 0 0 0 0 0 0 0 10 0.20327099999999998 0.012579 0.031617 0.0203271 0.005981878374724783 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8572223745803511587 SELECT * FROM "tbl001EC6053075_53" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 5 0.789814 0.022871 0.27689400000000003 0.1579628 0.11192240465858479 308 43 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 525121335948191611 SELECT * FROM "tbl001EC6054E88_56" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3396 76.74601000000038 0.006318000000000001 1.4325869999999998 0.022598942873969425 0.032398790221278166 3395 10163 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8546423845662519110 SELECT tableoid, oid, opfmethod, opfname, opfnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = opfowner) AS rolname FROM pg_opfamily 0 0 0 0 0 0 10 42.37410299999999 1.4848940000000002 11.559142 4.2374103 3.3828641960208823 1470 1470 20 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3659150719234830581 -- Fetches access methods SELECT oid, amname FROM pg_catalog.pg_am WHERE amtype = $1 0 0 0 0 0 0 5 0.082084 0.013684 0.019334 0.0164168 0.0022940968942047773 10 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1203062231202201875 INSERT INTO "tbl001EC6056D41_54" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$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 2987 200.62734099999963 0.02265 2.156454 0.06716683662537676 0.10061072041476019 2987 20012 30 5939 246 0 0 0 0 0 0 0 0 8970 5516 25406105
16385 16384 t -7001264197968889793 SELECT * FROM "tbl001EC6053093_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29024 1231.0456940000036 0.021988999999999998 5.260133 0.04241474965545746 0.06806116894762233 29024 116059 37 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1781943504368410970 LOCK TABLE public."tbl001EC6056D49_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.3650570000000001 0.017604 0.148407 0.036505699999999995 0.03770123258475776 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6248636260715190795 SELECT * FROM "tbl001EC6050D16_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1906 45.42521200000004 0.006265 1.758365 0.023832745015739752 0.05237422727898093 1905 5710 6 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3121421456577668548 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_10" ( 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.288676 6.288676 6.288676 6.288676 0 0 1184 0 10 0 0 0 0 0 0 0 0 0 285 11 104060
16385 16384 t 5299325378462449066 LOCK TABLE public."tbl001EC6050D06_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.736823 0.023659 0.605082 0.12280383333333332 0.21569544407521815 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8164023413121639355 COPY (SELECT key, value, include_in_telemetry FROM _timescaledb_catalog.metadata WHERE key <> 'uuid' ) TO stdout 0 0 0 0 0 0 10 3.128749 0.287025 0.357416 0.3128749 0.018372385394662294 30 286 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4995749201892890097 INSERT INTO "tbl001EC6054E7A_1" 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 748 105.66955100000008 0.036312000000000004 6.334561 0.14126945320855616 0.35484623365453183 748 4262 18 1564 81 0 0 0 0 0 0 0 0 2247 1415 6363995
16385 16384 t 7968269503055555352 COPY _timescaledb_catalog.compression_settings (relid, compress_relid, segmentby, orderby, orderby_desc, orderby_nullsfirst) TO stdout 0 0 0 0 0 0 10 0.24763 0.020434 0.028812 0.024763 0.002479061233612433 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1700357955702562591 LOCK TABLE public."tbl001EC6056300_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.425598 0.019546 0.177208 0.0425598 0.04568844950488034 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5004064929645400987 SELECT * FROM "tbl001EC6050B42_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1084 31.05883000000001 0.006189 3.290241 0.028652057195571942 0.12512745924402005 1083 2431 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 68967903307612389 COPY public."tbl001EC6053113_51" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 10 3696.800398 297.656437 425.985629 369.68003980000003 49.415975499035035 317537 1482 27703 67 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1691636211689457488 LOCK TABLE public."tbl001EC6056FD2_63" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.369068 0.020923 0.087893 0.036906800000000003 0.019929743695291217 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2976514019300773964 INSERT INTO "tbl001EC6050B08_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 14941 551.7422420000022 0.01432 69.750497 0.036928066528344544 0.6365585101542961 14941 90691 46 2221 133 0 0 0 0 0 0 0 0 44865 2046 11632487
16385 16384 t -4823108524736255565 INSERT INTO "tbl001EC6053113_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 14910 846.9869790000031 0.015404000000000001 6.166111 0.05680663843058357 0.1360606699367159 14910 91646 375 8542 449 0 0 0 0 0 0 0 0 44771 7697 35818727
16385 16384 t 71775507807620743 INSERT INTO "tbl001EC60530AB_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 14936 1036.9575470000013 0.018775 3.278182 0.06942672382163882 0.130191547099655 14936 93822 325 10590 1442 0 0 0 0 0 0 0 0 44850 7902 44417734
16385 16384 t 136252990403096131 SELECT * FROM "tbl001EC6053113_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28426 1169.7513740000054 0.021506 5.620260999999999 0.04115075543516529 0.06126960743907328 28426 85257 21 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 971599790306233887 LOCK TABLE public."tbl001EC6050F42_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.019034 0.019034 0.019034 0.019034 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1481344677969933194 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ, READ ONLY 0 0 0 0 0 0 10 0.191481 0.009105 0.068753 0.019148099999999998 0.017262922362392758 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -976334833404158609 SELECT * FROM "tbl001EC6050E0D_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 4 4.185074999999999 0.455873 2.608304 1.0462687499999999 0.9036732925909604 400 29 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 1082215851026803613 CREATE TABLE _a908b847722fa1757f671f6dff72b460(cmd_output text) 0 0 0 0 0 0 1 66.744299 66.744299 66.744299 66.744299 0 0 424 84 26 0 0 0 0 0 0 0 0 0 92 26 127338
16385 16384 t -8389198162331681533 SELECT slot_name, slot_type, CASE WHEN pg_is_in_recovery() THEN pg_last_wal_receive_lsn() - $1 ELSE pg_current_wal_lsn() - $2 END AS current_wal_lsn, COALESCE(confirmed_flush_lsn, $3) - $4 AS confirmed_flush_lsn, active, safe_wal_size, wal_status FROM pg_replication_slots 0 0 0 0 0 0 117633 1819.4744290000153 0.005306 4.078926 0.015467380998529404 0.020761806046475477 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7175220845891814510 LOCK TABLE public."tbl001EC6050F3A_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.24274099999999998 0.016914 0.039448 0.0242741 0.006515202720560581 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8273831527290367797 LOCK TABLE public."tbl001EC6050B5D_4" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.44617500000000004 0.018759 0.222285 0.049575 0.06178015371010698 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4220555902766683239 COPY public."tbl001EC6050E4D_81" ("time", error, lowrange, highrange, "Inverter_ID_ASCII_CHAR_00_01_1", "Inverter_ID_ASCII_CHAR_02_03_2", "Inverter_ID_ASCII_CHAR_04_05_3", "Inverter_ID_ASCII_CHAR_06_07_4", "Inverter_ID_ASCII_CHAR_08_09_5", "Inverter_ID_ASCII_CHAR_10_11_6", "Inverter_ID_ASCII_CHAR_12_13_7", "Inverter_ID_ASCII_CHAR_14_15_8", "Firmware_Version_ASCII_CHAR_00_01_9", "Firmware_Version_ASCII_CHAR_02_03_10", "Firmware_Version_ASCII_CHAR_04_05_11", "Firmware_Version_ASCII_CHAR_06_07_12", "Map_version_13", "Inverter_configuration_14", "Inverter_serial_ASCII_CHAR_00_01_15", "Inverter_serial_ASCII_CHAR_02_03_16", "Inverter_serial_ASCII_CHAR_04_05_17", "Inverter_serial_ASCII_CHAR_06_07_18", "Inverter_serial_ASCII_CHAR_08_09_19", "Inverter_serial_ASCII_CHAR_10_11_20", "Inverter_serial_ASCII_CHAR_12_13_21", "Inverter_serial_ASCII_CHAR_14_15_22", "Inverter_serial_ASCII_CHAR_16_17_23", "Inverter_serial_ASCII_CHAR_18_19_24", "Voltage_A_N_V_25", "Voltage_B_N_V_26", "Voltage_C_N_V_27", "Current_A_A_28", "Current_B_A_29", "Current_C_A_30", "DC_input_voltage_V_31", "DC_input_current_A_32", "Line_Frequency_Hz_33", "Output_Generation_kW_34", "Total_Energy_Generation_kWh_35", "PV_Input_Voltage_V_36", "Input_Generation_calculated_kW_37", "Inverter_operating_status_state_38", "Main_fault_39", "Drive_fault_40", "Voltage_fault_41", "Grid_fault_42", "Temperature_fault_43", "System_fault_44", "System_warnings_45", "PVM_status_codes_46") TO stdout 0 0 0 0 0 0 10 741.191483 48.643723 105.342823 74.11914829999999 16.146128240327453 80250 620 5144 10 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6520824371814131922 SELECT * FROM "tbl001EC6056FD2_69" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29010 686.6126940000073 0.012551999999999999 2.553811 0.02366813836608071 0.0244262550531363 29010 87024 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5366884980809588060 SELECT * FROM "tbl001EC6050189_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1662 51.94731099999995 0.013758 2.960045 0.031255903128760476 0.12411947405380007 1661 4157 19 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2569534678322355869 SELECT * FROM "tbl001EC6053CD9_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 5640 129.37408999999982 0.00552 2.332894 0.022938668439716255 0.06129257583669909 5639 16101 15 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7111590912746581764 SELECT * FROM "tbl001EC6050F3C_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.117484 0.117484 0.117484 0.117484 0 58 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2282511859623702562 SELECT * FROM "tbl001EC6050B87_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 25 34.018208 0.439652 2.381158 1.3607283199999998 0.46195132646665016 2249 6438 33 6 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8545590094234210170 LOCK TABLE public."tbl001EC6050D16_5" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.121948 0.017619 0.024502 0.020324666666666668 0.0023144176133292997 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1538463311646837960 COPY public."tbl001EC60537E0_2" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 7 27.132426 0.069702 7.638688 3.8760608571428574 2.409871871948052 6195 60 68 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 358573526430684676 SELECT * FROM "tbl001EC6053075_60" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 5 0.16635700000000003 0.013736 0.09208300000000001 0.033271400000000007 0.029596463941491395 117 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3456194208918900314 CREATE TABLE IF NOT EXISTS "tbl001EC6050B5D_4" ( 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.788722 6.788722 6.788722 6.788722 0 0 530 3 4 1 0 0 0 0 0 0 0 0 136 4 19423
16385 16384 t 222364002716213180 SELECT * FROM "tbl001EC6056FD2_55" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29010 717.4498849999993 0.012808 9.318468999999999 0.024731123233367673 0.06828628307161144 29010 87022 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2147222177762161648 SELECT * FROM "tbl001EC6050D16_50" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1900 56.69763999999999 0.006328 2.730394 0.02984086315789473 0.08483083060154868 1899 5691 7 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2923562830590632495 COPY public."tbl001EC6056D49_10" ("time", error, lowrange, highrange, "Horizontal_Irradiance_W_m_2_1", "POA_Irradiance_W_m_2_2", "Ambient_Temperature_Degrees_F_3", "Module_Temperature_Degrees_F_4", "Future_Use_4_5", "Future_Use_5_6", "Future_Use_6_7", "Future_Use_7_8", "Burnout_0_9", "Burnout_1_10", "Burnout_2_11", "Burnout_3_12", "Burnout_4_13", "Burnout_5_14", "Burnout_6_15", "Burnout_7_16") TO stdout 0 0 0 0 0 0 10 800.061034 56.801952 98.381627 80.00610340000001 10.960505290761036 213100 12 5418 26 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2803034468415139103 SELECT * FROM "conditions" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 7 0.168198 0.010614 0.035723 0.024028285714285714 0.008717466796434543 0 21 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2171346355479577214 LOCK TABLE public."tbl001EC6050C0B_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.23474899999999999 0.027166 0.087574 0.03912483333333333 0.02173633485216759 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1622265414344725961 INSERT INTO "tbl001EC60537AE_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 2989 383.06328099999973 0.019513000000000003 21.496297000000002 0.12815767179658752 0.45864730304372603 2989 19510 285 5978 213 0 0 0 0 0 0 0 0 8976 5584 25356319
16385 16384 t -1230337631824687512 SELECT * FROM "tbl001EC6050189_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1662 45.395968999999965 0.00763 3.6888739999999998 0.02731406077015644 0.13384601169610397 1661 4157 19 0 0 0 0 0 0 0 0 0 0 0 0 0