Tables

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

pg_stat_statements

userid
oid 		dbid
oid 		toplevel
boolean 		queryid
bigint 		query
text 		plans
bigint 		total_plan_time
double precision 		min_plan_time
double precision 		max_plan_time
double precision 		mean_plan_time
double precision 		stddev_plan_time
double precision 		calls
bigint 		total_exec_time
double precision 		min_exec_time
double precision 		max_exec_time
double precision 		mean_exec_time
double precision 		stddev_exec_time
double precision 		rows
bigint 		shared_blks_hit
bigint 		shared_blks_read
bigint 		shared_blks_dirtied
bigint 		shared_blks_written
bigint 		local_blks_hit
bigint 		local_blks_read
bigint 		local_blks_dirtied
bigint 		local_blks_written
bigint 		temp_blks_read
bigint 		temp_blks_written
bigint 		blk_read_time
double precision 		blk_write_time
double precision 		wal_records
bigint 		wal_fpi
bigint 		wal_bytes
numeric
16385 16384 t 3251763472184851507 SELECT * FROM "tbl001EC6050B5D_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 24 5.880107 0.031323 1.066603 0.24500445833333334 0.25802874418689276 1637 318 2 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5762485275245656394 SELECT * FROM "tbl001EC6056FD2_64" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.9068399999999999 0.16911199999999998 0.36960699999999996 0.30228 0.09416595002795154 300 146 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 377152378701384568 UPDATE tbldevicelist SET configchangetime = $1, configchecksum = $2, config = $3 WHERE serialnumber = $4 AND deviceid = $5 0 0 0 0 0 0 158 31.471202999999996 0.028366 3.995381 0.19918482911392402 0.46182655077611323 158 1218 17 138 28 0 0 0 0 0 0 0 0 607 85 764833
16385 16384 t 127771053645167154 SELECT * FROM "tbl001EC6056FD2_59" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30110 739.0848609999987 0.012082 2.698524 0.024546159448688203 0.028460906221636748 30110 90322 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1002005743986426214 LOCK TABLE public."tbl001EC6056D41_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.36484199999999994 0.018709 0.057554 0.0364842 0.011616266575797923 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3633819561585653136 SELECT slot_name, database, active, (case pg_is_in_recovery() when $1 then pg_wal_lsn_diff(pg_last_wal_receive_lsn(), restart_lsn) else pg_wal_lsn_diff(pg_current_wal_lsn(), restart_lsn) end) as pg_wal_lsn_diff FROM pg_replication_slots 0 0 0 0 0 0 122087 1628.6918510000123 0.006055 3.687521 0.013340419954622507 0.04641506915177144 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 2384501510384612348 DROP TABLE IF EXISTS _11e6e96750bfb9cb49d2edf774588815 0 0 0 0 0 0 1 2.596679 2.596679 2.596679 2.596679 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4969550170037042661 CREATE TABLE IF NOT EXISTS "tbl001EC6050D16_7" ( 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.254328 6.254328 6.254328 6.254328 0 0 536 2 41 0 0 0 0 0 0 0 0 0 135 38 207246
16385 16384 t -1076471019963796374 INSERT INTO "tbl001EC6053113_53" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15460 1119.9094949999987 0.018995 3.374468 0.07243916526520036 0.1439427274555613 15460 97315 453 11080 1448 0 0 0 0 0 0 0 0 46423 8252 46475602
16385 16384 t -4587284099348694427 INSERT INTO "tbl001EC6056FD2_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 15484 831.0891270000036 0.015376999999999998 31.836926000000002 0.0536740588349263 0.41134473794473486 15484 95566 29 9008 423 0 0 0 0 0 0 0 0 46494 8211 38660545
16385 16384 t -8775159593110733118 INSERT INTO "tbl001EC6050D05_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 15487 789.1711239999996 0.018127 3.9699389999999997 0.050957004197068535 0.07738211905835758 15487 98217 33 10033 1351 0 0 0 0 0 0 0 0 46504 7904 43113767
16385 16384 t 7502720484087326570 SELECT nsp.nspname FROM pg_catalog.pg_namespace nsp WHERE nsp.oid = $1 0 0 0 0 0 0 4 0.051800000000000006 0.011781 0.015477000000000001 0.012950000000000001 0.001504540129075992 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3807250979960819961 LOCK TABLE public."tbl001EC605309C_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.9042359999999999 0.018298 0.70688 0.09042359999999999 0.20550260879278393 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8451831356331237564 SELECT * FROM "tbl001EC6053109_7" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 4824 139.63867299999959 0.00728 2.947849 0.02894665692371475 0.05455216830169918 4823 13659 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2908943687785258651 UPDATE tblacquisuite SET configchangetime = $1, configchecksum = $2, config = $3 WHERE serialnumber = $4 0 0 0 0 0 0 34 6.222609 0.023382 1.360705 0.18301791176470586 0.3490981384936441 34 163 4 24 6 0 0 0 0 0 0 0 0 48 16 114516
16385 16384 t -4201829695170716864 SELECT * FROM "tbl001EC60537E0_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 4044 95.91444599999991 0.006328 1.475776 0.02371771661721071 0.03424427894854192 4043 11317 3 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4278736626889165579 COPY _timescaledb_catalog.chunk (id, hypertable_id, schema_name, table_name, compressed_chunk_id, dropped, status, osm_chunk, creation_time) TO stdout 0 0 0 0 0 0 10 0.38171 0.029367 0.07133 0.038171 0.011542832719917587 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1804099654858078362 LOCK TABLE public."tbl001EC60537AE_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.35667 0.021105 0.069852 0.035667 0.014116296242286783 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7168559237883323863 SELECT * FROM "tbl001EC6053109_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 14 14.176053 0.43583 3.0350490000000003 1.012575214285714 0.6458864805802266 1400 3325 6 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -2562793433988086781 CREATE TABLE _64327a0ce5c07d4b1863d72f942a7e5b(cmd_output text) 0 0 0 0 0 0 1 9.522833 9.522833 9.522833 9.522833 0 0 509 6 28 0 0 0 0 0 0 0 0 0 95 28 148110
16385 16384 t -6630379783387233214 COPY public."tbl001EC6056FD2_54" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 10 872.8181799999999 61.351593 126.004332 87.281818 20.18927143694752 226930 11 4704 19 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5126968810722186872 INSERT INTO "tbl001EC6050B08_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 15492 609.4636519999999 0.016693 27.400979999999997 0.03934054040795233 0.2381460876991623 15492 95130 67 2842 699 0 0 0 0 0 0 0 0 46518 2049 16130093
16385 16384 t 9091148640636446203 LOCK TABLE public."tbl001EC6056D41_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.26316 0.017145 0.050229 0.026316 0.010985216101652257 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4054279006767522152 SELECT * FROM "tbl001EC6053075_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1770 59.811650000000036 0.009693 1.268565 0.033791892655367195 0.03664710666640663 1769 4498 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2751250318811745715 SELECT * FROM "tbl001EC6050D16_6" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 3.496325 0.080983 0.49490500000000004 0.2185203125 0.10894167370416541 1600 243 0 57 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7279218708806465987 LOCK TABLE public."tbl001EC6056FD2_66" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.209945 0.018151 0.027326 0.0209945 0.003109893671815807 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5867758102522040338 SELECT * FROM "tbl001EC6050D15_8" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.36806700000000003 0.045930000000000006 0.322137 0.1840335 0.13810350000000002 91 21 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8564652527410405213 SELECT * FROM "tbl001EC6050189_32" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 27 102.67809500000001 0.067398 18.99271 3.802892407407407 4.622488415337968 1886 1382 92 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6009283814060212689 SELECT * FROM "tbl001EC6050D16_8" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 16 3.6551840000000007 0.094943 0.5401600000000001 0.22844899999999999 0.12129429355239679 1600 277 0 53 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1936851086463775907 CREATE TABLE IF NOT EXISTS "tbl001EC6050D15_10" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "DC_Voltage_V_1" DOUBLE PRECISION DEFAULT NULL, "Apparent_AC_Power_VA_2" DOUBLE PRECISION DEFAULT NULL, "AC_Grid_Frequency_Hz_3" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Stage_Current_A_4" DOUBLE PRECISION DEFAULT NULL, "L1_to_L2_AC_Voltage_V_5" DOUBLE PRECISION DEFAULT NULL, "L2_to_L3_AC_Voltage_V_6" DOUBLE PRECISION DEFAULT NULL, "L1_to_L3_AC_Voltage_V_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Sequence_8" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_kWh_9" DOUBLE PRECISION DEFAULT NULL, "On_Grid_Hours_Hrs_10" DOUBLE PRECISION DEFAULT NULL, "Fan_On_Time_Hours_Hrs_11" DOUBLE PRECISION DEFAULT NULL, "AC_Contactors_Cycles_12" DOUBLE PRECISION DEFAULT NULL, "Network_ID_13" DOUBLE PRECISION DEFAULT NULL, "Informative_Alarms_14" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_1_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_2_A_17" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_3_A_18" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_4_A_19" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_5_A_20" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_6_A_21" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_7_A_22" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_8_A_23" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_Total_A_24" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_25" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 11.745975 11.745975 11.745975 11.745975 0 0 661 3 4 1 0 0 0 0 0 0 0 0 165 4 26179
16385 16384 t 3353498103394291942 COPY public."tbl001EC6053075_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 3 2.62136 0.061175 2.126189 0.8737866666666667 0.8985664797940971 972 11 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4748443054094960867 LOCK TABLE public."tbl001EC6053093_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.255169 0.019956 0.035334 0.0255169 0.004510529491090818 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3553950322650564165 SELECT * FROM "tbl001EC6050B5D_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 27 6.433646 0.028062999999999998 1.442697 0.23828318518518524 0.3090503307922798 1920 234 4 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6734035918624043055 INSERT INTO "tbl001EC6056300_53" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15486 668.6643280000004 0.015219 3.634484 0.04317863412114178 0.0721251434533052 15486 96801 24 8017 654 0 0 0 0 0 0 0 0 46501 7371 32290549
16385 16384 t -1813716429182012109 SELECT * FROM "tbl001EC6050D15_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.08566700000000001 0.08566700000000001 0.08566700000000001 0.08566700000000001 0 83 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8818538883685569452 CREATE TABLE IF NOT EXISTS "tbl001EC6050D15_8" ( 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, "SolZone_DC_Current_1_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_2_A_17" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_3_A_18" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_4_A_19" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_5_A_20" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_6_A_21" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_7_A_22" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_8_A_23" DOUBLE PRECISION DEFAULT NULL, "SolZone_DC_Current_Total_A_24" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_25" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 8.055385 8.055385 8.055385 8.055385 0 0 747 3 8 0 0 0 0 0 0 0 0 0 153 7 39586
16385 16384 t 1982818800893344996 LOCK TABLE public."tbl001EC6050B5D_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.352993 0.019722 0.143881 0.03922144444444445 0.03745675816224212 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7488622909531236882 SELECT * FROM "tbl001EC6053075_5" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1770 36.39398499999999 0.007243 0.429743 0.020561573446327648 0.016863572456478154 1769 4498 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5137721114216529213 CREATE TABLE IF NOT EXISTS "tbl001EC6050B87_2" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 9.524635 9.524635 9.524635 9.524635 0 0 1322 6 11 0 0 0 0 0 0 0 0 0 279 10 65702
16385 16384 t 3223310289222550840 SELECT * FROM "tbl001EC605309C_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28830 1157.408573000002 0.02105 2.354406 0.040145978945542705 0.035402307258245544 28830 86468 22 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6211817782602523787 LOCK TABLE public."tbl001EC6053CD9_4" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.194669 0.019448 0.0914 0.03244483333333333 0.026406803033919537 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5916739363547283910 SELECT * FROM "tbl001EC6050F3C_6" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 196 6.974335999999999 0.010329999999999999 1.418109 0.03558334693877549 0.10000538692154844 195 389 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -6168334739621871521 CREATE TABLE _de27fadfbf2fd0a1680b9a5f0e1ef373(cmd_output text) 0 0 0 0 0 0 1 6.481532 6.481532 6.481532 6.481532 0 0 502 4 6 0 0 0 0 0 0 0 0 0 92 7 42340
16385 16384 t -3709344166487511134 SELECT * FROM "tbl001EC6056FD2_67" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 4 1.7045240000000002 0.22172 0.653661 0.42613100000000004 0.15944826546720414 400 195 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1419363185291400705 COPY public."tbl001EC6056FD2_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 6318.774179999999 341.223783 851.144576 631.877418 151.08495132855109 226930 8 17087 36 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6769713471608700992 INSERT INTO "tbl001EC6050F3C_2" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$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 98 4.736246 0.029394999999999998 0.168278 0.04832904081632653 0.019925057663050437 98 393 0 195 2 0 0 0 0 0 0 0 0 295 192 409344
16385 16384 t 7363185694377951237 COPY public."tbl001EC6053075_5" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 3 1.437112 0.059929 0.929155 0.4790373333333333 0.3555368183787565 972 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3178853012189922903 UPDATE tblacquisuite SET name = $1, firmwareversion = $2 WHERE serialnumber = $3 0 0 0 0 0 0 19 0.7088209999999999 0.022520000000000002 0.100418 0.03730636842105262 0.018190305021054558 19 76 0 0 0 0 0 0 0 0 0 0 0 19 3 16991
16385 16384 t -940542569452767473 COPY public."tbl001EC6050F3C_5" ("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.108151 0.108151 0.108151 0.108151 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4627390238678665881 SELECT * FROM "tbl001EC6054E7A_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 24 158.81862000000004 0.034859 92.505448 6.617442500000001 18.212792942946365 1359 833 73 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3549853812237591639 SELECT * FROM "tbl001EC6056D47_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29896 1199.315417999991 0.02033 5.530913999999999 0.0401162502675945 0.050855781892153354 29896 89684 4 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4827636164123594283 CREATE TABLE IF NOT EXISTS "tbl001EC6050D06_3" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "DC_Voltage_V_1" DOUBLE PRECISION DEFAULT NULL, "Apparent_AC_Power_VA_2" DOUBLE PRECISION DEFAULT NULL, "AC_Grid_Frequency_Hz_3" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Stage_Current_A_4" DOUBLE PRECISION DEFAULT NULL, "L1_to_L2_AC_Voltage_V_5" DOUBLE PRECISION DEFAULT NULL, "L2_to_L3_AC_Voltage_V_6" DOUBLE PRECISION DEFAULT NULL, "L1_to_L3_AC_Voltage_V_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Sequence_8" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_kWh_9" DOUBLE PRECISION DEFAULT NULL, "On_Grid_Hours_Hrs_10" DOUBLE PRECISION DEFAULT NULL, "Fan_On_Time_Hours_Hrs_11" DOUBLE PRECISION DEFAULT NULL, "AC_Contactors_Cycles_12" DOUBLE PRECISION DEFAULT NULL, "Network_ID_13" DOUBLE PRECISION DEFAULT NULL, "Informative_Alarms_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.049204 5.049204 5.049204 5.049204 0 0 527 0 0 0 0 0 0 0 0 0 0 0 133 1 14988
16385 16384 t 6981249670125571183 INSERT INTO "tbl001EC6056FD2_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15484 648.3033159999994 0.015593000000000001 4.691728 0.04186924024799773 0.07074075858065791 15484 95754 46 8819 315 0 0 0 0 0 0 0 0 46494 8139 39517657
16385 16384 t 3527135381030210082 SELECT tableoid, oid, prpubid, prrelid FROM pg_catalog.pg_publication_rel 0 0 0 0 0 0 10 0.080008 0.007421 0.009832 0.0080008 0.0006424519904241875 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5263395866182223449 INSERT INTO "tbl001EC6056D49_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 15487 845.6105400000013 0.018821 2.6850910000000003 0.054601313359591806 0.06785009794562079 15487 97732 29 10727 1486 0 0 0 0 0 0 0 0 46504 8153 45898682
16385 16384 t 1195254276759555828 SELECT * FROM "tbl001EC6053113_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.536175 1.105408 1.4307670000000001 1.2680875 0.1626795000000001 200 101 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4863435045600415456 INSERT INTO "tbl001EC6050F3A_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 1033 86.753878 0.021047 6.695952 0.08398245692158769 0.2557769981379088 1033 6812 31 2004 22 0 0 0 0 0 0 0 0 3102 1968 8805981
16385 16384 t 3241862310340197696 SELECT * FROM "tblacquisuite" ORDER BY "configchangetime" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.184952 0.184952 0.184952 0.184952 0 24 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -196987854107340803 SELECT * FROM "tbl001EC6056D41_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 1.938711 0.961068 0.977643 0.9693555 0.008287500000000003 200 47 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7013903244052396588 INSERT INTO "tbl001EC6050B42_52" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 581 41.97744599999997 0.02149 1.415758 0.07225033734939763 0.11421748525221016 581 3032 12 1143 30 0 0 0 0 0 0 0 0 1745 1122 4654053
16385 16384 t 3075973748544849661 CREATE TABLE IF NOT EXISTS "tbl001EC6050BAC_2" ( 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 5.44614 5.44614 5.44614 5.44614 0 0 556 2 11 1 0 0 0 0 0 0 0 0 137 4 26691
16385 16384 t 7129603072722540188 SELECT * FROM "tbl001EC6053109_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 14 3.2128900000000002 0.090956 0.5645560000000001 0.22949214285714287 0.12723767777490685 1400 1030 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6652742425814594217 COPY public."tbl001EC6050D21_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 660.4087229999999 39.972595 92.000389 66.04087229999999 17.676107721308828 74820 569 3861 11 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6988353513519515456 SELECT * FROM "tbl001EC6056300_55" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.8074749999999999 0.8074749999999999 0.8074749999999999 0.8074749999999999 0 100 52 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5620330883940332944 SELECT * FROM "tbl001EC6056D49_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30032 1358.5908439999864 0.020425 5.479581 0.04523810748534872 0.050685947857761635 30032 90092 4 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5473020022787340024 INSERT INTO "tbl001EC6050C0B_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,$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 587 48.88674799999997 0.022297 3.6712279999999997 0.0832823645655879 0.19692962126105812 587 3113 12 1208 50 0 0 0 0 0 0 0 0 1763 1116 4731467
16385 16384 t -7810436645153025161 COPY public."tbl001EC6056FD2_27" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 10 858.872085 59.726488 114.467364 85.8872085 16.03792022775156 226930 10 4641 18 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8208547112757203688 COPY public."tbl001EC6056FD2_26" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 10 549.125908 28.890007 114.762129 54.912590800000004 23.069289566676694 226890 8 2212 12 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2046205878523927865 CREATE TABLE IF NOT EXISTS "tbl001EC6050189_33" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Volts_A_N_Volts_1" DOUBLE PRECISION DEFAULT NULL, "Volts_B_N_Volts_2" DOUBLE PRECISION DEFAULT NULL, "Volts_C_N_Volts_3" DOUBLE PRECISION DEFAULT NULL, "Volts_A_B_Volts_4" DOUBLE PRECISION DEFAULT NULL, "Volts_B_C_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Volts_C_A_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Amps_7" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Amps_8" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Amps_9" DOUBLE PRECISION DEFAULT NULL, "Watts_3_Ph_total_kW_10" DOUBLE PRECISION DEFAULT NULL, "VARs_3_Ph_total_kVAR_11" DOUBLE PRECISION DEFAULT NULL, "VAs_3_Ph_total_kVA_12" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_3_Ph_total_13" DOUBLE PRECISION DEFAULT NULL, "Frequency_Hz_14" DOUBLE PRECISION DEFAULT NULL, "Neutral_Current_Amps_15" DOUBLE PRECISION DEFAULT NULL, "W_hours_Received_kWh_16" DOUBLE PRECISION DEFAULT NULL, "W_hours_Delivered_kWh_17" DOUBLE PRECISION DEFAULT NULL, "W_hours_Net_kWh_18" DOUBLE PRECISION DEFAULT NULL, "W_hours_Total_kWh_19" DOUBLE PRECISION DEFAULT NULL, "VAR_hours_Positive_kVARh_20" DOUBLE PRECISION DEFAULT NULL, "VAR_hours_Negative_kVARh_21" DOUBLE PRECISION DEFAULT NULL, "VAR_hours_Net_kVARh_22" DOUBLE PRECISION DEFAULT NULL, "VAR_hours_Total_kVARh_23" DOUBLE PRECISION DEFAULT NULL, "VA_hours_Total_kVAh_24" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Average_Amps_25" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Average_Amps_26" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Average_Amps_27" DOUBLE PRECISION DEFAULT NULL, "Positive_Watts_3_Ph_Average_kW_28" DOUBLE PRECISION DEFAULT NULL, "Positive_VARs_3_Ph_Average_kVAR_29" DOUBLE PRECISION DEFAULT NULL, "Negative_Watts_3_Ph_Average_kW_30" DOUBLE PRECISION DEFAULT NULL, "Negative_VARs_3_Ph_Average_kVAR_31" DOUBLE PRECISION DEFAULT NULL, "VAs_3_Ph_Average_kVA_32" DOUBLE PRECISION DEFAULT NULL, "Positive_PF_3_Ph_Average_33" DOUBLE PRECISION DEFAULT NULL, "Negative_PF_3_Ph_Average_34" DOUBLE PRECISION DEFAULT NULL, "Volts_A_N_Min_Volts_35" DOUBLE PRECISION DEFAULT NULL, "Volts_B_N_Min_Volts_36" DOUBLE PRECISION DEFAULT NULL, "Volts_C_N_Min_Volts_37" DOUBLE PRECISION DEFAULT NULL, "Volts_A_B_Min_Volts_38" DOUBLE PRECISION DEFAULT NULL, "Volts_B_C_Min_Volts_39" DOUBLE PRECISION DEFAULT NULL, "Volts_C_A_Min_Volts_40" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Min_Avg_Demand_Amps_41" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Min_Avg_Demand_Amps_42" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Min_Avg_Demand_Amps_43" DOUBLE PRECISION DEFAULT NULL, "Positive_Watts_3_Ph_Min_Avg_Demand_kW_44" DOUBLE PRECISION DEFAULT NULL, "Positive_VARs_3_Ph_Min_Avg_Demand_kVAR_45" DOUBLE PRECISION DEFAULT NULL, "Negative_Watts_3_Ph_Min_Avg_Demand_kW_46" DOUBLE PRECISION DEFAULT NULL, "Negative_VARs_3_Ph_Min_Avg_Demand_kVAR_47" DOUBLE PRECISION DEFAULT NULL, "VAs_3_Ph_Min_Avg_Demand_kVA_48" DOUBLE PRECISION DEFAULT NULL, "Positive_PF_3_Ph_Min_Avg_Demand_49" DOUBLE PRECISION DEFAULT NULL, "Negative_PF_3_Ph_Min_Avg_Demand_50" DOUBLE PRECISION DEFAULT NULL, "Frequency_Min_Hz_51" DOUBLE PRECISION DEFAULT NULL, "Volts_A_N_Max_Volts_52" DOUBLE PRECISION DEFAULT NULL, "Volts_B_N_Max_Volts_53" DOUBLE PRECISION DEFAULT NULL, "Volts_C_N_Max_Volts_54" DOUBLE PRECISION DEFAULT NULL, "Volts_A_B_Max_Volts_55" DOUBLE PRECISION DEFAULT NULL, "Volts_B_C_Max_Volts_56" DOUBLE PRECISION DEFAULT NULL, "Volts_C_A_Max_Volts_57" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Max_Avg_Demand_Amps_58" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Max_Avg_Demand_Amps_59" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Max_Avg_Demand_Amps_60" DOUBLE PRECISION DEFAULT NULL, "Positive_Watts_3_Ph_Max_Avg_Demand_kW_61" DOUBLE PRECISION DEFAULT NULL, "Positive_VARs_3_Ph_Max_Avg_Demand_kVAR_62" DOUBLE PRECISION DEFAULT NULL, "Negative_Watts_3_Ph_Max_Avg_Demand_kW_63" DOUBLE PRECISION DEFAULT NULL, "Negative_VARs_3_Ph_Max_Avg_Demand_kVAR_64" DOUBLE PRECISION DEFAULT NULL, "VAs_3_Ph_Max_Avg_Demand_kVA_65" DOUBLE PRECISION DEFAULT NULL, "Positive_PF_3_Ph_Max_Avg_Demand_66" DOUBLE PRECISION DEFAULT NULL, "Negative_PF_3_Ph_Max_Avg_Demand_67" DOUBLE PRECISION DEFAULT NULL, "Frequency_Max_Hz_68" DOUBLE PRECISION DEFAULT NULL, "Volts_A_N_THD_69" DOUBLE PRECISION DEFAULT NULL, "Volts_B_N_THD_70" DOUBLE PRECISION DEFAULT NULL, "Volts_C_N_THD_71" DOUBLE PRECISION DEFAULT NULL, "Amps_A_THD_72" DOUBLE PRECISION DEFAULT NULL, "Amps_B_THD_73" DOUBLE PRECISION DEFAULT NULL, "Amps_C_THD_74" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_0th_harmonic_magnitude_75" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_1st_harmonic_magnitude_76" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_2nd_harmonic_magnitude_77" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_3rd_harmonic_magnitude_78" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_4th_harmonic_magnitude_79" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_5th_harmonic_magnitude_80" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_6th_harmonic_magnitude_81" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_7th_harmonic_magnitude_82" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Voltage_0th_harmonic_magnitude_83" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Voltage_1st_harmonic_magnitude_84" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Voltage_2nd_harmonic_magnitude_85" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Voltage_3rd_harmonic_magnitude_86" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_0th_harmonic_magnitude_87" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_1st_harmonic_magnitude_88" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_2nd_harmonic_magnitude_89" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_3rd_harmonic_magnitude_90" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_4th_harmonic_magnitude_91" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_5th_harmonic_magnitude_92" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_6th_harmonic_magnitude_93" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_7th_harmonic_magnitude_94" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Voltage_0th_harmonic_magnitude_95" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Voltage_1st_harmonic_magnitude_96" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Voltage_2nd_harmonic_magnitude_97" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Voltage_3rd_harmonic_magnitude_98" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_0th_harmonic_magnitude_99" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_1st_harmonic_magnitude_100" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_2nd_harmonic_magnitude_101" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_3rd_harmonic_magnitude_102" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_4th_harmonic_magnitude_103" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_5th_harmonic_magnitude_104" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_6th_harmonic_magnitude_105" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_7th_harmonic_magnitude_106" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Voltage_0th_harmonic_magnitude_107" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Voltage_1st_harmonic_magnitude_108" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Voltage_2nd_harmonic_magnitude_109" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Voltage_3rd_harmonic_magnitude_110" DOUBLE PRECISION DEFAULT NULL, "Angle_Phase_A_Current_Degrees_111" DOUBLE PRECISION DEFAULT NULL, "Angle_Phase_B_Current_Degrees_112" DOUBLE PRECISION DEFAULT NULL, "Angle_Phase_C_Current_Degrees_113" DOUBLE PRECISION DEFAULT NULL, "Angle_Volts_A_B_Degrees_114" DOUBLE PRECISION DEFAULT NULL, "Angle_Volts_B_C_Degrees_115" DOUBLE PRECISION DEFAULT NULL, "Angle_Volts_C_A_Degrees_116" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 10.026548 10.026548 10.026548 10.026548 0 0 1405 3 5 0 0 0 0 0 0 0 0 0 348 5 55316
16385 16384 t -5015682875737065382 SELECT * FROM "tbl001EC6050D17_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 7 1.491106 0.043052 0.549915 0.21301514285714285 0.188481740801466 251 160 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6364624556512176188 INSERT INTO "tbl001EC6050D15_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 113 4.221190000000001 0.018511 0.1873 0.03735566371681417 0.023957305262210453 113 466 2 58 6 0 0 0 0 0 0 0 0 340 50 166627
16385 16384 t -5803323684410075397 SELECT c.oid, c.relname , nspname, CASE WHEN nspname NOT LIKE $1 THEN pg_catalog.quote_ident(nspname)||$2||pg_catalog.quote_ident(c.relname) ELSE pg_catalog.quote_ident(c.relname) END AS inherits FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace WHERE relkind=$3 AND NOT relispartition AND n.nspname NOT LIKE $4 AND n.nspname NOT IN ($5) ORDER BY relnamespace, c.relname 0 0 0 0 0 0 5 2.616822 0.430927 0.679777 0.5233644000000001 0.09490967200786228 725 125 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4959953577135587900 INSERT INTO "tbl001EC6050D15_7" 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 113 3.7676069999999995 0.016730000000000002 0.120336 0.03334165486725663 0.013043851891033553 113 453 0 47 2 0 0 0 0 0 0 0 0 340 44 116821
16385 16384 t -5982498092295170329 COPY public."tbl001EC6056FD2_63" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 10 876.467112 65.664217 112.166226 87.64671120000001 15.391210829715122 226930 13 4559 20 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7540327370434935583 LOCK TABLE public."tbl001EC6050BAC_6" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.159789 0.017714 0.035805 0.022827 0.0066333239674497176 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3810775853954192051 LOCK TABLE public."tbl001EC6050BAC_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.28620799999999996 0.024109 0.110094 0.04088685714285714 0.02850998386244255 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8198788514140200570 COPY public."tbl001EC6050B08_51" ("time", error, lowrange, highrange, "umtLastMeasTime_1", "2", "umtWindSpeed_MPH_3", "4", "umtRawWindDir_Degrees_5", "6", "umtAdjWindDir_Degrees_7", "8", "umtRelHumidity_9", "10", "umtRawBaromPress_Inches_Hg_11", "12", "umtAdjBaromPress_Inches_Hg_13", "14", "umtTrueNorthOffset_Degrees_15", "16", "umtLastRain_Date_and_Time_17", "18", "umtTemp1_Degrees_F_19", "20", "umtWindChill_Degrees_F_21", "22", "umtHeatIndex_Degrees_F_23", "24", "umtDewPoint_Degrees_F_25", "26", "umtDensityAltitude_Feet_27", "28", "umtRainToday_Inches_29", "umtTemp2_Degrees_F_30", "umtTemp3_Degrees_F_31", "umtTemp4_Degrees_F_32", "umtSolarRadiation_W_m_2_33", "umtSolarRadiation_2_W_m_2_34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52") TO stdout 0 0 0 0 0 0 10 898.9419909999999 51.024828 127.497565 89.89419910000001 24.530595390831238 154845 965 5545 250 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8604091278017362530 SELECT * FROM "tbl001EC6050BAC_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 17 6.372472999999999 0.082724 2.536396 0.3748513529411764 0.5546981406422714 1700 1109 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 5917848358044273777 CREATE TABLE _2226f104e65c25482ecf85656f2d6459(cmd_output text) 0 0 0 0 0 0 1 10.956613 10.956613 10.956613 10.956613 0 0 506 9 29 0 0 0 0 0 0 0 0 0 96 27 129997
16385 16384 t 8632792700459349074 SELECT * FROM "tbl001EC6050F3C_18" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 196 6.938181 0.016494 1.307554 0.03539888265306122 0.09202823035646372 195 389 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8421061646270938313 COPY public."tbl001EC6056D41_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 905.662597 61.833779 124.890925 90.56625970000002 20.986748409391993 44930 60 5143 10 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8070351527374888184 LOCK TABLE public."tbl001EC6050BAC_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.243113 0.02611 0.060258 0.03473042857142857 0.01130247303984073 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 730227237538746438 INSERT INTO "tbl001EC6056D47_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 15483 811.7347380000015 0.019958 3.623242 0.052427484208486426 0.07145014106540674 15483 97719 30 10797 1464 0 0 0 0 0 0 0 0 46492 8200 46382641
16385 16384 t -3222319528423459660 SELECT * FROM "tbl001EC60537AE_21" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6102 313.5467729999991 0.019996 27.72399 0.05138426302851525 0.3611766932999646 6102 18295 11 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6578492390966547274 COPY public."tbl001EC6056FD2_68" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 10 830.988222 64.517253 105.387025 83.09882219999999 14.01969841893928 226930 12 4560 17 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2806822033505886082 COPY public."tbl001EC6050BAC_4" ("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 87.63458000000001 0.104437 28.610535 12.519225714285716 9.231310271562593 30534 341 106 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5137064085390758043 COPY public."tbl001EC6050F3C_4" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 1 0.109506 0.109506 0.109506 0.109506 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4878707545885608142 CREATE TABLE IF NOT EXISTS "tbl001EC6050B87_103" ( 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.750843 5.750843 5.750843 5.750843 0 0 979 2 2 0 0 0 0 0 0 0 0 0 244 3 30542
16385 16384 t 6939967601914723008 SELECT * FROM "tbl001EC6056D48_54" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30030 1196.6013890000015 0.021163 5.238335999999999 0.039846866100566106 0.04075968488478831 30030 90084 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2728844883155562069 SELECT * FROM "tbl001EC6056FD2_65" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30110 718.0359409999937 0.012649 2.315858 0.023847092029226163 0.022354856251253663 30110 90324 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7495041084759439798 COPY public."tbl001EC6056FD2_69" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 10 931.0034579999999 62.686077 212.323755 93.10034579999999 41.34686021055406 226930 12 4674 16 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6399601835940483637 SELECT * FROM "tbl001EC6050B5D_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1698 46.15319799999997 0.006054 1.945735 0.027180917550058893 0.07569779864398711 1697 4291 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -5614445698698362613 DROP TABLE IF EXISTS _17420e22a403a608b362eab2ca36f294 0 0 0 0 0 0 1 2.952382 2.952382 2.952382 2.952382 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8990124472011411541 COPY public."tbl001EC6057D26_4" ("time", error, lowrange, highrange, "Energy_Consumption_kWh_1", "Real_Power_kW_2") TO stdout 0 0 0 0 0 0 10 497.301392 43.489413 57.10536 49.730139199999996 3.9455899375010492 312530 0 4352 5 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 3347120587144832405 CREATE TABLE _9ab9890ff5dc38766929ad30eb64b9fa(cmd_output text) 0 0 0 0 0 0 1 64.676934 64.676934 64.676934 64.676934 0 0 425 84 26 0 0 0 0 0 0 0 0 0 94 26 127638
16385 13761 t 330520895731891762 DROP TABLE IF EXISTS _e4729764321e501e1fbf403016de8e13 0 0 0 0 0 0 1 0.098496 0.098496 0.098496 0.098496 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1340390920085549112 SELECT * FROM "tbl001EC6050B87_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 35 102.334876 0.45072 9.187782 2.9238536000000006 2.504644501062219 3249 9779 87 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8095371386334089592 SELECT * FROM "tbl001EC6050E4D_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 10172 282.21618000000046 0.014931 5.218069 0.02774441407786075 0.07040159814139955 10172 30502 14 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5213747156078326986 SELECT * FROM "dl_device_type" ORDER BY "id" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 12 4.104540999999999 0.016644 0.787324 0.34204508333333333 0.3268861891386303 36 6 6 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7163594200886564484 SELECT * FROM "tbl001EC6056300_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.43579399999999996 0.43579399999999996 0.43579399999999996 0.43579399999999996 0 100 29 0 0 0 0 0 0 0 0 0 0 0 0 0 0