Tables

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

pg_stat_statements

userid
oid 		dbid
oid 		toplevel
boolean 		queryid
bigint 		query
text 		plans
bigint 		total_plan_time
double precision 		min_plan_time
double precision 		max_plan_time
double precision 		mean_plan_time
double precision 		stddev_plan_time
double precision 		calls
bigint 		total_exec_time
double precision 		min_exec_time
double precision 		max_exec_time
double precision 		mean_exec_time
double precision 		stddev_exec_time
double precision 		rows
bigint 		shared_blks_hit
bigint 		shared_blks_read
bigint 		shared_blks_dirtied
bigint 		shared_blks_written
bigint 		local_blks_hit
bigint 		local_blks_read
bigint 		local_blks_dirtied
bigint 		local_blks_written
bigint 		temp_blks_read
bigint 		temp_blks_written
bigint 		blk_read_time
double precision 		blk_write_time
double precision 		wal_records
bigint 		wal_fpi
bigint 		wal_bytes
numeric
16385 16384 t 225887813102036608 SET INTERVALSTYLE = POSTGRES 0 0 0 0 0 0 10 0.065739 0.004491 0.00913 0.0065739 0.0016137279479515746 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8402127413716926959 SELECT conrelid, confrelid FROM pg_constraint JOIN pg_depend ON (objid = confrelid) WHERE contype = $1 AND refclassid = $2::regclass AND classid = $3::regclass 0 0 0 0 0 0 10 64.653745 0.25934599999999997 18.203599 6.465374499999999 4.49266347309142 260 328 362 23 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2295190688490556421 SELECT * FROM "tbl001EC6050F3C_54" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.266017 0.027504999999999998 0.158072 0.08867233333333333 0.05362066676405863 119 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 494369471235960319 SELECT * FROM "tbl001EC6056D41_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 5900 252.67394399999964 0.021523999999999998 3.3814800000000003 0.04282609220338976 0.06836507081832956 5900 17695 5 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7319907314238209438 WITH INH_TABLES AS (SELECT at.attname AS name, ph.inhparent AS inheritedid, ph.inhseqno, pg_catalog.concat(nmsp_parent.nspname, $1,parent.relname ) AS inheritedfrom FROM pg_catalog.pg_attribute at JOIN pg_catalog.pg_inherits ph ON ph.inhparent = at.attrelid AND ph.inhrelid = $2::oid JOIN pg_catalog.pg_class parent ON ph.inhparent = parent.oid JOIN pg_catalog.pg_namespace nmsp_parent ON nmsp_parent.oid = parent.relnamespace GROUP BY at.attname, ph.inhparent, ph.inhseqno, inheritedfrom ORDER BY at.attname, ph.inhparent, ph.inhseqno, inheritedfrom ) SELECT DISTINCT ON (att.attnum) att.attname as name, att.atttypid, att.attlen, att.attnum, att.attndims, att.atttypmod, att.attacl, att.attnotnull, att.attoptions, att.attfdwoptions, att.attstattarget, att.attstorage, att.attidentity, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS defval, pg_catalog.format_type(ty.oid,$3) AS typname, pg_catalog.format_type(ty.oid,att.atttypmod) AS displaytypname, pg_catalog.format_type(ty.oid,att.atttypmod) AS cltype, inh.inheritedfrom, inh.inheritedid, CASE WHEN ty.typelem > $4 THEN ty.typelem ELSE ty.oid END as elemoid, (SELECT nspname FROM pg_catalog.pg_namespace WHERE oid = ty.typnamespace) as typnspname, ty.typstorage AS defaultstorage, description, pi.indkey, (SELECT count($5) FROM pg_catalog.pg_type t2 WHERE t2.typname=ty.typname) > $6 AS isdup, CASE WHEN length(coll.collname::text) > $7 AND length(nspc.nspname::text) > $8 THEN pg_catalog.concat(pg_catalog.quote_ident(nspc.nspname),$9,pg_catalog.quote_ident(coll.collname)) ELSE $10 END AS collspcname, EXISTS(SELECT $11 FROM pg_catalog.pg_constraint WHERE conrelid=att.attrelid AND contype=$12 AND att.attnum=ANY(conkey)) As is_fk, (SELECT pg_catalog.array_agg(provider || $13 || label) FROM pg_catalog.pg_seclabels sl1 WHERE sl1.objoid=att.attrelid AND sl1.objsubid=att.attnum) AS seclabels, (CASE WHEN (att.attnum < $14) THEN $15 ElSE $16 END) AS is_sys_column, (CASE WHEN (att.attidentity in ($17, $18)) THEN $19 WHEN (att.attgenerated in ($20)) THEN $21 ELSE $22 END) AS colconstype, (CASE WHEN (att.attgenerated in ($23)) THEN pg_catalog.pg_get_expr(def.adbin, def.adrelid) END) AS genexpr, tab.relname as relname, (CASE WHEN tab.relkind = $24 THEN $25 ELSE $26 END) AS is_view_only, (CASE WHEN att.attcompression = $27 THEN $28 WHEN att.attcompression = $29 THEN $30 END) AS attcompression, seq.* FROM pg_catalog.pg_attribute att JOIN pg_catalog.pg_type ty ON ty.oid=atttypid LEFT OUTER JOIN pg_catalog.pg_attrdef def ON adrelid=att.attrelid AND adnum=att.attnum LEFT OUTER JOIN pg_catalog.pg_description des ON (des.objoid=att.attrelid AND des.objsubid=att.attnum AND des.classoid=$31::regclass) LEFT OUTER JOIN (pg_catalog.pg_depend dep JOIN pg_catalog.pg_class cs ON dep.classid=$32::regclass AND dep.objid=cs.oid AND cs.relkind=$33) ON dep.refobjid=att.attrelid AND dep.refobjsubid=att.attnum LEFT OUTER JOIN pg_catalog.pg_index pi ON pi.indrelid=att.attrelid AND indisprimary LEFT OUTER JOIN pg_catalog.pg_collation coll ON att.attcollation=coll.oid LEFT OUTER JOIN pg_catalog.pg_namespace nspc ON coll.collnamespace=nspc.oid LEFT OUTER JOIN pg_catalog.pg_sequence seq ON cs.oid=seq.seqrelid LEFT OUTER JOIN pg_catalog.pg_class tab on tab.oid = att.attrelid LEFT OUTER join INH_TABLES as INH ON att.attname = INH.name WHERE att.attrelid = $34::oid AND att.attnum > $35 AND att.attisdropped IS FALSE ORDER BY att.attnum 0 0 0 0 0 0 10 20.758039 1.2623280000000001 3.218966 2.0758039 0.48697405285383527 789 5833 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3012658066671715784 SELECT current_database() datname, schemaname, relname, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_user_tables 0 0 0 0 0 0 176162 643700.592390987 1.111257 227.21604000000002 3.6540263643180735 4.727779227364486 34988149 74412288 2 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 3 0.43262 0.027945 0.28719100000000003 0.14420666666666668 0.10751030280654761 119 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2282511859623702562 SELECT * FROM "tbl001EC6050B87_4" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 25 34.018208 0.439652 2.381158 1.3607283199999998 0.46195132646665016 2249 6438 33 6 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8545590094234210170 LOCK TABLE public."tbl001EC6050D16_5" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.121948 0.017619 0.024502 0.020324666666666668 0.0023144176133292997 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6955603330327045958 COPY public.dl_device_type (id, device, type, field_indexes) TO stdout 0 0 0 0 0 0 10 3.9249659999999995 0.032894 0.800619 0.3924965999999999 0.35791894457941176 30 5 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1538463311646837960 COPY public."tbl001EC60537E0_2" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 7 27.132426 0.069702 7.638688 3.8760608571428574 2.409871871948052 6195 60 68 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5926408442729437112 SELECT * FROM "tbl001EC6050F3C_15" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 3 0.284942 0.046084999999999994 0.121968 0.09498066666666666 0.03463657723980371 119 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5735114473754242621 LOCK TABLE public."tbl001EC60537E0_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.17760399999999998 0.020171 0.04491 0.025372 0.00814575893158081 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6446420818457790957 COPY public."tbl001EC6056D47_10" ("time", error, lowrange, highrange, "Horizontal_Irradiance_W_m_2_1", "POA_Irradiance_W_m_2_2", "Ambient_Temperature_Degrees_F_3", "Module_Temperature_Degrees_F_4", "Future_Use_4_5", "Future_Use_5_6", "Future_Use_6_7", "Future_Use_7_8", "Burnout_0_9", "Burnout_1_10", "Burnout_2_11", "Burnout_3_12", "Burnout_4_13", "Burnout_5_14", "Burnout_6_15", "Burnout_7_16") TO stdout 0 0 0 0 0 0 10 815.6874639999999 57.842729 101.546404 81.5687464 15.394606345873672 223706 89 5595 44 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -683806654963068782 COPY public."tbl001EC6053075_54" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 3 4.13713 0.184541 2.543044 1.3790433333333332 0.963096348245018 972 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4397666565845001967 SELECT n.tableoid, n.oid, n.nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl,pg_catalog.acldefault($1,n.nspowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,n.nspowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) as nspacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($4,n.nspowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(n.nspacl,pg_catalog.acldefault($6,n.nspowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, $7 as initnspacl, $8 as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = $9::regclass AND pip.objsubid = $10) 0 0 0 0 0 0 10 20.567314 0.49808600000000003 13.465513 2.0567314 3.845683572990768 120 570 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4882574747548198773 INSERT INTO "tbl001EC6050B87_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,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 6352 426.1574580000003 0.024584 2.0736090000000003 0.0670902799118388 0.12887616004796537 6352 39737 268 6922 262 0 0 0 0 0 0 0 0 19075 6226 30542198
16385 16384 t -369225263547026319 LOCK TABLE public."tbl001EC6050B87_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.248117 0.01662 0.043608 0.027568555555555554 0.009252755686954517 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8488514408435710612 LOCK TABLE public."tbl001EC6050BAC_3" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.222434 0.01692 0.071673 0.03177628571428571 0.018721336526726362 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7804062200546042309 INSERT INTO "tbl001EC6050F3C_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,$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 64 3.057399 0.027508 0.214274 0.04777185937500002 0.024582006184572278 64 257 0 127 2 0 0 0 0 0 0 0 0 193 124 180218
16385 16384 t 2348671646788002121 SELECT * FROM "tbl001EC6050D16_7" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1922 46.56762400000001 0.006018 1.4341329999999999 0.024228732570239334 0.053136139281346056 1921 5756 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7222470803479689942 COPY public."tbl001EC6050BAC_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 7 99.980794 0.144939 34.098098 14.28297057142857 10.714482712357684 30534 259 250 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8002346355075884178 INSERT INTO "tbl001EC6050B42_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 547 41.21936199999998 0.023046 3.726053 0.07535532358318094 0.20808086057568848 547 2756 11 1082 12 0 0 0 0 0 0 0 0 1643 1074 4387245
16385 16384 t 6511573775884168016 SELECT * FROM "tbl001EC6050F3C_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 128 4.991550999999999 0.014917 1.320785 0.03899649218749999 0.11440437814878114 127 253 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6820329732018750356 COPY public."tbl001EC605309C_55" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 10 3672.9623810000003 282.954534 447.827106 367.29623810000004 56.168236668673174 324420 1618 28323 122 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8150460813502165903 INSERT INTO "tbl001EC6053075_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 784 43.48507300000002 0.026362 1.323457 0.05546565433673468 0.07486620655578001 784 4079 6 1237 16 0 0 0 0 0 0 0 0 2355 1511 6280571
16385 16384 t -1453871294263762574 INSERT INTO "tbl001EC6056D48_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 14983 806.1000760000009 0.019416 6.590057 0.05380097951011137 0.0769772133670644 14983 94707 30 10633 1396 0 0 0 0 0 0 0 0 44991 8013 45027154
16385 16384 t -2662247061889251328 COPY _timescaledb_catalog.dimension_slice (id, dimension_id, range_start, range_end) TO stdout 0 0 0 0 0 0 10 0.27242700000000003 0.022113 0.059864 0.0272427 0.010933113079539607 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 2080 126.38835199999986 0.025384 9.1254 0.06076363076923084 0.25750669175052193 2080 6204 36 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6481060525543427824 CREATE TABLE IF NOT EXISTS "tbl001EC6050B5D_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.414399 5.414399 5.414399 5.414399 0 0 542 1 3 0 0 0 0 0 0 0 0 0 135 3 23138
16385 16384 t 6098363154823117603 LOCK TABLE public."tbl001EC6050F3C_33" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.018829 0.018829 0.018829 0.018829 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7912531969073206869 SELECT * FROM "tbl001EC6050D21_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 9836 315.2254890000016 0.019174999999999998 2.230298 0.032048138369255824 0.04962495618228991 9836 29492 16 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6288392067785693354 SELECT * FROM "tbl001EC6053109_11" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 3948 117.80240900000011 0.012622999999999999 3.524928 0.02983850278622091 0.07889468315005943 3947 11029 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5508974441221300737 SELECT * FROM "tbl001EC60537E0_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 5 2.897394 0.09187 2.167801 0.5794788000000001 0.7977233715170692 500 79 3 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -802287773578263999 SELECT * FROM "tbl001EC6056D48_55" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29024 1159.2998999999995 0.02196 6.034558 0.03994280250826891 0.047978433089111185 29024 87066 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3696515394032386122 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_4" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Operating_State_I_Status_1" DOUBLE PRECISION DEFAULT NULL, "Vendor_Operating_State_I_Status_Vendor_2" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_1_bits_0_31_3" DOUBLE PRECISION DEFAULT NULL, "Event_Flags_I_Event_2_bits_32_63_4" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7" DOUBLE PRECISION DEFAULT NULL, "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8" DOUBLE PRECISION DEFAULT NULL, "AC_Total_Current_I_AC_Current_A_9" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_A_Current_I_AC_CurrentA_A_10" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_B_Current_I_AC_CurrentB_A_11" DOUBLE PRECISION DEFAULT NULL, "AC_Phase_C_Current_I_AC_CurrentC_A_12" DOUBLE PRECISION DEFAULT NULL, "ac_current_Scale_Factor_I_AC_Current_SF_13" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18" DOUBLE PRECISION DEFAULT NULL, "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19" DOUBLE PRECISION DEFAULT NULL, "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20" DOUBLE PRECISION DEFAULT NULL, "AC_Power_I_AC_Power_W_21" DOUBLE PRECISION DEFAULT NULL, "ac_power_Scale_Factor_I_AC_Power_SF_22" DOUBLE PRECISION DEFAULT NULL, "AC_Frequency_I_AC_Frequency_Hz_23" DOUBLE PRECISION DEFAULT NULL, "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24" DOUBLE PRECISION DEFAULT NULL, "Apparent_Power_I_AC_VA_VA_25" DOUBLE PRECISION DEFAULT NULL, "apparent_power_Scale_Factor_I_AC_VA_SF_26" DOUBLE PRECISION DEFAULT NULL, "Reactive_Power_I_AC_VAR_Var_27" DOUBLE PRECISION DEFAULT NULL, "reactive_power_Scale_Factor_I_AC_VAR_28" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_I_AC_PF_29" DOUBLE PRECISION DEFAULT NULL, "power_factor_Scale_Factor_I_AC_PF_SF_30" DOUBLE PRECISION DEFAULT NULL, "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31" DOUBLE PRECISION DEFAULT NULL, "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32" DOUBLE PRECISION DEFAULT NULL, "DC_Current_I_DC_Current_A_33" DOUBLE PRECISION DEFAULT NULL, "dc_current_Scale_Factor_I_DC_Current_SF_34" DOUBLE PRECISION DEFAULT NULL, "DC_Voltage_I_DC_Voltage_V_35" DOUBLE PRECISION DEFAULT NULL, "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36" DOUBLE PRECISION DEFAULT NULL, "DC_Power_I_DC_Power_W_37" DOUBLE PRECISION DEFAULT NULL, "dc_power_Scale_Factor_I_DC_Power_SF_38" DOUBLE PRECISION DEFAULT NULL, "Cabinet_Temperature_I_Temp_Cab_Deg_C_39" DOUBLE PRECISION DEFAULT NULL, "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40" DOUBLE PRECISION DEFAULT NULL, "Transformer_Temperature_I_Temp_Trans_Deg_C_41" DOUBLE PRECISION DEFAULT NULL, "Other_Temperature_I_Temp_Other_Deg_C_42" DOUBLE PRECISION DEFAULT NULL, "temperature_Scale_Factor_I_Temp_SF_43" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_ID_44" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_Model_Block_45" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_46" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_1_47" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_2_48" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_3_49" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_4_50" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_5_51" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_6_52" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_7_53" DOUBLE PRECISION DEFAULT NULL, "Manufacturer_C_Manufacturer_string_part_8_54" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_1_55" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_2_56" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_3_57" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_4_58" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_5_59" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_6_60" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_7_61" DOUBLE PRECISION DEFAULT NULL, "Inverter_Type_C_Model_string_part_8_62" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_1_63" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_2_64" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_3_65" DOUBLE PRECISION DEFAULT NULL, "C_Options_Manufacturer_specific_string_part_4_66" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_1_67" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_2_68" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_3_69" DOUBLE PRECISION DEFAULT NULL, "C_Version_Manufacturer_specific_string_part_4_70" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_1_71" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_2_72" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_3_73" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_4_74" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_5_75" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_6_76" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_7_77" DOUBLE PRECISION DEFAULT NULL, "C_SerialNumber_Manufacturer_specific_string_part_8_78" DOUBLE PRECISION DEFAULT NULL, "C_DeviceAddress_Modbus_ID_79" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_DID_End_Block_matches_FFFF_80" DOUBLE PRECISION DEFAULT NULL, "C_SunSpec_Length_Last_Block_matches_0_81" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 6.85263 6.85263 6.85263 6.85263 0 0 1151 1 7 1 0 0 0 0 0 0 0 0 280 6 61437
16385 16384 t 170429962571706666 COPY _timescaledb_catalog.continuous_aggs_watermark (mat_hypertable_id, watermark) TO stdout 0 0 0 0 0 0 10 0.21536899999999998 0.01994 0.023456 0.0215369 0.0011319553392250075 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 6393404535668029309 DROP TABLE IF EXISTS _ff45a1e53ba0ef87784c2f40412c7414 0 0 0 0 0 0 1 0.871007 0.871007 0.871007 0.871007 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6326833006665748217 INSERT INTO "tbl001EC6050BAC_9" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 9540 479.50439799999936 0.016689 23.562013999999998 0.050262515513626926 0.28178112687238965 9540 58000 65 5206 170 0 0 0 0 0 0 0 0 28646 4960 23154710
16385 13761 t 6019594207677937047 DROP TABLE IF EXISTS _9ab9890ff5dc38766929ad30eb64b9fa 0 0 0 0 0 0 1 3.07034 3.07034 3.07034 3.07034 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8915073500001129567 SELECT * FROM "tbl001EC6050F3C_19" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 128 5.2843019999999985 0.015307000000000001 1.336353 0.041283609375 0.11609780469832014 127 253 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4422191203373621282 SELECT * FROM "tbl001EC6056D48_53" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 3.215064 1.562818 1.652246 1.607532 0.04471400000000009 200 122 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3602045120360793345 LOCK TABLE public."tbl001EC6056D49_53" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.40418499999999996 0.025482 0.09577 0.04041850000000001 0.020960975388802882 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6227151994826533367 SELECT * FROM "tbl001EC6053109_5" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 8160 189.13509100000024 0.006695 3.612682 0.023178319975490223 0.05433844228415388 8159 23665 5 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2507011100384492216 COPY public."tbl001EC6054E88_11" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 3 217.460438 27.918041 157.718367 72.48681266666667 60.28890211901355 52725 124 224 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7336402659991131064 CREATE TABLE IF NOT EXISTS "tbl001EC6050D16_50" ( 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.54855 5.54855 5.54855 5.54855 0 0 566 1 10 0 0 0 0 0 0 0 0 0 143 9 52994
16385 16384 t -3699917728589253079 COPY public."tbl001EC6050B87_1" ("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 9 231.60094 1.86478 59.264409 25.73343777777778 16.735673750770847 27378 592 594 3 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -650394521924918714 COPY public."tbl001EC6050B42_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 6 5.582356 0.055085 2.043402 0.9303926666666668 0.7005701145114281 1500 18 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1111316300204717611 LOCK TABLE public."tbl001EC6053075_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.073018 0.019255 0.029127 0.024339333333333334 0.004035682869381862 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3601587175215472099 LOCK TABLE public."tbl001EC6056D48_54" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.236591 0.01957 0.03719 0.023659100000000002 0.005077494095516015 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7453151964631106797 SELECT * FROM "tbl001EC6050B87_1" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 26 37.933035999999994 0.031955000000000004 4.794727 1.4589629230769234 1.3914246909878412 2251 5237 37 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1617110968052774674 LOCK TABLE public."tbl001EC6050F3C_12" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.023429 0.023429 0.023429 0.023429 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8342479833428760337 CREATE TABLE IF NOT EXISTS "tbl001EC6050D16_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, "Inverter_AC_Output_Current_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 9.870847 9.870847 9.870847 9.870847 0 0 546 7 43 1 0 0 0 0 0 0 0 0 136 40 222437
16385 16384 t -1633161704922211557 LOCK TABLE public."tbl001EC6050B87_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.29870499999999994 0.018044 0.083384 0.033189444444444445 0.021645928963464654 0 54 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 -6784625302332255417 SELECT * FROM "tbl001EC6050D16_6" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1904 51.08811600000005 0.005685 1.827882 0.02683199369747902 0.06106770557935555 1903 5701 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2291573137218632241 INSERT INTO "tbl001EC6050F3C_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,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 64 2.948499 0.028104999999999998 0.154604 0.046070296875000014 0.01890023092425037 64 257 0 127 2 0 0 0 0 0 0 0 0 193 124 180218
16385 16384 t 8984627187413937915 CREATE TABLE IF NOT EXISTS "tbl001EC6050B5D_52" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.635082 5.635082 5.635082 5.635082 0 0 619 2 3 0 0 0 0 0 0 0 0 0 153 3 21497
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 7113388357766537142 SELECT * FROM "tbl001EC6054E88_103" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 8 10.438589 1.074577 1.555426 1.3048236249999998 0.14308871206697044 800 302 0 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1255670938912394547 INSERT INTO "tbl001EC6050BAC_4" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 9541 511.1027499999999 0.016988 47.941625 0.053569096530761855 0.5274631091565011 9541 57917 93 5088 164 0 0 0 0 0 0 0 0 28649 4854 22506695
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 70 54.742389 0.050272000000000004 28.018425 0.7820341285714287 3.374029296369584 170 1609 11 0 0 0 0 0 0 0 0 0 0 0 0 0
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 5792809329006332841 CREATE TABLE IF NOT EXISTS "tbl001EC6050F3C_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 6.959186 6.959186 6.959186 6.959186 0 0 1165 1 11 0 0 0 0 0 0 0 0 0 283 10 95299
16385 16384 t -6187468710693426447 COPY public."tbl001EC6050D05_80" ("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 19196.658582 1744.901709 2028.725692 1919.6658582 97.31722817402546 2038740 819 119494 40 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 7 0.933588 0.08710999999999999 0.1721 0.13336971428571429 0.030922524997226253 700 27 0 9 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 481298996052972004 CREATE TABLE IF NOT EXISTS "tbl001EC6054E88_11" ( 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.842287 6.842287 6.842287 6.842287 0 0 538 3 39 1 0 0 0 0 0 0 0 0 134 37 178958
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 1 0.10576 0.10576 0.10576 0.10576 0 7 1 0 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 10 0.10103100000000001 0.008629 0.010886 0.010103099999999999 0.000635920663290634 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3932625489571173380 SELECT * FROM "tbl001EC6056D41_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 5900 251.57995100000014 0.024640000000000002 2.404367 0.04264066966101697 0.0471047681827509 5900 17695 5 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7199423720549916887 SELECT * FROM "tbl001EC6057D26_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 5904 193.4995629999997 0.013032 5.627379 0.03277431622628721 0.10490182984215855 5904 17688 24 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2537766559447284344 SELECT * FROM "tbl001EC6050E0D_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2060 69.389312 0.011999 4.310842 0.03368413203883497 0.15809318946670772 2060 6098 25 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3516343656168737491 SELECT * FROM "tbl001EC6050F3A_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1986 123.06226699999979 0.020874 13.200964 0.061964887713997926 0.3269713225061613 1986 5925 33 0 0 0 0 0 0 0 0 0 0 0 0 0
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 7 25.794202 0.092576 7.02583 3.6848859999999997 2.453846728297022 6195 65 74 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 1941 486.31828099999996 0.107936 3.321267 0.2505503766099948 0.18113668617955075 2161 105675 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3033217080036596150 SELECT checkpoints_timed ,checkpoints_req ,checkpoint_write_time ,checkpoint_sync_time ,buffers_checkpoint ,buffers_clean ,maxwritten_clean ,buffers_backend ,buffers_backend_fsync ,buffers_alloc ,stats_reset FROM pg_stat_bgwriter 0 0 0 0 0 0 176162 352934.3033210033 0.063323 113.89989 2.0034644436427533 3.9895645450604085 176162 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7893755655820554076 INSERT INTO "tbl001EC6056D47_50" 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 14979 807.0022730000047 0.019312 2.837146 0.05387557734161141 0.06662925656940898 14979 94505 26 10370 1415 0 0 0 0 0 0 0 0 44978 7914 44588465
16385 16384 t 8478288726083966775 INSERT INTO "tbl001EC6056FD2_63" 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 14980 669.256474000002 0.015384 43.674 0.04467666715620826 0.36347427962540674 14980 92632 39 8536 305 0 0 0 0 0 0 0 0 44980 7885 38059377
16385 16384 t -2025804078418546187 INSERT INTO "tbl001EC6050F3C_13" 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 64 3.288601 0.027922000000000002 0.20318499999999998 0.05138439062499999 0.028450079379072686 64 257 0 127 2 0 0 0 0 0 0 0 0 193 124 180218
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 836 64.25339000000005 0.020784 1.432421 0.07685812200956936 0.12076165036704606 836 4787 17 1651 69 0 0 0 0 0 0 0 0 2511 1527 6776291
16385 16384 t 2616290081087488607 CREATE TABLE IF NOT EXISTS "tbl001EC6053CD9_1" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "DC_Voltage_V_1" DOUBLE PRECISION DEFAULT NULL, "Apparent_AC_Power_VA_2" DOUBLE PRECISION DEFAULT NULL, "AC_Grid_Frequency_Hz_3" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Stage_Current_A_4" DOUBLE PRECISION DEFAULT NULL, "L1_to_L2_AC_Voltage_V_5" DOUBLE PRECISION DEFAULT NULL, "L2_to_L3_AC_Voltage_V_6" DOUBLE PRECISION DEFAULT NULL, "L1_to_L3_AC_Voltage_V_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Sequence_8" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_kWh_9" DOUBLE PRECISION DEFAULT NULL, "On_Grid_Hours_Hrs_10" DOUBLE PRECISION DEFAULT NULL, "Fan_On_Time_Hours_Hrs_11" DOUBLE PRECISION DEFAULT NULL, "AC_Contactors_Cycles_12" DOUBLE PRECISION DEFAULT NULL, "Network_ID_13" DOUBLE PRECISION DEFAULT NULL, "Informative_Alarms_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 13.007349 13.007349 13.007349 13.007349 0 0 746 7 47 3 0 0 0 0 0 0 0 0 134 36 191209
16385 16384 t 5902745250407049822 SELECT * FROM "tbl001EC6050F3C_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 128 5.045828 0.009126 1.3767230000000001 0.03942053124999999 0.1195862712775892 127 253 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8312020551412358667 LOCK TABLE public."tbl001EC60530AB_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.325594 0.017443 0.083723 0.032559399999999995 0.019356289908967577 0 60 0 0 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 8 45.66360100000001 0.9132800000000001 10.988522 5.707950125 2.8641193402943874 800 21 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9112670610233865688 SELECT * FROM "tbl001EC6056FD2_61" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29104 747.3731050000057 0.012331 42.584097 0.025679394756734388 0.2518648046228407 29104 87304 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4873227742558593212 SELECT ts.oid AS oid, spcname AS name, spcowner as owner, pg_catalog.shobj_description(oid, $1) AS description FROM pg_catalog.pg_tablespace ts ORDER BY name 0 0 0 0 0 0 1 0.193679 0.193679 0.193679 0.193679 0 2 7 0 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 10 0.4613609999999999 0.009767 0.35039499999999996 0.04613609999999999 0.1014398994315846 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2232762270083112028 COPY public."tbl001EC6054E88_56" ("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 3 157.35754400000002 28.926646 98.241809 52.45251466666667 32.382022247336934 52749 119 228 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -815283359596941728 COPY public."tbl001EC6050D06_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 6 16.616783 0.092844 4.585527 2.7694638333333335 1.7565032651245311 4452 70 41 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -483581019345127367 SELECT * FROM "tbl001EC6050B5D_3" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1652 40.154455 0.005894 1.904877 0.024306570823244507 0.08028725251635609 1651 4147 11 0 0 0 0 0 0 0 0 0 0 0 0 0
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 6 1165.5519669999999 171.661503 211.022691 194.25866116666666 11.66554681814518 400861 1170 5087 194 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3598250727493113391 LOCK TABLE public."tbl001EC6053CD9_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 6 0.149119 0.020972 0.034327 0.024853166666666666 0.004929727829426512 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5513616972614427486 SELECT * FROM "tbl001EC6056FD2_66" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29104 709.9093470000041 0.01243 8.562319 0.02439215733232554 0.057314298620275754 29104 87307 5 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6972144593211720306 SELECT * FROM "tbl001EC6050D16_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 5 0.8477 0.084691 0.26566300000000004 0.16954000000000002 0.06100335089812692 500 21 0 7 0 0 0 0 0 0 0 0 0 0 0 0
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 -8385048929229287603 SET DATESTYLE = ISO 0 0 0 0 0 0 10 0.11157400000000002 0.007712 0.020898 0.011157400000000001 0.0035349681809034718 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7949981054851130074 INSERT INTO "tbl001EC60537E0_3" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 1921 109.63535599999985 0.020604 1.8015489999999998 0.05707202290473713 0.10250525011256616 1921 11584 37 3347 39 0 0 0 0 0 0 0 0 5769 3781 16313324
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 9540 540.8834480000003 0.016606 80.97954899999999 0.05669637819706496 0.8722265274923263 9540 57998 101 5272 160 0 0 0 0 0 0 0 0 28646 5065 23275849
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 2840 146.84067500000015 0.017978 1.937707 0.051704463028169015 0.07787552266053467 2840 17176 24 3740 92 0 0 0 0 0 0 0 0 8528 3609 15693027
16385 16384 t 6305699317791867522 COPY public."tbl001EC6050F3C_33" ("time", error, lowrange, highrange, "Vln_a_Volts_1", "Vln_b_Volts_2", "Vln_c_Volts_3", "Vln_ave_Volts_4", "Vll_ab_Volts_5", "Vll_bc_Volts_6", "Vll_ca_Volts_7", "Vll_ave_Volts_8", "I_a_Amps_9", "I_b_Amps_10", "I_c_Amps_11", "I_ave_Amps_12", "V_unbal_13", "I_unbal_14", "Freq_Hz_15", "I4_Amps_16", "kW_a_kW_17", "kW_b_kW_18", "kW_c_kW_19", "kW_tot_kW_20", "kVAR_a_kVAR_21", "kVAR_b_kVAR_22", "kVAR_c_kVAR_23", "kVAR_tot_kVAR_24", "kVA_a_kVA_25", "kVA_b_kVA_26", "kVA_c_kVA_27", "kVA_tot_kVA_28", "PF_sign_a_29", "PF_sign_b_30", "PF_sign_c_31", "PF_sign_tot_32", "Vll_ave_mx_Volts_33", "I_ave_mx_Amps_34", "kW_tot_mx_kW_35", "kVAR_tot_mx_kVAR_36", "kVA_tot_mx_kVA_37", "Freq_mx_Hz_38", "Vll_ave_mn_Volts_39", "I_ave_mn_Amps_40", "Freq_mn_Hz_41", "kW_sd_del_rec_kW_42", "kVA_sd_del_rec_kVA_43", "kVAR_sd_del_rec_kVAR_44", "kW_sd_mx_d_r_kW_45", "kVA_sd_mx_d_r_kVA_46", "kVAR_sd_mx_d_r_kVAR_47", "Phase_Rev_48", "kWh_del_kWh_49", "kWh_rec_kWh_50", "kWh_del_rec_kWh_51", "kWh_del_rec_kWh_52", "kVARh_del_kVARh_53", "kVARh_rec_kVARh_54", "kVARh_del_rec_kVARh_55", "kVARh_del_rec_kVARh_56", "kVAh_del_rec_kVAh_57", "V1_THD_mx_58", "V2_THD_mx_59", "V3_THD_mx_60", "I1_THD_mx_61", "I2_THD_mx_62", "I3_THD_mx_63", unused_64) TO stdout 0 0 0 0 0 0 1 0.117183 0.117183 0.117183 0.117183 0 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0