Tables

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

pg_stat_statements

userid
oid 		dbid
oid 		toplevel
boolean 		queryid
bigint 		query
text 		plans
bigint 		total_plan_time
double precision 		min_plan_time
double precision 		max_plan_time
double precision 		mean_plan_time
double precision 		stddev_plan_time
double precision 		calls
bigint 		total_exec_time
double precision 		min_exec_time
double precision 		max_exec_time
double precision 		mean_exec_time
double precision 		stddev_exec_time
double precision 		rows
bigint 		shared_blks_hit
bigint 		shared_blks_read
bigint 		shared_blks_dirtied
bigint 		shared_blks_written
bigint 		local_blks_hit
bigint 		local_blks_read
bigint 		local_blks_dirtied
bigint 		local_blks_written
bigint 		temp_blks_read
bigint 		temp_blks_written
bigint 		blk_read_time
double precision 		blk_write_time
double precision 		wal_records
bigint 		wal_fpi
bigint 		wal_bytes
numeric
16385 16384 t -9142878422705327836 SELECT * FROM "tbl001EC6056FD2_61" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.582668 0.174392 0.40827600000000003 0.291334 0.116942 200 106 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3162701964860037009 SELECT * FROM "tbl001EC6050E4D_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 9924 462.5357990000001 0.024575 4.721833 0.04660779917372049 0.0812533753197472 9924 29754 18 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -543399783242700663 INSERT INTO "tbl001EC6053075_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 810 45.59570800000007 0.027048 1.420365 0.05629099753086419 0.07626285767065004 810 4245 6 1283 16 0 0 0 0 0 0 0 0 2433 1559 6441497
16385 16384 t 2466502583662600051 SELECT * FROM "tbl001EC6056D41_54" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.427728 1.1771719999999999 1.250556 1.213864 0.03669200000000011 200 39 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6423888068504112425 SELECT * FROM "tbl001EC6056FD2_63" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.555469 0.192349 0.36312 0.2777345 0.0853855 200 110 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1093602067063124043 LOCK TABLE public."tbl001EC6050EFC_213" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.237921 0.017693 0.040329 0.023792099999999997 0.0059661845504476296 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4279362306221260445 INSERT INTO "tbl001EC6053019_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 808 43.88474799999995 0.024414 1.3736760000000001 0.054312806930693125 0.07783118559075615 808 4321 8 1574 46 0 0 0 0 0 0 0 0 2427 1516 6555304
16385 16384 t 5259533636556229473 SELECT $2 FROM tblacquisuite WHERE serialnumber = $1 0 0 0 0 0 0 17 0.103276 0.004179 0.008195000000000001 0.006075058823529412 0.0011301652909088504 0 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1559975843590425260 LOCK TABLE public."tbl001EC6053075_7" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.106992 0.018323 0.067093 0.035664 0.022263303633258628 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5735114473754242621 LOCK TABLE public."tbl001EC60537E0_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.17760399999999998 0.020171 0.04491 0.025372 0.00814575893158081 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2308836631747709547 SELECT * FROM "tbl001EC6050F42_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 7 0.9715170000000001 0.040644 0.268195 0.13878814285714286 0.09604328079930359 202 26 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4031099412622343691 SELECT * FROM "tbl001EC6053093_53" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29380 1238.621767999993 0.022029 4.877320999999999 0.042158671477195195 0.061961177163805295 29380 117485 35 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 47264228575527639 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_6" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 7.865975 7.865975 7.865975 7.865975 0 0 1255 3 15 0 0 0 0 0 0 0 0 0 289 13 118554
16385 16384 t -1014136949146312108 COPY public."tbl001EC6053113_9" ("time", error, lowrange, highrange, "Active_Power_Total_kW_1", "Reactive_Power_Total_kVAR_2", "Apparent_Power_Total_kVA_3", "Voltage_Average_Volts_4", "Voltage_L_L_Average_Volts_5", "Current_Average_Amps_6", "System_Power_Factor_7", "System_Frequency_Hz_8", "Voltage_Average_Angle_Degrees_9", "System_Quadrant_10", "Voltage_A_Volts_11", "Voltage_B_Volts_12", "Voltage_C_Volts_13", "Voltage_A_B_Volts_14", "Voltage_B_C_Volts_15", "Voltage_A_C_Volts_16", "Current_A_Amps_17", "Current_B_Amps_18", "Current_C_Amps_19", "Active_Power_A_kW_20", "Active_Power_B_kW_21", "Active_Power_C_kW_22", "Reactive_Power_A_kVAR_23", "Reactive_Power_B_kVAR_24", "Reactive_Power_C_kVAR_25", "Apparent_Power_A_kVA_26", "Apparent_Power_B_kVA_27", "Apparent_Power_C_kVA_28", "Power_Factor_A_29", "Power_Factor_B_30", "Power_Factor_C_31", "Voltage_Angle_AB_Degrees_32", "Voltage_Angle_BC_Degrees_33", "Voltage_Angle_CA_Degrees_34", "Quadrant_A_35", "Quadrant_B_36", "Quadrant_C_37", "Sliding_Window_Power_kW_38", "Net_Total_Energy_Revenue_kWh_39", "Total_Net_Apparent_Energy_Revenue_kVA_40", "Total_Import_Energy_Revenue_kWh_41", "Total_Export_Energy_Revenue_kWh_42", "Total_Import_Apparent_Energy_Revenue_kVA_43", "Total_Export_Apparent_Energy_Revenue_kVA_44", "Q1_Total_Reactive_Energy_Revenue_kVAR_45", "Q2_Total_Reactive_Energy_Revenue_kVAR_46", "Q3_Total_Reactive_Energy_Revenue_kVAR_47", "Q4_Total_Reactive_Energy_Revenue_kVAR_48", "Q1_Q2_Total_Inductive_Reactive_Energy_Revenue_kVAR_49", "Q3_Q4_Total_Capacitive_Reactive_Energy_Revenue_kVAR_50", "Net_Energy_Revenue_A_kWh_51", "Net_Energy_Revenue_B_kWh_52", "Net_Energy_Revenue_C_kWh_53", "Net_Apparent_Energy_Revenue_A_kVA_54", "Net_Apparent_Energy_Revenue_B_kVA_55", "Net_Apparent_Energy_Revenue_C_kVA_56", "Import_Energy_Revenue_A_kWh_57", "Import_Energy_Revenue_B_kWh_58", "Import_Energy_Revenue_C_kWh_59", "Export_Energy_Revenue_A_kWh_60", "Export_Energy_Revenue_B_kWh_61", "Export_Energy_Revenue_C_kWh_62", "Import_Apparent_Energy_Revenue_A_kVA_63", "Import_Apparent_Energy_Revenue_B_kVA_64", "Import_Apparent_Energy_Revenue_C_kVA_65", "Export_Apparent_Energy_Revenue_A_kVA_66", "Export_Apparent_Energy_Revenue_B_kVA_67", "Export_Apparent_Energy_Revenue_C_kVA_68", "Q1_Reactive_Energy_Revenue_A_kVAR_69", "Q1_Reactive_Energy_Revenue_B_kVAR_70", "Q1_Reactive_Energy_Revenue_C_kVAR_71", "Q2_Reactive_Energy_Revenue_A_kVAR_72", "Q2_Reactive_Energy_Revenue_B_kVAR_73", "Q2_Reactive_Energy_Revenue_C_kVAR_74", "Q3_Reactive_Energy_Revenue_A_kVAR_75", "Q3_Reactive_Energy_Revenue_B_kVAR_76", "Q3_Reactive_Energy_Revenue_C_kVAR_77", "Q4_Reactive_Energy_Revenue_A_kVAR_78", "Q4_Reactive_Energy_Revenue_B_kVAR_79", "Q4_Reactive_Energy_Revenue_C_kVAR_80") TO stdout 0 0 0 0 0 0 10 9256.925318000001 618.550531 1183.798684 925.6925318000001 156.74031495958454 317547 15417 13982 68 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5390067703774388680 SELECT * FROM "tbl001EC6056FD2_9" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 4 5.063658 1.046672 1.716818 1.2659145 0.2639669104248674 400 227 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3447086268070231648 SELECT tableoid, oid, datname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = datdba) AS dba, pg_encoding_to_char(encoding) AS encoding, datcollate, datctype, datfrozenxid, datminmxid, (SELECT array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM unnest(coalesce(datacl,acldefault($1,datdba))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM unnest(acldefault($3,datdba)) AS init(init_acl) WHERE acl = init_acl)) AS datacls) AS datacl, (SELECT array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM unnest(acldefault($4,datdba)) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM unnest(coalesce(datacl,acldefault($6,datdba))) AS permp(orig_acl) WHERE acl = orig_acl)) AS rdatacls) AS rdatacl, datistemplate, datconnlimit, (SELECT spcname FROM pg_tablespace t WHERE t.oid = dattablespace) AS tablespace, shobj_description(oid, $7) AS description FROM pg_database WHERE datname = current_database() 0 0 0 0 0 0 10 30.516837999999996 1.872362 5.2425370000000004 3.0516837999999997 0.9065552466109058 10 458 18 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8144351327510176565 INSERT INTO "tbl001EC6052F1E_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 15114 1096.2561670000032 0.019364999999999997 7.198867 0.07253249748577484 0.1634125403694044 15114 94964 325 10680 1458 0 0 0 0 0 0 0 0 45383 8025 45222663
16385 16384 t 6778347650208099117 LOCK TABLE public."tbl001EC6053109_5" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.19894799999999999 0.020564 0.157381 0.066316 0.0643929284367986 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6651153203553026563 SELECT * FROM "tbl001EC6050C0B_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 8 5.783278000000001 0.122059 1.61825 0.72290975 0.6012899376922397 800 49 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7285734346305706309 LOCK TABLE public."tbl001EC60537E0_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.408823 0.017548 0.266714 0.05840328571428572 0.08523936242590925 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5301630379863663174 INSERT INTO "tbl001EC6050B87_103" 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 6417 418.5071080000011 0.023323999999999998 3.304014 0.06521849898706551 0.13538638725452465 6417 40060 237 6995 454 0 0 0 0 0 0 0 0 19269 6105 29781056
16385 16384 t -1810787062694619558 CREATE TABLE IF NOT EXISTS "tbl001EC6050D06_51" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "umtLastMeasTime_1" DOUBLE PRECISION DEFAULT NULL, "2" DOUBLE PRECISION DEFAULT NULL, "umtWindSpeed_MPH_3" DOUBLE PRECISION DEFAULT NULL, "4" DOUBLE PRECISION DEFAULT NULL, "umtRawWindDir_Degrees_5" DOUBLE PRECISION DEFAULT NULL, "6" DOUBLE PRECISION DEFAULT NULL, "umtAdjWindDir_Degrees_7" DOUBLE PRECISION DEFAULT NULL, "8" DOUBLE PRECISION DEFAULT NULL, "umtRelHumidity_9" DOUBLE PRECISION DEFAULT NULL, "10" DOUBLE PRECISION DEFAULT NULL, "umtRawBaromPress_Inches_Hg_11" DOUBLE PRECISION DEFAULT NULL, "12" DOUBLE PRECISION DEFAULT NULL, "umtAdjBaromPress_Inches_Hg_13" DOUBLE PRECISION DEFAULT NULL, "14" DOUBLE PRECISION DEFAULT NULL, "umtTrueNorthOffset_Degrees_15" DOUBLE PRECISION DEFAULT NULL, "16" DOUBLE PRECISION DEFAULT NULL, "umtLastRain_Date_and_Time_17" DOUBLE PRECISION DEFAULT NULL, "18" DOUBLE PRECISION DEFAULT NULL, "umtTemp1_Degrees_F_19" DOUBLE PRECISION DEFAULT NULL, "20" DOUBLE PRECISION DEFAULT NULL, "umtWindChill_Degrees_F_21" DOUBLE PRECISION DEFAULT NULL, "22" DOUBLE PRECISION DEFAULT NULL, "umtHeatIndex_Degrees_F_23" DOUBLE PRECISION DEFAULT NULL, "24" DOUBLE PRECISION DEFAULT NULL, "umtDewPoint_Degrees_F_25" DOUBLE PRECISION DEFAULT NULL, "26" DOUBLE PRECISION DEFAULT NULL, "umtDensityAltitude_Feet_27" DOUBLE PRECISION DEFAULT NULL, "28" DOUBLE PRECISION DEFAULT NULL, "umtRainToday_Inches_29" DOUBLE PRECISION DEFAULT NULL, "umtTemp2_Degrees_F_30" DOUBLE PRECISION DEFAULT NULL, "umtTemp3_Degrees_F_31" DOUBLE PRECISION DEFAULT NULL, "umtTemp4_Degrees_F_32" DOUBLE PRECISION DEFAULT NULL, "umtSolarRadiation_W_m_2_33" DOUBLE PRECISION DEFAULT NULL, "umtSolarRadiation_2_W_m_2_34" DOUBLE PRECISION DEFAULT NULL, "35" DOUBLE PRECISION DEFAULT NULL, "36" DOUBLE PRECISION DEFAULT NULL, "37" DOUBLE PRECISION DEFAULT NULL, "38" DOUBLE PRECISION DEFAULT NULL, "39" DOUBLE PRECISION DEFAULT NULL, "40" DOUBLE PRECISION DEFAULT NULL, "41" DOUBLE PRECISION DEFAULT NULL, "42" DOUBLE PRECISION DEFAULT NULL, "43" DOUBLE PRECISION DEFAULT NULL, "44" DOUBLE PRECISION DEFAULT NULL, "45" DOUBLE PRECISION DEFAULT NULL, "46" DOUBLE PRECISION DEFAULT NULL, "47" DOUBLE PRECISION DEFAULT NULL, "48" DOUBLE PRECISION DEFAULT NULL, "49" DOUBLE PRECISION DEFAULT NULL, "50" DOUBLE PRECISION DEFAULT NULL, "51" DOUBLE PRECISION DEFAULT NULL, "52" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 7.427908 7.427908 7.427908 7.427908 0 0 940 3 7 0 0 0 0 0 0 0 0 0 223 4 32271
16385 16384 t 1481298891468563241 INSERT INTO "tbl001EC6056D41_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 3022 200.75922999999997 0.021461 2.8264359999999997 0.06643257114493711 0.10272057398898948 3022 20230 30 6014 238 0 0 0 0 0 0 0 0 9075 5603 26015545
16385 16384 t 1255201685574703200 SELECT * FROM "tbl001EC6050EFC_211" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.486446 0.091112 0.21253 0.16214866666666666 0.051675685948250574 300 11 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4191852244464738492 SELECT * FROM "tbl001EC6050F3C_18" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 7 0.518796 0.025165 0.158914 0.07411371428571428 0.05284171541422901 184 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4464050853188236084 INSERT INTO "tbl001EC6050D16_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 71488 1876.7857440000012 0.013993 23.052303 0.02625315778871979 0.1530322677655552 71488 431537 65 2570 1054 0 0 0 0 0 0 0 0 214661 1407 23033765
16385 16384 t 7973422782868749031 SELECT * FROM "tbl001EC6050BAC_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 19246 464.34843099999927 0.005934 6.845936 0.024127009820222214 0.07795841447330804 19245 56928 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -740925541889455302 INSERT INTO "tbl001EC6050189_3" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 845 51.987224999999974 0.024184 2.1111289999999996 0.061523343195266256 0.1056569541546193 845 4653 13 1688 12 0 0 0 0 0 0 0 0 2538 1674 6919963
16385 16384 t 7210094259165500157 COPY public."tbl001EC6053093_52" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 10 29042.035997 2702.706142 3463.098254 2904.2035997000003 221.6425448080342 2124170 13590 193329 48 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6041753501239686385 SELECT label, provider, classoid, objoid, objsubid FROM pg_catalog.pg_seclabels ORDER BY classoid, objoid, objsubid 0 0 0 0 0 0 10 0.6313219999999999 0.052948 0.08618 0.0631322 0.009757384995991502 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3136621428048855640 SELECT * FROM "tbl001EC6056FD2_66" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.175702 0.175702 0.175702 0.175702 0 100 58 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -487782752528436112 LOCK TABLE public."tbl001EC6053075_60" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.06395500000000001 0.016494 0.024803 0.021318333333333335 0.003521921855401615 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7080107192945824283 SELECT proretset, prosrc, probin, provolatile, proisstrict, prosecdef, lanname, proconfig, procost, prorows, pg_catalog.pg_get_function_arguments(p.oid) AS funcargs, pg_catalog.pg_get_function_identity_arguments(p.oid) AS funciargs, pg_catalog.pg_get_function_result(p.oid) AS funcresult, proleakproof, array_to_string(protrftypes, $1) AS protrftypes, proparallel, prokind, prosupport, pg_get_function_sqlbody(p.oid) AS prosqlbody FROM pg_catalog.pg_proc p, pg_catalog.pg_language l WHERE p.oid = $2::pg_catalog.oid AND l.oid = p.prolang 0 0 0 0 0 0 10 0.707889 0.050003 0.13275900000000002 0.0707889 0.030449615939942498 10 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1972656841938399703 LOCK TABLE public."tbl001EC6050F3C_7" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.024047 0.024047 0.024047 0.024047 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -103895548928141570 SELECT tableoid, oid, adnum, pg_catalog.pg_get_expr(adbin, adrelid) AS adsrc FROM pg_catalog.pg_attrdef WHERE adrelid = $1::pg_catalog.oid 0 0 0 0 0 0 1831 515.2691670000003 0.059292 10.524166 0.28141407263790397 0.4813093591933828 7014 26010 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4779904649776074801 COPY public."tbl001EC6050C0B_3" ("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 6 18.904336999999998 0.163362 6.346145 3.150722833333333 2.0648386564553833 1536 119 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5894978824816972872 SELECT pid, locktype, datname, relation::regclass, page, tuple, virtualxid transactionid, classid::regclass, objid, objsubid, virtualtransaction, mode, granted, fastpath FROM pg_catalog.pg_locks l LEFT OUTER JOIN pg_catalog.pg_database d ON (l.database = d.oid) WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = $1)ORDER BY pid, locktype 0 0 0 0 0 0 4 0.509414 0.107184 0.166575 0.12735349999999998 0.023098291111032426 4 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 2064747130947873400 CREATE TABLE _7b39a21ac0c4a9821e6d26376e0be03b(cmd_output text) 0 0 0 0 0 0 1 11.804576 11.804576 11.804576 11.804576 0 0 502 5 25 0 0 0 0 0 0 0 0 0 93 25 115115
16385 13761 t -8217787928374346230 DROP TABLE IF EXISTS _7b39a21ac0c4a9821e6d26376e0be03b 0 0 0 0 0 0 1 1.007686 1.007686 1.007686 1.007686 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4339902332375380363 SELECT * FROM "tbl001EC60506E1_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 6 0.885051 0.10047500000000001 0.216586 0.1475085 0.04033901219973043 600 29 0 10 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6373610154267527019 INSERT INTO tbldevicelist (serialnumber, deviceid, devicename, devicetype, deviceclass, config, configchangetime, configchecksum, datatablename) VALUES ($1, $2, $3, $4, $5, $6, CURRENT_TIMESTAMP, $7, $8) ON CONFLICT (serialnumber, deviceid) DO NOTHING 0 0 0 0 0 0 113 15.528258000000001 0.027647 1.94123 0.13741821238938043 0.34024662123725896 113 572 19 54 0 0 0 0 0 0 0 0 0 340 51 327592
16385 16384 t 4498663481313075567 SELECT * FROM "tbl001EC6056FD2_68" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.652074 0.184286 0.46778800000000004 0.326037 0.14175100000000002 200 107 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6303559463402029922 SELECT slot_name, 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, active FROM pg_replication_slots 0 0 0 0 0 0 58670 1178.0501609999985 0.005562 26.057759 0.02007925960456809 0.1598769390816571 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4668455862633250356 LOCK TABLE public."tbl001EC605311A_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.267135 0.020811 0.038881 0.026713499999999994 0.005969059477840709 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8371519416562928713 SELECT * FROM "tbl001EC6056300_15" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.407035 0.407035 0.407035 0.407035 0 100 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4860106263684071920 LOCK TABLE public."tbl001EC60537AE_21" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.21766400000000002 0.016515 0.032715 0.0217664 0.004551082205366104 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6260995387881602129 SELECT cls.oid, cls.relname as name, indnkeyatts as col_count, amname, CASE WHEN length(spcname::text) > $1 THEN spcname ELSE (SELECT sp.spcname FROM pg_catalog.pg_database dtb JOIN pg_catalog.pg_tablespace sp ON dtb.dattablespace=sp.oid WHERE dtb.oid = $2::oid) END as spcname, CASE contype WHEN $3 THEN desp.description WHEN $4 THEN desp.description WHEN $5 THEN desp.description ELSE des.description END AS comment, condeferrable, condeferred, substring(pg_catalog.array_to_string(cls.reloptions, $6) from $7) AS fillfactor, pg_catalog.pg_get_expr(idx.indpred, idx.indrelid, $8) AS indconstraint FROM pg_catalog.pg_index idx JOIN pg_catalog.pg_class cls ON cls.oid=indexrelid LEFT OUTER JOIN pg_catalog.pg_tablespace ta on ta.oid=cls.reltablespace JOIN pg_catalog.pg_am am ON am.oid=cls.relam LEFT JOIN pg_catalog.pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid = cls.oid AND dep.refobjsubid = $9 AND dep.refclassid=(SELECT oid FROM pg_catalog.pg_class WHERE relname=$10) AND dep.deptype=$11) LEFT OUTER JOIN pg_catalog.pg_constraint con ON (con.tableoid = dep.refclassid AND con.oid = dep.refobjid) LEFT OUTER JOIN pg_catalog.pg_description des ON (des.objoid=cls.oid AND des.classoid=$12::regclass) LEFT OUTER JOIN pg_catalog.pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = $13 AND desp.classoid=$14::regclass) WHERE indrelid = $15::oid AND contype=$16 ORDER BY cls.relname 0 0 0 0 0 0 10 0.6706969999999999 0.053964 0.136637 0.0670697 0.02391930889490748 0 170 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5785768912503622355 LOCK TABLE public."tbl001EC6050D16_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.13881400000000002 0.016882 0.037507 0.023135666666666665 0.006721515049120662 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -709026648953116765 SELECT * FROM "tbl001EC605309C_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28088 1148.6844100000055 0.021986 2.596601 0.04089591320136674 0.04826540459926424 28088 84241 23 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4145166981101109747 COPY public."tbl001EC6053109_4" ("time", error, lowrange, highrange, "AC_Current_Amps_1", "Phase_A_Current_Amps_2", "Phase_B_Current_Amps_3", "Phase_C_Current_Amps_4", "Phase_Voltage_AB_Volts_5", "Phase_Voltage_BC_Volts_6", "Phase_Voltage_CA_Volts_7", "Phase_Voltage_AN_Volts_8", "Phase_Voltage_BN_Volts_9", "Phase_Voltage_CN_Volts_10", "AC_Power_W_11", "Line_Frequency_Hz_12", "AC_Apparent_Power_VA_13", "AC_Reactive_Power_VAR_14", "AC_Power_Factor_15", "AC_Energy_Wh_16", "DC_Amps_Amps_17", "DC_Voltage_Volts_18", "DC_Power_W_19", "Cabinet_Temperature_Degrees_20", "Heat_Sink_Temperature_Degrees_21", "Transformer_Temperature_Degrees_22", "Other_Temperature_Degrees_23", "Operating_State_24", "Vendor_Specific_Operating_State_25", "Event_Field_26", "Reserved_for_Future_27", "Vendor_Event_1_28", "Vendor_Event_2_29", "Vendor_Event_3_30", "Vendor_Event_4_31") TO stdout 0 0 0 0 0 0 3 20.306127 1.78728 12.096396 6.768708999999999 4.215794834293766 3169 93 42 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 518467819025958478 INSERT INTO "tbl001EC6050D16_5" 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 71409 1894.6937640000183 0.013732 11.392522 0.026532982733268883 0.08298144705098758 71409 432354 100 2860 1290 0 0 0 0 0 0 0 0 214424 1455 25472226
16385 16384 t -5366799117955129518 COPY public."tbl001EC6050B5D_5" ("time", error, lowrange, highrange, "Vln_a_Volts_1", "Vln_b_Volts_2", "Vln_c_Volts_3", "Vln_ave_Volts_4", "Vll_ab_Volts_5", "Vll_bc_Volts_6", "Vll_ca_Volts_7", "Vll_ave_Volts_8", "I_a_Amps_9", "I_b_Amps_10", "I_c_Amps_11", "I_ave_Amps_12", "V_unbal_13", "I_unbal_14", "Freq_Hz_15", "I4_Amps_16", "kW_a_kW_17", "kW_b_kW_18", "kW_c_kW_19", "kW_tot_kW_20", "kVAR_a_kVAR_21", "kVAR_b_kVAR_22", "kVAR_c_kVAR_23", "kVAR_tot_kVAR_24", "kVA_a_kVA_25", "kVA_b_kVA_26", "kVA_c_kVA_27", "kVA_tot_kVA_28", "PF_sign_a_29", "PF_sign_b_30", "PF_sign_c_31", "PF_sign_tot_32", "Vll_ave_mx_Volts_33", "I_ave_mx_Amps_34", "kW_tot_mx_kW_35", "kVAR_tot_mx_kVAR_36", "kVA_tot_mx_kVA_37", "Freq_mx_Hz_38", "Vll_ave_mn_Volts_39", "I_ave_mn_Amps_40", "Freq_mn_Hz_41", "kW_sd_del_rec_kW_42", "kVA_sd_del_rec_kVA_43", "kVAR_sd_del_rec_kVAR_44", "kW_sd_mx_d_r_kW_45", "kVA_sd_mx_d_r_kVA_46", "kVAR_sd_mx_d_r_kVAR_47", "Phase_Rev_48", "kWh_del_kWh_49", "kWh_rec_kWh_50", "kWh_del_rec_kWh_51", "kWh_del_rec_kWh_52", "kVARh_del_kVARh_53", "kVARh_rec_kVARh_54", "kVARh_del_rec_kVARh_55", "kVARh_del_rec_kVARh_56", "kVAh_del_rec_kVAh_57", "V1_THD_mx_58", "V2_THD_mx_59", "V3_THD_mx_60", "I1_THD_mx_61", "I2_THD_mx_62", "I3_THD_mx_63", unused_64) TO stdout 0 0 0 0 0 0 9 54.939364999999995 0.148694 12.742678 6.104373888888889 4.154062875786666 3554 143 137 8 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2066477262474563202 INSERT INTO "tbl001EC605311A_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 3022 172.33047800000034 0.016503 2.767369 0.057025307081403055 0.10379971300887902 3022 19056 40 5753 82 0 0 0 0 0 0 0 0 9075 5738 25400110
16385 16384 t 3060467959808578049 INSERT INTO "tbl001EC6053075_5" 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 810 41.33154600000008 0.024547 1.312558 0.05102660000000003 0.08388862365188676 810 4225 6 1295 13 0 0 0 0 0 0 0 0 2433 1568 6549038
16385 16384 t -1653242291051127918 COPY public."tbl001EC6050F3A_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 10 45.805935000000005 3.06892 5.754827 4.580593499999999 0.7502880664647749 11160 35 165 3 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4761008475407494000 INSERT INTO "tbl001EC6053CD9_4" VALUES ($1,$2,$3,$4,$5,$6) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 2883 147.8727189999998 0.016453 2.4808260000000004 0.05129126569545611 0.1023369533288206 2883 17397 34 3763 39 0 0 0 0 0 0 0 0 8657 3746 16142875
16385 16384 t -4064383362811605239 COPY public."tbl001EC6050BAC_10" ("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 83.629028 0.113992 22.613286 11.947004000000002 7.4118984625330055 30534 449 41 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -160013962385042061 SELECT * FROM tblacquisuite WHERE serialnumber = $1 AND Password = $2 0 0 0 0 0 0 3563925 83211.77303199985 0.005999 58.500865 0.023348351335114557 0.1183085701242553 3563908 7127826 19 11 0 0 0 0 0 0 0 0 0 13 1 4029
16385 16384 t -3837156726025410547 SELECT * FROM "tbl001EC6053075_7" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1620 31.891013999999984 0.005742000000000001 0.533126 0.01968581111111111 0.01736115527848958 1619 4048 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1988130024275577411 LOCK TABLE public.conditions IN ACCESS SHARE MODE 0 0 0 0 0 0 10 2.271323 0.049748 1.638926 0.2271323 0.47204495119597456 0 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8634705617215960004 SELECT * FROM "tbl001EC6050D30_80" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 144 836.0560450000006 0.456681 103.507633 5.8059447569444425 8.791332306006874 14400 27470 718 6 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7779448446499298098 INSERT INTO "tbl001EC605309C_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 15083 972.2266420000071 0.019319 6.342244 0.06445843943512554 0.1327019283579957 15083 94894 281 10477 1456 0 0 0 0 0 0 0 0 45290 7788 44489889
16385 16384 t 7956004609015546303 SELECT * FROM "tbl001EC6053CD9_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 8 1.104149 0.027262 0.253046 0.138018625 0.06206574321624107 710 496 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6588343311463669741 SELECT * FROM "tbl001EC6050C0B_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1116 55.612657999999925 0.008477 2.204005 0.04983213082437279 0.10537031380052045 1115 2530 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3774542133549584993 SELECT * FROM "tbl001EC6054E88_56" ORDER BY "Pulse_4_8" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 3.037612 1.384064 1.653548 1.518806 0.13474200000000008 200 221 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6124892563570560151 COPY public."tbl001EC6056300_10" ("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 45290.426666 4233.844528 5066.122472 4529.042666600001 254.7960532180512 2140600 1302 282000 59 4 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -182263461300699970 SELECT pg_database.datname as datname, tmp.mode as mode, COALESCE(count, $1) as count FROM ( VALUES ($2), ($3), ($4), ($5), ($6), ($7), ($8), ($9), ($10) ) AS tmp(mode) CROSS JOIN pg_database LEFT JOIN ( SELECT database, lower(mode) AS mode, count(*) AS count FROM pg_locks WHERE database IS NOT NULL GROUP BY database, lower(mode) ) AS tmp2 ON tmp.mode = tmp2.mode and pg_database.oid = tmp2.database ORDER BY 1 0 0 0 0 0 0 177729 50548.261289000024 0.168685 108.668694 0.284412005294578 0.7798048997484845 6398244 710916 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4433544611932410078 INSERT INTO "tbl001EC605311A_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 3022 180.89097699999994 0.017538 2.172747 0.059858033421575065 0.10861497661540674 3022 19063 43 5750 83 0 0 0 0 0 0 0 0 9074 5744 25241004
16385 16384 t -4017572826652974398 SELECT * FROM "tbl001EC6050F3C_12" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 8 0.6617079999999999 0.028605000000000002 0.147866 0.0827135 0.04842513599619519 235 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5526545556441069171 SELECT inhrelid, inhparent FROM pg_inherits 0 0 0 0 0 0 10 0.363256 0.004888 0.291373 0.0363256 0.085027731310673 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1652767987951234114 SET synchronize_seqscans TO off 0 0 0 0 0 0 10 0.06252100000000001 0.004683 0.008887 0.0062521 0.0013633218585499172 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3349344555040818057 COPY _timescaledb_catalog.compression_chunk_size (chunk_id, compressed_chunk_id, uncompressed_heap_size, uncompressed_toast_size, uncompressed_index_size, compressed_heap_size, compressed_toast_size, compressed_index_size, numrows_pre_compression, numrows_post_compression, numrows_frozen_immediately) TO stdout 0 0 0 0 0 0 10 0.2992189999999999 0.02623 0.042939 0.0299219 0.004611992984600042 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 6412983391656508173 DROP TABLE IF EXISTS _e270ae3bbdafb61f8f472aae1885e8d9 0 0 0 0 0 0 1 0.110717 0.110717 0.110717 0.110717 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -5661128274115771313 CREATE TABLE _b0c5ff84e749de726ebd5920410e1afd(cmd_output text) 0 0 0 0 0 0 1 32.572678 32.572678 32.572678 32.572678 0 0 502 5 27 1 0 0 0 0 0 0 0 0 94 27 139521
16385 16384 t -6933333677332515573 LOCK TABLE public."tbl001EC6056FD2_26" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.308557 0.018908 0.063955 0.030855699999999996 0.014557895947217098 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9190474291878820638 COPY public."tbl001EC6053093_9" ("time", error, lowrange, highrange, "Net_Energy_kWh_1", "Import_Energy_kWh_2", "Export_Energy_kWh_3", "Real_Power_kW_4", "Reactive_Power_kVAR_5", "Apparent_Power_kVA_6", "Voltage_Average_V_7", "Voltage_L_L_Average_V_8", "Current_Average_A_9", "Total_Power_Factor_10", "Frequency_Hz_11", "Voltage_A_V_12", "Voltage_B_V_13", "Voltage_C_V_14", "Voltage_AB_V_15", "Voltage_BC_V_16", "Votlage_AC_V_17", "Current_A_A_18", "Current_B_A_19", "Current_C_A_20", "Power_Factor_A_21", "Power_Factor_B_22", "Power_Factor_C_23", "Import_Energy_Phase_A_kWh_24", "Import_Energy_Phase_B_kWh_25", "Import_Energy_Phase_C_kWh_26", "Export_Energy_Phase_A_kWh_27", "Export_Energy_Phase_B_kWh_28", "Export_Energy_Phase_C_kWh_29") TO stdout 0 0 0 0 0 0 10 38743.77894799999 3579.456045 4011.298825 3874.3778948000004 119.18182213572253 2124170 6779 85428 25 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8217025160266486754 SELECT tableoid, oid, opcmethod, opcname, opcnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = opcowner) AS rolname FROM pg_opclass 0 0 0 0 0 0 10 29.427687999999996 1.6258139999999999 7.360035 2.9427688 1.787846204521284 1780 1800 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7403519572711828047 LOCK TABLE public."tbl001EC6050E4D_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.32776500000000003 0.021225 0.051422 0.03277650000000001 0.008749298706182114 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2537953920329668429 SELECT nsp.oid, nsp.nspname as name, pg_catalog.has_schema_privilege(nsp.oid, $1) as can_create, pg_catalog.has_schema_privilege(nsp.oid, $2) as has_usage, des.description FROM pg_catalog.pg_namespace nsp LEFT OUTER JOIN pg_catalog.pg_description des ON (des.objoid=nsp.oid AND des.classoid=$3::regclass) WHERE nspname NOT LIKE $4 AND NOT ( (nsp.nspname = $5 AND EXISTS (SELECT $6 FROM pg_catalog.pg_class WHERE relname = $7 AND relnamespace = nsp.oid LIMIT $8)) OR (nsp.nspname = $9 AND EXISTS (SELECT $10 FROM pg_catalog.pg_class WHERE relname = $11 AND relnamespace = nsp.oid LIMIT $12)) OR (nsp.nspname = $13 AND EXISTS (SELECT $14 FROM pg_catalog.pg_class WHERE relname = $15 AND relnamespace = nsp.oid LIMIT $16)) ) ORDER BY nspname 0 0 0 0 0 0 1 1.203609 1.203609 1.203609 1.203609 0 9 30 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1290077886823766924 LOCK TABLE public."tbl001EC6056D48_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.28287900000000005 0.018986 0.05575 0.0282879 0.013555362484640536 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 979215152147254000 INSERT INTO "tbl001EC6050F3C_10" 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 73 3.385814 0.027356000000000002 0.17694100000000001 0.04638101369863013 0.020396475940907818 73 293 0 145 2 0 0 0 0 0 0 0 0 220 142 231869
16385 16384 t 2257192383175481432 LOCK TABLE public."tbl001EC6050E0D_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.36644000000000004 0.017527 0.157777 0.036643999999999996 0.040652737292831836 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7185917458071959000 CREATE TABLE IF NOT EXISTS "tbl001EC6050B42_51" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 4.877258 4.877258 4.877258 4.877258 0 0 577 1 2 0 0 0 0 0 0 0 0 0 145 3 23591
16385 16384 t -6752161727331344387 COPY public."tbl001EC6050BAC_7" ("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 93.03673900000001 0.134457 25.864844 13.290962714285715 9.302478221054027 30534 311 140 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4454314814758429192 COPY public."tbl001EC6056D41_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 553.052085 37.474862 74.923401 55.305208500000006 11.973968413519655 44930 73 5069 11 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 226385941167442099 LOCK TABLE public."tbl001EC6050D30_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.44068100000000004 0.027018 0.133638 0.0440681 0.03104153596215883 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2333662266000063973 SELECT * FROM "tbl001EC6050D21_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 1.699741 0.457482 0.776785 0.5665803333333334 0.1486729507618054 300 63 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6615331585687900915 CREATE TABLE IF NOT EXISTS "tbl001EC6050D16_52" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 7.260324 7.260324 7.260324 7.260324 0 0 581 3 17 2 0 0 0 0 0 0 0 0 145 12 60021
16385 16384 t -4027249931579960338 LOCK TABLE public."tbl001EC6056FD2_68" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.256821 0.017301 0.039402 0.025682099999999996 0.0075201108296354255 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4319710115541509070 COPY public."tbl001EC6050F3C_14" ("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.109342 0.109342 0.109342 0.109342 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1791524771958433889 CREATE TABLE IF NOT EXISTS "tbl001EC6050D16_6" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "DC_Voltage_V_1" DOUBLE PRECISION DEFAULT NULL, "Apparent_AC_Power_VA_2" DOUBLE PRECISION DEFAULT NULL, "AC_Grid_Frequency_Hz_3" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Stage_Current_A_4" DOUBLE PRECISION DEFAULT NULL, "L1_to_L2_AC_Voltage_V_5" DOUBLE PRECISION DEFAULT NULL, "L2_to_L3_AC_Voltage_V_6" DOUBLE PRECISION DEFAULT NULL, "L1_to_L3_AC_Voltage_V_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Sequence_8" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_kWh_9" DOUBLE PRECISION DEFAULT NULL, "On_Grid_Hours_Hrs_10" DOUBLE PRECISION DEFAULT NULL, "Fan_On_Time_Hours_Hrs_11" DOUBLE PRECISION DEFAULT NULL, "AC_Contactors_Cycles_12" DOUBLE PRECISION DEFAULT NULL, "Network_ID_13" DOUBLE PRECISION DEFAULT NULL, "Informative_Alarms_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 8.379172 8.379172 8.379172 8.379172 0 0 669 5 40 1 0 0 0 0 0 0 0 0 135 38 211863
16385 16384 t 9113311543522970634 LOCK TABLE public."tbl001EC6053CD9_5" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.244863 0.017264 0.089763 0.0408105 0.027804159483489754 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5909904965072267000 WITH RECURSIVE w AS ( SELECT d1.objid, d2.refobjid, c2.relkind AS refrelkind FROM pg_depend d1 JOIN pg_class c1 ON c1.oid = d1.objid AND c1.relkind = $1 JOIN pg_rewrite r1 ON r1.ev_class = d1.objid JOIN pg_depend d2 ON d2.classid = $2::regclass AND d2.objid = r1.oid AND d2.refobjid <> d1.objid JOIN pg_class c2 ON c2.oid = d2.refobjid AND c2.relkind IN ($3,$4) WHERE d1.classid = $5::regclass UNION SELECT w.objid, d3.refobjid, c3.relkind FROM w JOIN pg_rewrite r3 ON r3.ev_class = w.refobjid JOIN pg_depend d3 ON d3.classid = $6::regclass AND d3.objid = r3.oid AND d3.refobjid <> w.refobjid JOIN pg_class c3 ON c3.oid = d3.refobjid AND c3.relkind IN ($7,$8) ) SELECT $9::regclass::oid AS classid, objid, refobjid FROM w WHERE refrelkind = $10 0 0 0 0 0 0 10 2.5969 0.23064900000000002 0.286811 0.25969000000000003 0.01846175742988733 0 241 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -1674588913841666144 CREATE TABLE _2833a1fbef1702151a78b81d05b1c987(cmd_output text) 0 0 0 0 0 0 1 6.358849 6.358849 6.358849 6.358849 0 0 503 3 24 0 0 0 0 0 0 0 0 0 92 25 119885
16385 16384 t -4533514347593319712 INSERT INTO "tbl001EC6050D16_6" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 72271 1792.1560710000065 0.008757 5.922879 0.02479772067634338 0.051125354953594625 71334 434827 105 2889 1297 0 0 0 0 0 0 0 0 214200 1455 25557765
16385 16384 t 2004631496756232998 SELECT * FROM "tbl001EC6053CD9_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 5758 156.1289559999999 0.0059039999999999995 2.722201 0.027115136505731198 0.08090397394966643 5757 16455 15 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3265058187973757034 INSERT INTO "tbl001EC6050BAC_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 9672 565.5084750000013 0.016826 44.793474 0.05846861817617861 0.6415023370768458 9672 58866 111 5412 187 0 0 0 0 0 0 0 0 29043 5128 23970112
16385 16384 t -2138758533937127431 SELECT * FROM "tbl001EC6050D05_80" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 1.5001890000000002 0.5016470000000001 0.998542 0.7500945000000001 0.24844750000000002 200 28 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8026971392048526631 INSERT INTO "tbl001EC6050D30_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 8965 341.579487000001 0.016402 3.466386 0.038101448633574876 0.08066906039009938 8965 54371 23 2265 408 0 0 0 0 0 0 0 0 26920 1861 12238022
16385 16384 t -3302164663578792206 INSERT INTO "tbl001EC6050F3C_19" 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 73 3.5155709999999996 0.028181 0.155983 0.04815850684931506 0.019031517045991653 73 293 0 145 2 0 0 0 0 0 0 0 0 220 142 231869