Tables

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

pg_stat_statements

userid
oid 		dbid
oid 		toplevel
boolean 		queryid
bigint 		query
text 		plans
bigint 		total_plan_time
double precision 		min_plan_time
double precision 		max_plan_time
double precision 		mean_plan_time
double precision 		stddev_plan_time
double precision 		calls
bigint 		total_exec_time
double precision 		min_exec_time
double precision 		max_exec_time
double precision 		mean_exec_time
double precision 		stddev_exec_time
double precision 		rows
bigint 		shared_blks_hit
bigint 		shared_blks_read
bigint 		shared_blks_dirtied
bigint 		shared_blks_written
bigint 		local_blks_hit
bigint 		local_blks_read
bigint 		local_blks_dirtied
bigint 		local_blks_written
bigint 		temp_blks_read
bigint 		temp_blks_written
bigint 		blk_read_time
double precision 		blk_write_time
double precision 		wal_records
bigint 		wal_fpi
bigint 		wal_bytes
numeric
16385 16384 t -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 -7537797670365763549 CREATE TABLE IF NOT EXISTS "tbl001EC6050D17_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, "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 10.586167 10.586167 10.586167 10.586167 0 0 766 8 11 2 0 0 0 0 0 0 0 0 152 9 51766
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 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 3143 208.13778899999974 0.021461 2.8264359999999997 0.06622265001590832 0.10291588555849182 3143 21074 33 6268 238 0 0 0 0 0 0 0 0 9438 5845 27184284
16385 16384 t 1040928733185071499 LOCK TABLE public."tbl001EC605311A_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.43059200000000003 0.020114 0.177866 0.03914472727272727 0.044127162550336295 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8679524522967577531 LOCK TABLE public."tbl001EC6050D16_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.165402 0.017192 0.03684 0.023628857142857142 0.007318006743224384 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3057379645773571648 SELECT * FROM "tbl001EC6050D15_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 676 16.177228000000003 0.011151000000000001 0.161062 0.02393081065088755 0.011490097308526735 675 1351 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2897522876661520132 LOCK TABLE public."tbl001EC6050F3C_14" IN ACCESS SHARE MODE 0 0 0 0 0 0 2 0.04007 0.017389 0.022681 0.020035 0.002645999999999999 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1814370596331611952 INSERT INTO "tbl001EC6053CD9_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 3085 162.28827100000035 0.017978 1.937707 0.05260559837925449 0.08476474665204026 3085 18765 30 4099 93 0 0 0 0 0 0 0 0 9264 3970 17146973
16385 16384 t -4625257651897727048 COPY public."tbl001EC6050D16_8" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 7 1408.1964469999998 171.661503 242.64448 201.170921 20.08283562628112 472714 1207 6177 196 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -565194790615235258 SELECT * FROM "pg_stat_statements" ORDER BY "userid" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 23 161.06343800000002 0.9132800000000001 13.624467 7.002758173913044 2.4407587281237606 2300 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7142464264251281921 SELECT t.tableoid, t.oid, t.relname AS indexname, inh.inhparent AS parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, $1) AS condef, (SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, (SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= $2) AS indstatcols,(SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= $3) AS indstatvals FROM pg_catalog.pg_index i JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ($4,$5,$6)) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE i.indrelid = $7::pg_catalog.oid AND (i.indisvalid OR t2.relkind = $8) AND i.indisready ORDER BY indexname 0 0 0 0 0 0 2202 548.8226000000004 0.107936 3.321267 0.24923823796548567 0.1736729433418814 2444 119449 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4768530841728936381 SELECT pg_catalog.current_schemas($1) 0 0 0 0 0 0 11 0.11142200000000001 0.008629 0.010886 0.010129272727272726 0.0006119493578139662 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5040234604267774686 CREATE TABLE IF NOT EXISTS "tbl001EC6050D17_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, "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 5.38204 5.38204 5.38204 5.38204 0 0 660 1 1 0 0 0 0 0 0 0 0 0 165 2 18921
16385 16384 t -2010390643943443536 SELECT * FROM public.tbldevicelist ORDER BY serialnumber ASC, deviceid ASC 0 0 0 0 0 0 1 1065.170247 1065.170247 1065.170247 1065.170247 0 113 155 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6784625302332255417 SELECT * FROM "tbl001EC6050D16_6" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2006 57.124053000000025 0.005685 3.6381040000000002 0.028476596709870412 0.10022539454487742 2005 6004 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7111590912746581764 SELECT * FROM "tbl001EC6050F3C_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 18 1.0523289999999998 0.026916000000000002 0.28719100000000003 0.05846272222222223 0.06228432643736442 184 28 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4220555902766683239 COPY public."tbl001EC6050E4D_81" ("time", error, lowrange, highrange, "Inverter_ID_ASCII_CHAR_00_01_1", "Inverter_ID_ASCII_CHAR_02_03_2", "Inverter_ID_ASCII_CHAR_04_05_3", "Inverter_ID_ASCII_CHAR_06_07_4", "Inverter_ID_ASCII_CHAR_08_09_5", "Inverter_ID_ASCII_CHAR_10_11_6", "Inverter_ID_ASCII_CHAR_12_13_7", "Inverter_ID_ASCII_CHAR_14_15_8", "Firmware_Version_ASCII_CHAR_00_01_9", "Firmware_Version_ASCII_CHAR_02_03_10", "Firmware_Version_ASCII_CHAR_04_05_11", "Firmware_Version_ASCII_CHAR_06_07_12", "Map_version_13", "Inverter_configuration_14", "Inverter_serial_ASCII_CHAR_00_01_15", "Inverter_serial_ASCII_CHAR_02_03_16", "Inverter_serial_ASCII_CHAR_04_05_17", "Inverter_serial_ASCII_CHAR_06_07_18", "Inverter_serial_ASCII_CHAR_08_09_19", "Inverter_serial_ASCII_CHAR_10_11_20", "Inverter_serial_ASCII_CHAR_12_13_21", "Inverter_serial_ASCII_CHAR_14_15_22", "Inverter_serial_ASCII_CHAR_16_17_23", "Inverter_serial_ASCII_CHAR_18_19_24", "Voltage_A_N_V_25", "Voltage_B_N_V_26", "Voltage_C_N_V_27", "Current_A_A_28", "Current_B_A_29", "Current_C_A_30", "DC_input_voltage_V_31", "DC_input_current_A_32", "Line_Frequency_Hz_33", "Output_Generation_kW_34", "Total_Energy_Generation_kWh_35", "PV_Input_Voltage_V_36", "Input_Generation_calculated_kW_37", "Inverter_operating_status_state_38", "Main_fault_39", "Drive_fault_40", "Voltage_fault_41", "Grid_fault_42", "Temperature_fault_43", "System_fault_44", "System_warnings_45", "PVM_status_codes_46") TO stdout 0 0 0 0 0 0 11 847.418736 48.643723 106.227253 77.0380669090909 17.94988988227983 90915 730 5656 10 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 1082215851026803613 CREATE TABLE _a908b847722fa1757f671f6dff72b460(cmd_output text) 0 0 0 0 0 0 1 66.744299 66.744299 66.744299 66.744299 0 0 424 84 26 0 0 0 0 0 0 0 0 0 92 26 127338
16385 16384 t 971599790306233887 LOCK TABLE public."tbl001EC6050F42_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 2 0.036679 0.017645 0.019034 0.0183395 0.0006944999999999998 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2976514019300773964 INSERT INTO "tbl001EC6050B08_1" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15724 578.5266970000031 0.01432 69.750497 0.03679259075298886 0.6212283285207038 15724 95434 48 2331 141 0 0 0 0 0 0 0 0 47216 2154 12217112
16385 16384 t 7968269503055555352 COPY _timescaledb_catalog.compression_settings (relid, compress_relid, segmentby, orderby, orderby_desc, orderby_nullsfirst) TO stdout 0 0 0 0 0 0 11 0.274342 0.020434 0.028812 0.02494018181818182 0.00242919215221783 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5299325378462449066 LOCK TABLE public."tbl001EC6050D06_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.7687890000000001 0.023659 0.605082 0.109827 0.20220918168711188 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3659150719234830581 -- Fetches access methods SELECT oid, amname FROM pg_catalog.pg_am WHERE amtype = $1 0 0 0 0 0 0 5 0.082084 0.013684 0.019334 0.0164168 0.0022940968942047773 10 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8572223745803511587 SELECT * FROM "tbl001EC6053075_53" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 20 7.259778999999999 0.022871 1.804158 0.36298895 0.39399205551108196 1048 568 3 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9134371259352253247 CREATE TABLE IF NOT EXISTS "tbl001EC60537E0_21" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Vln_a_Volts_1" DOUBLE PRECISION DEFAULT NULL, "Vln_b_Volts_2" DOUBLE PRECISION DEFAULT NULL, "Vln_c_Volts_3" DOUBLE PRECISION DEFAULT NULL, "Vln_ave_Volts_4" DOUBLE PRECISION DEFAULT NULL, "Vll_ab_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Vll_bc_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Vll_ca_Volts_7" DOUBLE PRECISION DEFAULT NULL, "Vll_ave_Volts_8" DOUBLE PRECISION DEFAULT NULL, "I_a_Amps_9" DOUBLE PRECISION DEFAULT NULL, "I_b_Amps_10" DOUBLE PRECISION DEFAULT NULL, "I_c_Amps_11" DOUBLE PRECISION DEFAULT NULL, "I_ave_Amps_12" DOUBLE PRECISION DEFAULT NULL, "V_unbal_13" DOUBLE PRECISION DEFAULT NULL, "I_unbal_14" DOUBLE PRECISION DEFAULT NULL, "Freq_Hz_15" DOUBLE PRECISION DEFAULT NULL, "I4_Amps_16" DOUBLE PRECISION DEFAULT NULL, "kW_a_kW_17" DOUBLE PRECISION DEFAULT NULL, "kW_b_kW_18" DOUBLE PRECISION DEFAULT NULL, "kW_c_kW_19" DOUBLE PRECISION DEFAULT NULL, "kW_tot_kW_20" DOUBLE PRECISION DEFAULT NULL, "kVAR_a_kVAR_21" DOUBLE PRECISION DEFAULT NULL, "kVAR_b_kVAR_22" DOUBLE PRECISION DEFAULT NULL, "kVAR_c_kVAR_23" DOUBLE PRECISION DEFAULT NULL, "kVAR_tot_kVAR_24" DOUBLE PRECISION DEFAULT NULL, "kVA_a_kVA_25" DOUBLE PRECISION DEFAULT NULL, "kVA_b_kVA_26" DOUBLE PRECISION DEFAULT NULL, "kVA_c_kVA_27" DOUBLE PRECISION DEFAULT NULL, "kVA_tot_kVA_28" DOUBLE PRECISION DEFAULT NULL, "PF_sign_a_29" DOUBLE PRECISION DEFAULT NULL, "PF_sign_b_30" DOUBLE PRECISION DEFAULT NULL, "PF_sign_c_31" DOUBLE PRECISION DEFAULT NULL, "PF_sign_tot_32" DOUBLE PRECISION DEFAULT NULL, "Vll_ave_mx_Volts_33" DOUBLE PRECISION DEFAULT NULL, "I_ave_mx_Amps_34" DOUBLE PRECISION DEFAULT NULL, "kW_tot_mx_kW_35" DOUBLE PRECISION DEFAULT NULL, "kVAR_tot_mx_kVAR_36" DOUBLE PRECISION DEFAULT NULL, "kVA_tot_mx_kVA_37" DOUBLE PRECISION DEFAULT NULL, "Freq_mx_Hz_38" DOUBLE PRECISION DEFAULT NULL, "Vll_ave_mn_Volts_39" DOUBLE PRECISION DEFAULT NULL, "I_ave_mn_Amps_40" DOUBLE PRECISION DEFAULT NULL, "Freq_mn_Hz_41" DOUBLE PRECISION DEFAULT NULL, "kW_sd_del_rec_kW_42" DOUBLE PRECISION DEFAULT NULL, "kVA_sd_del_rec_kVA_43" DOUBLE PRECISION DEFAULT NULL, "kVAR_sd_del_rec_kVAR_44" DOUBLE PRECISION DEFAULT NULL, "kW_sd_mx_d_r_kW_45" DOUBLE PRECISION DEFAULT NULL, "kVA_sd_mx_d_r_kVA_46" DOUBLE PRECISION DEFAULT NULL, "kVAR_sd_mx_d_r_kVAR_47" DOUBLE PRECISION DEFAULT NULL, "Phase_Rev_48" DOUBLE PRECISION DEFAULT NULL, "kWh_del_kWh_49" DOUBLE PRECISION DEFAULT NULL, "kWh_rec_kWh_50" DOUBLE PRECISION DEFAULT NULL, "kWh_del_rec_kWh_51" DOUBLE PRECISION DEFAULT NULL, "kWh_del_rec_kWh_52" DOUBLE PRECISION DEFAULT NULL, "kVARh_del_kVARh_53" DOUBLE PRECISION DEFAULT NULL, "kVARh_rec_kVARh_54" DOUBLE PRECISION DEFAULT NULL, "kVARh_del_rec_kVARh_55" DOUBLE PRECISION DEFAULT NULL, "kVARh_del_rec_kVARh_56" DOUBLE PRECISION DEFAULT NULL, "kVAh_del_rec_kVAh_57" DOUBLE PRECISION DEFAULT NULL, "V1_THD_mx_58" DOUBLE PRECISION DEFAULT NULL, "V2_THD_mx_59" DOUBLE PRECISION DEFAULT NULL, "V3_THD_mx_60" DOUBLE PRECISION DEFAULT NULL, "I1_THD_mx_61" DOUBLE PRECISION DEFAULT NULL, "I2_THD_mx_62" DOUBLE PRECISION DEFAULT NULL, "I3_THD_mx_63" DOUBLE PRECISION DEFAULT NULL, "unused_64" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.520495 5.520495 5.520495 5.520495 0 0 918 1 1 0 0 0 0 0 0 0 0 0 231 2 29101
16385 16384 t -3656337661882901967 CREATE TABLE IF NOT EXISTS "tbl001EC6050189_6" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Active_Power_Total_kW_1" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_Total_kVAR_2" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_Total_kVA_3" DOUBLE PRECISION DEFAULT NULL, "Voltage_Average_Volts_4" DOUBLE PRECISION DEFAULT NULL, "Voltage_L_L_Average_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Current_Average_Amps_6" DOUBLE PRECISION DEFAULT NULL, "System_Power_Factor_7" DOUBLE PRECISION DEFAULT NULL, "System_Frequency_Hz_8" DOUBLE PRECISION DEFAULT NULL, "Voltage_Average_Angle_Degrees_9" DOUBLE PRECISION DEFAULT NULL, "System_Quadrant_10" DOUBLE PRECISION DEFAULT NULL, "Voltage_A_Volts_11" DOUBLE PRECISION DEFAULT NULL, "Voltage_B_Volts_12" DOUBLE PRECISION DEFAULT NULL, "Voltage_C_Volts_13" DOUBLE PRECISION DEFAULT NULL, "Voltage_A_B_Volts_14" DOUBLE PRECISION DEFAULT NULL, "Voltage_B_C_Volts_15" DOUBLE PRECISION DEFAULT NULL, "Voltage_A_C_Volts_16" DOUBLE PRECISION DEFAULT NULL, "Current_A_Amps_17" DOUBLE PRECISION DEFAULT NULL, "Current_B_Amps_18" DOUBLE PRECISION DEFAULT NULL, "Current_C_Amps_19" DOUBLE PRECISION DEFAULT NULL, "Active_Power_A_kW_20" DOUBLE PRECISION DEFAULT NULL, "Active_Power_B_kW_21" DOUBLE PRECISION DEFAULT NULL, "Active_Power_C_kW_22" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_A_kVAR_23" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_B_kVAR_24" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_C_kVAR_25" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_A_kVA_26" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_B_kVA_27" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_C_kVA_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_A_29" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_B_30" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_C_31" DOUBLE PRECISION DEFAULT NULL, "Voltage_Angle_AB_Degrees_32" DOUBLE PRECISION DEFAULT NULL, "Voltage_Angle_BC_Degrees_33" DOUBLE PRECISION DEFAULT NULL, "Voltage_Angle_CA_Degrees_34" DOUBLE PRECISION DEFAULT NULL, "Quadrant_A_35" DOUBLE PRECISION DEFAULT NULL, "Quadrant_B_36" DOUBLE PRECISION DEFAULT NULL, "Quadrant_C_37" DOUBLE PRECISION DEFAULT NULL, "Sliding_Window_Power_kW_38" DOUBLE PRECISION DEFAULT NULL, "Net_Total_Energy_Revenue_kWh_39" DOUBLE PRECISION DEFAULT NULL, "Total_Net_Apparent_Energy_Revenue_kVA_40" DOUBLE PRECISION DEFAULT NULL, "Total_Import_Energy_Revenue_kWh_41" DOUBLE PRECISION DEFAULT NULL, "Total_Export_Energy_Revenue_kWh_42" DOUBLE PRECISION DEFAULT NULL, "Total_Import_Apparent_Energy_Revenue_kVA_43" DOUBLE PRECISION DEFAULT NULL, "Total_Export_Apparent_Energy_Revenue_kVA_44" DOUBLE PRECISION DEFAULT NULL, "Q1_Total_Reactive_Energy_Revenue_kVAR_45" DOUBLE PRECISION DEFAULT NULL, "Q2_Total_Reactive_Energy_Revenue_kVAR_46" DOUBLE PRECISION DEFAULT NULL, "Q3_Total_Reactive_Energy_Revenue_kVAR_47" DOUBLE PRECISION DEFAULT NULL, "Q4_Total_Reactive_Energy_Revenue_kVAR_48" DOUBLE PRECISION DEFAULT NULL, "Q1_Q2_Total_Inductive_Reactive_Energy_Revenue_kVAR_49" DOUBLE PRECISION DEFAULT NULL, "Q3_Q4_Total_Capacitive_Reactive_Energy_Revenue_kVAR_50" DOUBLE PRECISION DEFAULT NULL, "Net_Energy_Revenue_A_kWh_51" DOUBLE PRECISION DEFAULT NULL, "Net_Energy_Revenue_B_kWh_52" DOUBLE PRECISION DEFAULT NULL, "Net_Energy_Revenue_C_kWh_53" DOUBLE PRECISION DEFAULT NULL, "Net_Apparent_Energy_Revenue_A_kVA_54" DOUBLE PRECISION DEFAULT NULL, "Net_Apparent_Energy_Revenue_B_kVA_55" DOUBLE PRECISION DEFAULT NULL, "Net_Apparent_Energy_Revenue_C_kVA_56" DOUBLE PRECISION DEFAULT NULL, "Import_Energy_Revenue_A_kWh_57" DOUBLE PRECISION DEFAULT NULL, "Import_Energy_Revenue_B_kWh_58" DOUBLE PRECISION DEFAULT NULL, "Import_Energy_Revenue_C_kWh_59" DOUBLE PRECISION DEFAULT NULL, "Export_Energy_Revenue_A_kWh_60" DOUBLE PRECISION DEFAULT NULL, "Export_Energy_Revenue_B_kWh_61" DOUBLE PRECISION DEFAULT NULL, "Export_Energy_Revenue_C_kWh_62" DOUBLE PRECISION DEFAULT NULL, "Import_Apparent_Energy_Revenue_A_kVA_63" DOUBLE PRECISION DEFAULT NULL, "Import_Apparent_Energy_Revenue_B_kVA_64" DOUBLE PRECISION DEFAULT NULL, "Import_Apparent_Energy_Revenue_C_kVA_65" DOUBLE PRECISION DEFAULT NULL, "Export_Apparent_Energy_Revenue_A_kVA_66" DOUBLE PRECISION DEFAULT NULL, "Export_Apparent_Energy_Revenue_B_kVA_67" DOUBLE PRECISION DEFAULT NULL, "Export_Apparent_Energy_Revenue_C_kVA_68" DOUBLE PRECISION DEFAULT NULL, "Q1_Reactive_Energy_Revenue_A_kVAR_69" DOUBLE PRECISION DEFAULT NULL, "Q1_Reactive_Energy_Revenue_B_kVAR_70" DOUBLE PRECISION DEFAULT NULL, "Q1_Reactive_Energy_Revenue_C_kVAR_71" DOUBLE PRECISION DEFAULT NULL, "Q2_Reactive_Energy_Revenue_A_kVAR_72" DOUBLE PRECISION DEFAULT NULL, "Q2_Reactive_Energy_Revenue_B_kVAR_73" DOUBLE PRECISION DEFAULT NULL, "Q2_Reactive_Energy_Revenue_C_kVAR_74" DOUBLE PRECISION DEFAULT NULL, "Q3_Reactive_Energy_Revenue_A_kVAR_75" DOUBLE PRECISION DEFAULT NULL, "Q3_Reactive_Energy_Revenue_B_kVAR_76" DOUBLE PRECISION DEFAULT NULL, "Q3_Reactive_Energy_Revenue_C_kVAR_77" DOUBLE PRECISION DEFAULT NULL, "Q4_Reactive_Energy_Revenue_A_kVAR_78" DOUBLE PRECISION DEFAULT NULL, "Q4_Reactive_Energy_Revenue_B_kVAR_79" DOUBLE PRECISION DEFAULT NULL, "Q4_Reactive_Energy_Revenue_C_kVAR_80" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 64.359033 64.359033 64.359033 64.359033 0 0 1072 3 7 0 0 0 0 0 0 0 0 0 266 5 44050
16385 16384 t -4799179982342805770 SELECT name, setting::numeric AS setting FROM pg_catalog.pg_show_all_settings() WHERE name IN($1,$2,$3,$4,$5,$6,$7,$8,$9) ORDER BY name 0 0 0 0 0 0 1 1.013272 1.013272 1.013272 1.013272 0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4328456496576460561 SELECT * FROM "tbl001EC6050189_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1764 55.28692399999997 0.010315 1.895854 0.03134179365079366 0.10483623193152393 1763 4460 22 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4051327114397289912 COPY public."tbl001EC6050F3C_10" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 2 0.509508 0.164647 0.344861 0.254754 0.09010699999999999 110 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5802710290161220595 LOCK TABLE public."tbl001EC6056FD2_62" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.361428 0.017795 0.083578 0.03285709090909091 0.02140227269773234 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1541213248910491732 SELECT * FROM "tbl001EC605376F_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.103813 0.010385 0.055464000000000006 0.034604333333333334 0.01855612352357632 37 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2636973139054511894 SELECT t.main_oid, pg_catalog.ARRAY_AGG(t.typname) as edit_types FROM (SELECT pc.castsource AS main_oid, pg_catalog.format_type(tt.oid,$1) AS typname FROM pg_catalog.pg_type tt JOIN pg_catalog.pg_cast pc ON tt.oid=pc.casttarget WHERE pc.castsource IN ($2,$3,$4,$5) AND pc.castcontext IN ($6, $7) UNION SELECT tt.typbasetype AS main_oid, pg_catalog.format_type(tt.oid,$8) AS typname FROM pg_catalog.pg_type tt WHERE tt.typbasetype IN ($9,$10,$11,$12) ) t GROUP BY t.main_oid 0 0 0 0 0 0 10 7.428801999999999 0.340906 3.8334900000000003 0.7428802 1.0315570096114708 40 431 24 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -882219805100884322 LOCK TABLE public."tbl001EC6050D15_8" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.023913 0.023913 0.023913 0.023913 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2727057699474841330 LOCK TABLE public."tbl001EC605309C_55" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.37568500000000005 0.01837 0.064579 0.03415318181818182 0.013098337950207699 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5978342509712063983 SELECT * FROM "tbl001EC6050189_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 28 11.147419000000001 0.029955 5.8554319999999995 0.3981221071428572 1.075004058244411 1636 249 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2792773458370180312 INSERT INTO "tbl001EC6053093_52" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15719 880.5032749999983 0.019860999999999997 3.344963 0.05601522202430162 0.07639867278156466 15719 100284 40 10765 1669 0 0 0 0 0 0 0 0 47200 8047 45065808
16385 16384 t -1410948762246603517 SELECT rel.oid, rel.relname AS name, rel.reltablespace AS spcoid,rel.relacl AS relacl_str, (CASE WHEN length(spc.spcname::text) > $1 OR rel.relkind = $2 THEN spc.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 = $3::oid) END) as spcname, (CASE rel.relreplident WHEN $4 THEN $5 WHEN $6 THEN $7 WHEN $8 THEN $9 WHEN $10 THEN $11 END) as replica_identity, (select nspname FROM pg_catalog.pg_namespace WHERE oid = $12::oid ) as schema, pg_catalog.pg_get_userbyid(rel.relowner) AS relowner, rel.relkind, (CASE WHEN rel.relkind = $13 THEN $14 ELSE $15 END) AS is_partitioned, rel.relhassubclass, rel.reltuples::bigint, des.description, con.conname, con.conkey, EXISTS(select $16 FROM pg_catalog.pg_trigger JOIN pg_catalog.pg_proc pt ON pt.oid=tgfoid AND pt.proname=$17 JOIN pg_catalog.pg_proc pc ON pc.pronamespace=pt.pronamespace AND pc.proname=$18 WHERE tgrelid=rel.oid) AS isrepl, (SELECT count(*) FROM pg_catalog.pg_trigger WHERE tgrelid=rel.oid AND tgisinternal = $19) AS triggercount, (SELECT ARRAY(SELECT CASE WHEN (nspname NOT LIKE $20) THEN pg_catalog.quote_ident(nspname)||$21||pg_catalog.quote_ident(c.relname) ELSE pg_catalog.quote_ident(c.relname) END AS inherited_tables FROM pg_catalog.pg_inherits i JOIN pg_catalog.pg_class c ON c.oid = i.inhparent JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace WHERE i.inhrelid = rel.oid ORDER BY inhseqno)) AS coll_inherits, (SELECT count(*) FROM pg_catalog.pg_inherits i JOIN pg_catalog.pg_class c ON c.oid = i.inhparent JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace WHERE i.inhrelid = rel.oid) AS inherited_tables_cnt, (CASE WHEN rel.relpersistence = $22 THEN $23 ELSE $24 END) AS relpersistence, (SELECT st.setting from pg_catalog.pg_show_all_settings() st WHERE st.name = $25) as default_amname, substring(pg_catalog.array_to_string(rel.reloptions, $26) FROM $27) AS fillfactor, substring(pg_catalog.array_to_string(rel.reloptions, $28) FROM $29) AS parallel_workers, substring(pg_catalog.array_to_string(rel.reloptions, $30) FROM $31) AS toast_tuple_target, (substring(pg_catalog.array_to_string(rel.reloptions, $32) FROM $33))::BOOL AS autovacuum_enabled, substring(pg_catalog.array_to_string(rel.reloptions, $34) FROM $35) AS autovacuum_vacuum_threshold, substring(pg_catalog.array_to_string(rel.reloptions, $36) FROM $37) AS autovacuum_vacuum_scale_factor, substring(pg_catalog.array_to_string(rel.reloptions, $38) FROM $39) AS autovacuum_analyze_threshold, substring(pg_catalog.array_to_string(rel.reloptions, $40) FROM $41) AS autovacuum_analyze_scale_factor, substring(pg_catalog.array_to_string(rel.reloptions, $42) FROM $43) AS autovacuum_vacuum_cost_delay, substring(pg_catalog.array_to_string(rel.reloptions, $44) FROM $45) AS autovacuum_vacuum_cost_limit, substring(pg_catalog.array_to_string(rel.reloptions, $46) FROM $47) AS autovacuum_freeze_min_age, substring(pg_catalog.array_to_string(rel.reloptions, $48) FROM $49) AS autovacuum_freeze_max_age, substring(pg_catalog.array_to_string(rel.reloptions, $50) FROM $51) AS autovacuum_freeze_table_age, (substring(pg_catalog.array_to_string(tst.reloptions, $52) FROM $53))::BOOL AS toast_autovacuum_enabled, substring(pg_catalog.array_to_string(tst.reloptions, $54) FROM $55) AS toast_autovacuum_vacuum_threshold, substring(pg_catalog.array_to_string(tst.reloptions, $56) FROM $57) AS toast_autovacuum_vacuum_scale_factor, substring(pg_catalog.array_to_string(tst.reloptions, $58) FROM $59) AS toast_autovacuum_analyze_threshold, substring(pg_catalog.array_to_string(tst.reloptions, $60) FROM $61) AS toast_autovacuum_analyze_scale_factor, substring(pg_catalog.array_to_string(tst.reloptions, $62) FROM $63) AS toast_autovacuum_vacuum_cost_delay, substring(pg_catalog.array_to_string(tst.reloptions, $64) FROM $65) AS toast_autovacuum_vacuum_cost_limit, substring(pg_catalog.array_to_string(tst.reloptions, $66) FROM $67) AS toast_autovacuum_freeze_min_age, substring(pg_catalog.array_to_string(tst.reloptions, $68) FROM $69) AS toast_autovacuum_freeze_max_age, substring(pg_catalog.array_to_string(tst.reloptions, $70) FROM $71) AS toast_autovacuum_freeze_table_age, rel.reloptions AS reloptions, tst.reloptions AS toast_reloptions, rel.reloftype, am.amname, CASE WHEN typ.typname IS NOT NULL THEN (select pg_catalog.quote_ident(nspname) FROM pg_catalog.pg_namespace WHERE oid = $72::oid )||$73||pg_catalog.quote_ident(typ.typname) ELSE typ.typname END AS typname, typ.typrelid AS typoid, rel.relrowsecurity as rlspolicy, rel.relforcerowsecurity as forcerlspolicy, (CASE WHEN rel.reltoastrelid = $74 THEN $75 ELSE $76 END) AS hastoasttable, (SELECT pg_catalog.array_agg(provider || $77 || label) FROM pg_catalog.pg_seclabels sl1 WHERE sl1.objoid=rel.oid AND sl1.objsubid=$78) AS seclabels, (CASE WHEN rel.oid <= $79::oid THEN $80 ElSE $81 END) AS is_sys_table -- Added for partition table , (CASE WHEN rel.relkind = $82 THEN pg_catalog.pg_get_partkeydef($83::oid) ELSE $84 END) AS partition_scheme FROM pg_catalog.pg_class rel LEFT OUTER JOIN pg_catalog.pg_tablespace spc on spc.oid=rel.reltablespace LEFT OUTER JOIN pg_catalog.pg_description des ON (des.objoid=rel.oid AND des.objsubid=$85 AND des.classoid=$86::regclass) LEFT OUTER JOIN pg_catalog.pg_constraint con ON con.conrelid=rel.oid AND con.contype=$87 LEFT OUTER JOIN pg_catalog.pg_class tst ON tst.oid = rel.reltoastrelid LEFT JOIN pg_catalog.pg_type typ ON rel.reloftype=typ.oid LEFT OUTER JOIN pg_catalog.pg_am am ON am.oid = rel.relam WHERE rel.relkind IN ($88,$89,$90,$91) AND rel.relnamespace = $92::oid AND NOT rel.relispartition AND rel.oid = $93::oid ORDER BY rel.relname 0 0 0 0 0 0 10 12.157136 1.04755 1.4202 1.2157136 0.11246697211199388 10 228 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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 11 52.145579000000005 3.06892 6.339644 4.740507181818181 0.8760595790441759 12804 60 168 3 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 11 0.23668100000000003 0.016515 0.032715 0.021516454545454547 0.0044106842669226895 0 66 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 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 11 0.733331 0.052948 0.102009 0.06666645454545454 0.014541697696084101 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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 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 4343719152629286573 SELECT * FROM "tbl001EC6056D48_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30490 1223.8766209999987 0.021846 2.4359 0.040140263069858934 0.031913123949769584 30490 91464 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4562635154046073478 LOCK TABLE public."tbl001EC6050F42_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 2 0.03722 0.018452 0.018768 0.01861 0.00015800000000000102 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7790752409443090056 SELECT * FROM "tbl001EC605376F_42" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.10017700000000002 0.012014 0.050379 0.033392333333333336 0.01596732827439275 37 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1348311984683174184 SELECT * FROM "tbl001EC6053075_54" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 20 14.333261 0.026506 9.019813 0.7166630500000001 1.92007167404364 1048 555 17 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3429958618568471424 CREATE TABLE IF NOT EXISTS "tbl001EC6053109_2" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "AC_Current_Amps_1" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_Amps_2" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_Amps_3" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_Amps_4" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_AB_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_BC_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_CA_Volts_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_AN_Volts_8" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_BN_Volts_9" DOUBLE PRECISION DEFAULT NULL, "Phase_Voltage_CN_Volts_10" DOUBLE PRECISION DEFAULT NULL, "AC_Power_W_11" DOUBLE PRECISION DEFAULT NULL, "Line_Frequency_Hz_12" DOUBLE PRECISION DEFAULT NULL, "AC_Apparent_Power_VA_13" DOUBLE PRECISION DEFAULT NULL, "AC_Reactive_Power_VAR_14" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Factor_15" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_Wh_16" DOUBLE PRECISION DEFAULT NULL, "DC_Amps_Amps_17" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_Volts_18" DOUBLE PRECISION DEFAULT NULL, "DC_Power_W_19" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_Degrees_20" DOUBLE PRECISION DEFAULT NULL, "Heat_Sink_Temperature_Degrees_21" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_Degrees_22" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_Degrees_23" DOUBLE PRECISION DEFAULT NULL, "Operating_State_24" DOUBLE PRECISION DEFAULT NULL, "Vendor_Specific_Operating_State_25" DOUBLE PRECISION DEFAULT NULL, "Event_Field_26" DOUBLE PRECISION DEFAULT NULL, "Reserved_for_Future_27" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_1_28" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_2_29" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_3_30" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_4_31" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 11.72393 11.72393 11.72393 11.72393 0 0 873 5 36 0 0 0 0 0 0 0 0 0 163 36 178339
16385 16384 t 3201703779189533466 CREATE TABLE IF NOT EXISTS "tbl001EC6050F42_2" ( 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 6.206942 6.206942 6.206942 6.206942 0 0 977 1 1 0 0 0 0 0 0 0 0 0 242 2 30091
16385 16384 t 5933109379755905979 CREATE TABLE IF NOT EXISTS "tbl001EC60537E0_41" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.317812 5.317812 5.317812 5.317812 0 0 574 1 1 0 0 0 0 0 0 0 0 0 145 2 16904
16385 16384 t 65544975340227788 INSERT INTO "tbl001EC6050BAC_7" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 10277 574.7372599999995 0.016606 80.97954899999999 0.055924614187019515 0.8407842219280552 10277 62552 107 5719 173 0 0 0 0 0 0 0 0 30859 5493 25199290
16385 16384 t -442469455401687402 CREATE TABLE IF NOT EXISTS "tbl001EC6050D16_5" ( 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.576155 6.576155 6.576155 6.576155 0 0 529 1 2 0 0 0 0 0 0 0 0 0 135 2 15177
16385 16384 t -483581019345127367 SELECT * FROM "tbl001EC6050B5D_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1750 44.07354300000003 0.005894 2.06439 0.02518488171428569 0.09201965631766947 1749 4438 14 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2699684817093607924 SELECT tableoid, oid, trftype, trflang, trffromsql::oid, trftosql::oid FROM pg_transform ORDER BY 3,4 0 0 0 0 0 0 11 0.4707309999999999 0.00937 0.35039499999999996 0.04279372727272727 0.09729495552007253 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8274179422118525060 INSERT INTO "tbl001EC6050D15_11" 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 345 14.35425000000001 0.017266 0.772228 0.04160652173913046 0.056045866135113274 345 1438 4 180 18 0 0 0 0 0 0 0 0 1036 159 670482
16385 16384 t -8312020551412358667 LOCK TABLE public."tbl001EC60530AB_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.345855 0.017443 0.083723 0.031441363636363635 0.01879110083026599 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1372248509797170056 INSERT INTO "tbl001EC6050B5D_5" 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 885 69.88586300000006 0.020784 1.432421 0.0789670768361582 0.1289400633784786 885 5119 19 1750 73 0 0 0 0 0 0 0 0 2658 1619 7122038
16385 16384 t -9071582206613949658 COPY public."tbl001EC60537E0_1" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 8 34.385540999999996 0.092576 8.591339 4.2981926249999995 2.8109977604241316 8232 83 87 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7886904903562962196 COPY public."tbl001EC6050F3C_12" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 2 0.6676789999999999 0.10576 0.561919 0.33383949999999996 0.22807949999999996 110 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6652475622356794773 SELECT * FROM "tbl001EC6050D16_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 20 14.89993 0.08710999999999999 10.234609 0.7449965000000002 2.1833228529309516 2000 216 14 38 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1550223518595681575 SELECT tableoid, oid, conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, conislocal, convalidated FROM pg_catalog.pg_constraint WHERE conrelid = $1::pg_catalog.oid AND contype = $2 ORDER BY conname 0 0 0 0 0 0 77 56.92865 0.050272000000000004 28.018425 0.7393331168831171 3.221986805696662 187 1770 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2230960223627339489 SELECT * FROM "tbl001EC6052F1E_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 1.930239 0.953699 0.9765400000000001 0.9651195 0.011420500000000056 200 107 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2595978008277294514 SELECT * FROM "tbl001EC6056D48_54" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.774273 1.0262069999999999 1.748066 1.3871365 0.36092949999999996 200 122 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6098363154823117603 LOCK TABLE public."tbl001EC6050F3C_33" IN ACCESS SHARE MODE 0 0 0 0 0 0 2 0.037791 0.018829 0.018962 0.0188955 6.650000000000059e-05 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2569534678322355869 SELECT * FROM "tbl001EC6053CD9_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6162 142.70158399999977 0.00552 2.332894 0.023158322622525086 0.06514049180527177 6161 17664 18 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6520824371814131922 SELECT * FROM "tbl001EC6056FD2_69" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30576 727.2541480000062 0.012551999999999999 2.553811 0.023785130429094713 0.025088046470112754 30576 91720 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8273831527290367797 LOCK TABLE public."tbl001EC6050B5D_4" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.46571000000000007 0.018759 0.222285 0.046571 0.05929860704266164 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7175220845891814510 LOCK TABLE public."tbl001EC6050F3A_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.258575 0.015834 0.039448 0.02350681818181818 0.006669046665115457 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -976334833404158609 SELECT * FROM "tbl001EC6050E0D_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 21 101.96220799999999 0.379575 46.054031 4.855343238095238 9.34305762514889 2054 883 141 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1481344677969933194 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ, READ ONLY 0 0 0 0 0 0 11 0.201937 0.009105 0.068753 0.018357909090909088 0.01664814777824491 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 136252990403096131 SELECT * FROM "tbl001EC6053113_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29992 1232.9148710000052 0.021506 5.620260999999999 0.041108124533209084 0.060072126220228395 29992 89954 22 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 71775507807620743 INSERT INTO "tbl001EC60530AB_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15719 1129.4938870000026 0.018775 3.278182 0.07185532712004566 0.14110129583255288 15719 98793 400 11257 1489 0 0 0 0 0 0 0 0 47201 8407 47251038
16385 16384 t -1691636211689457488 LOCK TABLE public."tbl001EC6056FD2_63" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.409491 0.020923 0.087893 0.03722645454545455 0.019029132046148402 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 68967903307612389 COPY public."tbl001EC6053113_51" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 11 4158.818405 297.656437 462.018007 378.07440045454547 54.079544387752804 357203 1698 31089 67 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5004064929645400987 SELECT * FROM "tbl001EC6050B42_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1188 33.38639300000001 0.006189 3.290241 0.028103024410774384 0.11955682883173137 1187 2743 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4995749201892890097 INSERT INTO "tbl001EC6054E7A_1" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 800 113.30288300000011 0.036312000000000004 6.334561 0.14162860375000005 0.34847059167185 800 4613 20 1675 88 0 0 0 0 0 0 0 0 2404 1514 6818218
16385 16384 t -8164023413121639355 COPY (SELECT key, value, include_in_telemetry FROM _timescaledb_catalog.metadata WHERE key <> 'uuid' ) TO stdout 0 0 0 0 0 0 11 3.41701 0.287025 0.357416 0.31063727272727276 0.018892549734513733 33 315 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3121421456577668548 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_10" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 6.288676 6.288676 6.288676 6.288676 0 0 1184 0 10 0 0 0 0 0 0 0 0 0 285 11 104060
16385 16384 t -6248636260715190795 SELECT * FROM "tbl001EC6050D16_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2014 49.00477800000006 0.006265 1.758365 0.02433206454816286 0.05798980280998738 2013 6033 7 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8546423845662519110 SELECT tableoid, oid, opfmethod, opfname, opfnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = opfowner) AS rolname FROM pg_opfamily 0 0 0 0 0 0 11 43.98994499999999 1.4848940000000002 11.559142 3.9990859090909088 3.3123122707756574 1617 1617 22 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 525121335948191611 SELECT * FROM "tbl001EC6054E88_56" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3708 85.74630400000046 0.006318000000000001 2.58995 0.023124677454153225 0.052414234948240365 3707 11099 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4951009737071786457 SET statement_timeout = 0 0 0 0 0 0 0 11 0.21739799999999998 0.012579 0.031617 0.019763454545454546 0.005975520294785086 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2532864466293132459 SELECT * FROM "tbl001EC6050B08_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2182 132.48432299999993 0.025384 9.1254 0.060716921631530786 0.25439458935241066 2182 6507 39 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1977002247549568647 SELECT * FROM "tbl001EC6050D06_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3556 89.39914900000014 0.006992 2.137028 0.025140368110236167 0.056930431027700464 3555 9853 7 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3048878174632196812 SELECT * FROM "tbl001EC6050F3C_13" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 20 1.1074899999999999 0.025910000000000002 0.169913 0.05537449999999999 0.042003014878101305 247 29 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4252400313008616439 COPY public."tbl001EC6053019_53" ("time", error, lowrange, highrange, "Volts_AB_Volts_1", "Volts_BC_Volts_2", "Volts_CA_Volts_3", "Volts_LL_Average_Volts_4", "Volts_A_Volts_5", "Volts_B_Volts_6", "Volts_C_Volts_7", "Volts_LN_Average_Volts_8", "Amps_A_Amps_9", "Amps_B_Amps_10", "Amps_C_Amps_11", "Frequency_Hz_12", "KW_A_kW_13", "KW_B_kW_14", "KW_C_KW_15", "PF_Sign_A_PF_16", "PF_Sign_B_PF_17", "PF_Sign_C_PF_18", "Volt_Unbalance_19", "Current_Unbalance_20", "Delivered_Energy_kWh_21", "Received_Energy_kWh_22", "Real_Power_kW_23", "Power_Factor_PF_24", "Reactive_Power_kVAR_25") TO stdout 0 0 0 0 0 0 4 20.682011000000003 0.15747 14.171587 5.170502750000001 5.341128448078757 1864 99 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7547780484281152998 SET client_encoding='utf-8' 0 0 0 0 0 0 4 0.021768000000000003 0.004574 0.006797 0.005442000000000001 0.0008810468205492831 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3592683811462456317 LOCK TABLE public.dl_device_type IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.490523 0.033407 0.060139 0.044593 0.007762121546915568 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -640465209022114382 COPY public."tbl001EC6050B42_51" ("time", error, lowrange, highrange, "Analog_In_1_1", "Analog_In_2_2", "Analog_In_3_3", "Analog_In_4_4", "Pulse_1_5", "Pulse_2_6", "Pulse_3_7", "Pulse_4_8", "Status_register_9", firmware_version_10, "Uptime_Seconds_11", "Pulse_State_Register_12", "Pulse_1_ontime_Sec_sec_13", "Pulse_2_ontime_Sec_sec_14", "Pulse_3_ontime_Sec_sec_15", "Pulse_4_ontime_Sec_sec_16", "Pulse_1_last_minute_change_17", "Pulse_2_last_minute_change_18", "Pulse_3_last_minute_change_19", "Pulse_4_last_minute_change_20") TO stdout 0 0 0 0 0 0 7 6.993944000000001 0.051853 1.912525 0.9991348571428571 0.6012220826356046 2086 62 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1172132525418181604 SELECT * FROM "tbl001EC6056D47_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.551272 1.201197 1.3500750000000001 1.275636 0.07443900000000009 200 118 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2507011100384492216 COPY public."tbl001EC6054E88_11" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 4 249.610883 27.918041 157.718367 62.40272075 55.05570377706876 70876 131 336 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4438480536054507265 SELECT * FROM "tbl001EC6056D47_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30356 1363.3657990000004 0.021686 4.862877 0.04491256420477 0.04389875911522514 30356 91063 5 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 2324359234509408544 CREATE TABLE _144aa827a4fad492647307df85afaedc(cmd_output text) 0 0 0 0 0 0 1 9.253317 9.253317 9.253317 9.253317 0 0 503 4 25 0 0 0 0 0 0 0 0 0 92 25 106797
16385 13761 t 1955960838628559790 DROP TABLE IF EXISTS _ccafc861c6b1d39fc441af1df7a5aec0 0 0 0 0 0 0 1 0.102606 0.102606 0.102606 0.102606 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1097640641922135359 SELECT * FROM "tbl001EC6050B5D_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 29 9.812589000000001 0.028876 4.553179 0.3383651379310345 0.843612359946681 1719 229 10 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3533659028345339021 SELECT * FROM "tbl001EC6054E88_56" ORDER BY "Analog_In_4_4" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 1.504125 1.504125 1.504125 1.504125 0 100 112 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4190113875669674168 SELECT * FROM "tbl001EC6050B42_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1188 36.96684000000002 0.006562999999999999 5.0920499999999995 0.031116868686868707 0.17769103832992159 1187 2740 14 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 7786961976843689786 CREATE TABLE _3eb965d5de91b869d392d074e8c7251e(cmd_output text) 0 0 0 0 0 0 1 6.463128 6.463128 6.463128 6.463128 0 0 503 3 24 0 0 0 0 0 0 0 0 0 93 25 106927
16385 16384 t -6714739107771292061 SELECT * FROM "tbl001EC6050F3C_13" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 226 8.446444 0.017298 1.3780999999999999 0.03737364601769913 0.10001061187595996 225 447 4 0 0 0 0 0 0 0 0 0 0 0 0 0