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 tbl001EC6050D17_1 tbl001EC6050D17_2 tbl001EC6050D17_3 tbl001EC6050D17_4 tbl001EC6050D17_5 tbl001EC6050D17_51 tbl001EC6050D17_6 tbl001EC6050D21_103 tbl001EC6050D21_51 tbl001EC6050D21_52 tbl001EC6050D21_80 tbl001EC6050D21_81 tbl001EC6050D30_3 tbl001EC6050D30_51 tbl001EC6050D30_80 tbl001EC6050E0D_1 tbl001EC6050E0D_2 tbl001EC6050E0D_51 tbl001EC6050E4D_2 tbl001EC6050E4D_52 tbl001EC6050E4D_80 tbl001EC6050E4D_81 tbl001EC6050EFC_211 tbl001EC6050EFC_213 tbl001EC6050F3A_1 tbl001EC6050F3A_2 tbl001EC6050F3A_3 tbl001EC6050F3A_4 tbl001EC6050F3A_51 tbl001EC6050F3C_1 tbl001EC6050F3C_10 tbl001EC6050F3C_11 tbl001EC6050F3C_12 tbl001EC6050F3C_13 tbl001EC6050F3C_14 tbl001EC6050F3C_15 tbl001EC6050F3C_16 tbl001EC6050F3C_17 tbl001EC6050F3C_18 tbl001EC6050F3C_19 tbl001EC6050F3C_2 tbl001EC6050F3C_3 tbl001EC6050F3C_33 tbl001EC6050F3C_4 tbl001EC6050F3C_5 tbl001EC6050F3C_54 tbl001EC6050F3C_6 tbl001EC6050F3C_7 tbl001EC6050F3C_8 tbl001EC6050F3C_9 tbl001EC6050F42_1 tbl001EC6050F42_2 tbl001EC6050F42_51 tbl001EC6052F1E_51 tbl001EC6052F1E_9 tbl001EC6053019_53 tbl001EC6053075_5 tbl001EC6053075_51 tbl001EC6053075_52 tbl001EC6053075_53 tbl001EC6053075_54 tbl001EC6053075_6 tbl001EC6053075_60 tbl001EC6053075_7 tbl001EC6053093_51 tbl001EC6053093_52 tbl001EC6053093_53 tbl001EC6053093_54 tbl001EC6053093_55 tbl001EC6053093_9 tbl001EC605309C_51 tbl001EC605309C_52 tbl001EC605309C_53 tbl001EC605309C_54 tbl001EC605309C_55 tbl001EC605309C_9 tbl001EC60530AB_51 tbl001EC60530AB_9 tbl001EC6053109_1 tbl001EC6053109_11 tbl001EC6053109_2 tbl001EC6053109_3 tbl001EC6053109_4 tbl001EC6053109_5 tbl001EC6053109_7 tbl001EC6053113_10 tbl001EC6053113_51 tbl001EC6053113_52 tbl001EC6053113_53 tbl001EC6053113_9 tbl001EC605311A_1 tbl001EC605311A_2 tbl001EC605311A_3 tbl001EC60537AE_1 tbl001EC60537AE_2 tbl001EC60537AE_21 tbl001EC60537AE_41 tbl001EC60537E0_1 tbl001EC60537E0_2 tbl001EC60537E0_21 tbl001EC60537E0_3 tbl001EC60537E0_41 tbl001EC6053CD9_1 tbl001EC6053CD9_10 tbl001EC6053CD9_2 tbl001EC6053CD9_4 tbl001EC6053CD9_5 tbl001EC6054E7A_1 tbl001EC6054E88_103 tbl001EC6054E88_11 tbl001EC6054E88_56 tbl001EC6056300_10 tbl001EC6056300_15 tbl001EC6056300_50 tbl001EC6056300_51 tbl001EC6056300_52 tbl001EC6056300_53 tbl001EC6056300_55 tbl001EC6056D41_51 tbl001EC6056D41_52 tbl001EC6056D41_53 tbl001EC6056D41_54 tbl001EC6056D41_55 tbl001EC6056D41_9 tbl001EC6056D47_10 tbl001EC6056D47_50 tbl001EC6056D47_51 tbl001EC6056D47_52 tbl001EC6056D47_9 tbl001EC6056D48_51 tbl001EC6056D48_52 tbl001EC6056D48_53 tbl001EC6056D48_54 tbl001EC6056D48_55 tbl001EC6056D48_9 tbl001EC6056D49_10 tbl001EC6056D49_51 tbl001EC6056D49_52 tbl001EC6056D49_53 tbl001EC6056D49_9 tbl001EC6056FD2_10 tbl001EC6056FD2_23 tbl001EC6056FD2_26 tbl001EC6056FD2_27 tbl001EC6056FD2_28 tbl001EC6056FD2_51 tbl001EC6056FD2_52 tbl001EC6056FD2_54 tbl001EC6056FD2_55 tbl001EC6056FD2_59 tbl001EC6056FD2_60 tbl001EC6056FD2_61 tbl001EC6056FD2_62 tbl001EC6056FD2_63 tbl001EC6056FD2_64 tbl001EC6056FD2_65 tbl001EC6056FD2_66 tbl001EC6056FD2_67 tbl001EC6056FD2_68 tbl001EC6056FD2_69 tbl001EC6056FD2_9 tbl001EC6057D26_4 tblacquisuite tbldevicelist

pg_stat_statements

userid
oid 		dbid
oid 		toplevel
boolean 		queryid
bigint 		query
text 		plans
bigint 		total_plan_time
double precision 		min_plan_time
double precision 		max_plan_time
double precision 		mean_plan_time
double precision 		stddev_plan_time
double precision 		calls
bigint 		total_exec_time
double precision 		min_exec_time
double precision 		max_exec_time
double precision 		mean_exec_time
double precision 		stddev_exec_time
double precision 		rows
bigint 		shared_blks_hit
bigint 		shared_blks_read
bigint 		shared_blks_dirtied
bigint 		shared_blks_written
bigint 		local_blks_hit
bigint 		local_blks_read
bigint 		local_blks_dirtied
bigint 		local_blks_written
bigint 		temp_blks_read
bigint 		temp_blks_written
bigint 		blk_read_time
double precision 		blk_write_time
double precision 		wal_records
bigint 		wal_fpi
bigint 		wal_bytes
numeric
16385 13761 t 6478069098171292803 CREATE TABLE _9e8a015ca66520a82d22483a3852d4a0(cmd_output text) 0 0 0 0 0 0 1 8.573996 8.573996 8.573996 8.573996 0 0 507 5 6 0 0 0 0 0 0 0 0 0 94 7 45368
16385 16384 t 7957312638352241667 INSERT INTO "tbl001EC6050F3C_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 89 4.459505000000002 0.028517 0.138681 0.05010679775280898 0.019994139339732136 89 357 0 177 2 0 0 0 0 0 0 0 0 268 174 339693
16385 13761 t -3977996091253425266 DROP TABLE IF EXISTS _67fd6ee7e4f01dfcea8c7178633bfc2b 0 0 0 0 0 0 1 0.09171 0.09171 0.09171 0.09171 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8730223317367361116 LOCK TABLE public."tbl001EC6050D21_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 1.4423100000000002 0.018833 1.218759 0.144231 0.3582732738385603 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3575089490875377459 COPY public."tbl001EC6050B5D_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 9 7.951392 0.055589 2.08257 0.883488 0.5911080960580165 3553 42 6 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6593173474203016496 SELECT * FROM "tbl001EC6056FD2_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29836 850.6522710000025 0.013744 20.275148 0.028510935480627324 0.16612191577294985 29836 89497 11 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1672210563238850933 SELECT * FROM "tbl001EC6056FD2_67" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29836 706.2573769999993 0.011906 6.10777 0.02367131575948511 0.047443562954513435 29836 89503 5 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4028383316440567362 LOCK TABLE public."tbl001EC6050BAC_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.17771 0.016267 0.036833 0.025387142857142855 0.007259139134883134 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5399467118944703272 INSERT INTO "tbl001EC6056FD2_60" 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 15347 653.5674390000004 0.01522 25.288235999999998 0.04258600632045353 0.21206225549683766 15347 94902 41 8757 309 0 0 0 0 0 0 0 0 46083 8085 39633432
16385 16384 t -4604261229621010529 SELECT * FROM "tbl001EC6056D47_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29620 719.7740920000025 0.013597 4.368512 0.024300273193788014 0.036628864345249215 29620 88855 5 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8066460545993191483 LOCK TABLE public."tbl001EC6053113_52" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.37965999999999994 0.018782 0.163573 0.037966 0.04221917458691015 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3068351530887732432 SELECT * FROM "tbl001EC6050D06_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 13 12.403913 0.112493 3.37379 0.9541471538461537 1.144426877216435 1300 2682 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5836275249101037622 COPY public."tbl001EC6056FD2_28" ("time", error, lowrange, highrange, "Total_Active_Power_kW_1", "Total_Apparent_Power_kVA_2", "Reserved_3", "Power_Factor_4", "Grid_Voltage_Vab_Volts_5", "Grid_Voltage_Vbc_Volts_6", "Grid_Voltage_Vca_Volts_7", "Phase_A_Current_Amps_8", "Phase_B_Current_Amps_9", "Phase_C_Current_Amps_10", "PV_Voltage_Volts_11", "PV_Current_Amps_12", "Frequency_Hz_13", "Int_Ambient_Temperature_Degrees_C_14", "Mode_Status_15", "PFault_16", "Warn_Code_17", "Fault_0_18", "Fault_1_19", "Fault_2_20", "Fault_3_21", "Fault_4_22", "Total_Energy_kWh_23") TO stdout 0 0 0 0 0 0 10 881.011008 55.763745 139.253265 88.1011008 24.943106407485132 226930 12 4598 15 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8349147418542974015 INSERT INTO "tbl001EC605309C_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 15324 1055.1996759999945 0.018995 2.7820319999999996 0.06885928452101282 0.12811835504864433 15324 96301 370 10664 1466 0 0 0 0 0 0 0 0 46014 7942 44894106
16385 16384 t 4301024362496343160 SELECT * FROM "tbl001EC6053109_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 12 13.969307 0.481203 3.541298 1.1641089166666667 0.9423143764068743 1200 2396 9 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5630899492483453475 SELECT * FROM "tbl001EC6056FD2_63" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29836 728.8558289999945 0.012352 6.443417 0.0244287380681057 0.04657283575390056 29836 89502 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1492204788579590184 SELECT * FROM "tbl001EC6050F3C_12" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 178 6.735848999999994 0.01684 1.526249 0.037841848314606755 0.11295548751433275 177 353 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3644860500342624593 SELECT * FROM "tbl001EC6050F3C_16" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 13 0.76306 0.026658 0.132774 0.05869692307692307 0.03740437734659395 196 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5975422957942939735 INSERT INTO "tbl001EC6050E0D_51" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 1206 88.57178899999995 0.019646 1.888015 0.07344261111111107 0.1305251232497167 1206 7740 22 1966 62 0 0 0 0 0 0 0 0 3622 1904 9052826
16385 16384 t 7458276971063297450 CREATE TABLE IF NOT EXISTS "tbl001EC6053CD9_4" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Energy_Consumption_kWh_1" DOUBLE PRECISION DEFAULT NULL, "Real_Power_kW_2" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.071909 5.071909 5.071909 5.071909 0 0 415 0 0 0 0 0 0 0 0 0 0 0 105 1 11064
16385 13761 t -9077035474010248569 CREATE TABLE _c6e7f4721c84c25caed25a9991d5b1f6(cmd_output text) 0 0 0 0 0 0 1 9.158421 9.158421 9.158421 9.158421 0 0 504 5 26 0 0 0 0 0 0 0 0 0 93 26 132188
16385 16384 t 3824925472024145189 SELECT c.oid, pg_catalog.quote_ident(n.nspname)||$1||pg_catalog.quote_ident(c.relname) AS typname FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c WHERE c.relkind = $2 AND c.relnamespace=n.oid AND n.nspname NOT LIKE $3 AND n.nspname NOT IN ($4) ORDER BY typname 0 0 0 0 0 0 5 0.7657520000000001 0.139484 0.179965 0.1531504 0.015957343570908042 0 120 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1218897996192594693 COPY public."tbl001EC6053075_6" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 3 1.488049 0.055106 1.006538 0.49601633333333334 0.39152693900703966 972 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4787585535549757886 INSERT INTO "tbl001EC6050C0B_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 578 38.87213899999995 0.023291000000000003 1.4467160000000001 0.06725283564013836 0.1219077856848232 578 2963 13 1158 13 0 0 0 0 0 0 0 0 1736 1135 4613699
16385 16384 t -8926672444418875897 INSERT INTO "tbl001EC6056FD2_65" 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 15347 625.2348490000007 0.01544 2.591015 0.040739874177363786 0.059559282739620585 15347 94925 43 8676 331 0 0 0 0 0 0 0 0 46083 8001 38614206
16385 16384 t -5408452906563792533 SELECT * FROM "tbl001EC6050D16_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 14 3.3811620000000002 0.107125 0.67227 0.24151157142857144 0.1500366429960715 1400 158 0 28 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1651816178518753656 LOCK TABLE public."tbl001EC6050F3C_6" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.029741 0.029741 0.029741 0.029741 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4739898032672563985 LOCK TABLE public."tbl001EC6057D26_4" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.27719999999999995 0.022111 0.043754 0.02772 0.006457600467665988 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3474337163174861217 LOCK TABLE public."tbl001EC6050BAC_5" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.19563 0.022795 0.032848 0.027947142857142858 0.0031819708819971243 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1230820202499507732 SELECT * FROM ( SELECT pg_catalog.pg_get_indexdef($1 , $2 , $3) AS column, $4 AS dummy ) tmp ORDER BY dummy 0 0 0 0 0 0 10 0.622851 0.046077 0.099831 0.06228510000000001 0.018140616281978956 10 45 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -974893283350868508 COPY public."tbl001EC60506E1_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 3442.190364 297.477653 496.420077 344.2190364 52.71395992691641 2069352 187 14066 107 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6771744580522783120 INSERT INTO "tbl001EC6050E0D_2" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 1206 90.58087699999994 0.020267 2.4543820000000003 0.0751085215588723 0.14185139169202501 1206 7817 23 2042 99 0 0 0 0 0 0 0 0 3622 1874 9125592
16385 16384 t -6724676754341366644 COPY _timescaledb_catalog.continuous_agg_migrate_plan_step (mat_hypertable_id, step_id, status, start_ts, end_ts, type, config) TO stdout 0 0 0 0 0 0 10 0.276787 0.024148 0.043321 0.027678699999999997 0.005337858316778369 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2489287232919334899 SELECT CASE WHEN NOT pg_is_in_recovery() THEN $1 WHEN pg_last_wal_receive_lsn () = pg_last_wal_replay_lsn () THEN $2 ELSE GREATEST ($3, EXTRACT($4 FROM (now() - pg_last_xact_replay_timestamp()))) END AS lag, CASE WHEN pg_is_in_recovery() THEN $5 ELSE $6 END as is_replica, GREATEST ($7, EXTRACT($8 FROM (now() - pg_last_xact_replay_timestamp()))) as last_replay 0 0 0 0 0 0 120945 890.1919759999967 0.004296 1.381116 0.007360304072098939 0.007696298814503174 120945 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4632650237704791109 INSERT INTO "tbl001EC6050D16_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 71435 1841.114420000005 0.013809 54.127476 0.025773282284594523 0.21583622099345537 71435 429542 14 2040 662 0 0 0 0 0 0 0 0 214503 1367 19496118
16385 16384 t 6158190961478083244 COPY public."tbl001EC6050BAC_9" ("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 77.96722 0.11047 24.324114 11.138174285714287 7.84179264922783 30534 433 31 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 6942642885216868755 DROP TABLE IF EXISTS _705ee56e71c6b033df44deb6aedf36f5 0 0 0 0 0 0 1 0.104374 0.104374 0.104374 0.104374 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5751337930305561224 COPY public."tbl001EC6053109_11" ("time", error, lowrange, highrange, "AC_Current_Amps_1", "Phase_A_Current_Amps_2", "Phase_B_Current_Amps_3", "Phase_C_Current_Amps_4", "Phase_Voltage_AB_Volts_5", "Phase_Voltage_BC_Volts_6", "Phase_Voltage_CA_Volts_7", "Phase_Voltage_AN_Volts_8", "Phase_Voltage_BN_Volts_9", "Phase_Voltage_CN_Volts_10", "AC_Power_W_11", "Line_Frequency_Hz_12", "AC_Apparent_Power_VA_13", "AC_Reactive_Power_VAR_14", "AC_Power_Factor_15", "AC_Energy_Wh_16", "DC_Amps_Amps_17", "DC_Voltage_Volts_18", "DC_Power_W_19", "Cabinet_Temperature_Degrees_20", "Heat_Sink_Temperature_Degrees_21", "Transformer_Temperature_Degrees_22", "Other_Temperature_Degrees_23", "Operating_State_24", "Vendor_Specific_Operating_State_25", "Event_Field_26", "Reserved_for_Future_27", "Vendor_Event_1_28", "Vendor_Event_2_29", "Vendor_Event_3_30", "Vendor_Event_4_31") TO stdout 0 0 0 0 0 0 3 24.756101 1.986021 15.822921 8.252033666666666 5.723750159017619 3167 92 42 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2990859851812155850 LOCK TABLE public."tbl001EC6056FD2_28" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.33937300000000004 0.019423 0.050818 0.0339373 0.011070198932720226 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8909153850515211849 SELECT * FROM "tbl001EC6054E88_56" ORDER BY "Status_register_9" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 3.116139 1.43775 1.678389 1.5580695 0.12031949999999991 200 218 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3598208618791332532 LOCK TABLE public."tbl001EC6053113_10" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.24710700000000005 0.018662 0.043998 0.0247107 0.00960244423102785 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1083149659439619935 INSERT INTO "tbl001EC6056FD2_67" 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 15347 617.9717429999976 0.014270999999999999 7.0872280000000005 0.04026661516908844 0.0808328309354704 15347 94457 28 8229 293 0 0 0 0 0 0 0 0 46082 7716 36177001
16385 16384 t 6507690469656159176 COPY public."tbl001EC6052F1E_51" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 10 4081.856078999999 316.419342 491.152555 408.18560790000004 57.66919800199943 324620 1681 28500 42 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8752358124540790813 CREATE TABLE IF NOT EXISTS "tbl001EC6050BAC_51" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Analog_In_1_1" DOUBLE PRECISION DEFAULT NULL, "Analog_In_2_2" DOUBLE PRECISION DEFAULT NULL, "Analog_In_3_3" DOUBLE PRECISION DEFAULT NULL, "Analog_In_4_4" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_5" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_6" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_7" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_8" DOUBLE PRECISION DEFAULT NULL, "Status_register_9" DOUBLE PRECISION DEFAULT NULL, "firmware_version_10" DOUBLE PRECISION DEFAULT NULL, "Uptime_Seconds_11" DOUBLE PRECISION DEFAULT NULL, "Pulse_State_Register_12" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_ontime_Sec_sec_13" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_ontime_Sec_sec_14" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_ontime_Sec_sec_15" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_ontime_Sec_sec_16" DOUBLE PRECISION DEFAULT NULL, "Pulse_1_last_minute_change_17" DOUBLE PRECISION DEFAULT NULL, "Pulse_2_last_minute_change_18" DOUBLE PRECISION DEFAULT NULL, "Pulse_3_last_minute_change_19" DOUBLE PRECISION DEFAULT NULL, "Pulse_4_last_minute_change_20" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 6.829433 6.829433 6.829433 6.829433 0 0 560 0 1 0 0 0 0 0 0 0 0 0 141 2 21753
16385 16384 t -4501244327729364772 SELECT * FROM "tbl001EC60530AB_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29896 1260.5735530000043 0.022467 4.524184 0.042165291443671614 0.0592333597279332 29896 89666 22 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4352641485192939419 INSERT INTO "tbl001EC6053109_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 2279 108.36904600000005 0.022203 1.3806129999999999 0.047551139096094715 0.08055436748289367 2279 13408 25 1385 91 0 0 0 0 0 0 0 0 6844 1224 5887829
16385 16384 t -3093825897256944181 INSERT INTO "tbl001EC6050BAC_2" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 9907 563.5078499999972 0.017362000000000002 42.387725 0.056879766831533334 0.5248717929559991 9907 60273 121 5484 196 0 0 0 0 0 0 0 0 29748 5198 24131869
16385 16384 t 8314409832516769700 SELECT last_value, is_called FROM _timescaledb_catalog.chunk_column_stats_id_seq 0 0 0 0 0 0 10 5.919592 0.025218 0.8149150000000001 0.5919591999999999 0.2799569859506278 10 2 8 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5314026230736827777 COPY public.tblacquisuite (serialnumber, password, name, lastuploadtime, config, configchangetime, configchecksum, firmwareversion) TO stdout 0 0 0 0 0 0 10 17.174924999999998 0.651678 2.850208 1.7174924999999999 0.83929801197325 340 99 11 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8343824401963373533 SELECT * FROM "tbl001EC6050BAC_7" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 19716 472.04745000000173 0.0068650000000000004 4.001641 0.023942353925745542 0.0530820756409458 19715 58338 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2043111732807877231 LOCK TABLE public."tbl001EC6056D49_10" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.663004 0.018956 0.292391 0.0663004 0.08336396643298591 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3444950728097187806 SELECT * FROM "tbl001EC6056D47_10" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 0.615691 0.30733900000000003 0.308352 0.3078455 0.0005064999999999792 200 118 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4020020139527944423 CREATE TABLE IF NOT EXISTS "tbl001EC6053075_54" ( 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.787519 6.787519 6.787519 6.787519 0 0 1187 3 5 0 0 0 0 0 0 0 0 0 281 4 46363
16385 16384 t -536754448580747824 SELECT count(*) FROM pg_subscription WHERE subdbid = (SELECT oid FROM pg_database WHERE datname = current_database()) 0 0 0 0 0 0 10 0.12901200000000002 0.01218 0.014141 0.0129012 0.000523070320320318 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1335200127537508249 LOCK TABLE public."tbl001EC6050B08_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.341643 0.024043 0.060526 0.034164299999999995 0.010927566609726064 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7745140569988450976 SELECT * FROM "tbl001EC605309C_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 28558 1304.4099409999988 0.019788 3.305255 0.04567581556831725 0.04218968270277136 28558 85654 20 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6387903737129628128 SELECT * FROM "tbl001EC6050F3C_11" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 13 0.8675809999999999 0.025754000000000003 0.199621 0.06673699999999999 0.05612454303805751 235 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 8494808215712411766 DROP TABLE IF EXISTS _947ea7f3e113939d4dc4c9e7d75ddda0 0 0 0 0 0 0 1 0.820623 0.820623 0.820623 0.820623 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7519305314389565808 SELECT tableoid, oid, cfgname, cfgnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = cfgowner) AS rolname, cfgparser FROM pg_ts_config 0 0 0 0 0 0 10 8.769246 0.731468 1.536481 0.8769245999999999 0.2332012991847172 290 290 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5873383763650105594 UPDATE tbldevicelist SET datatablename = $1 WHERE serialnumber = $2 AND deviceid = $3 0 0 0 0 0 0 120 10.057684000000005 0.02478 1.44071 0.08381403333333333 0.18455989305272216 120 675 2 69 8 0 0 0 0 0 0 0 0 244 72 523124
16385 16384 t 5817001384299587280 INSERT INTO "tbl001EC6056FD2_64" 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 15347 637.7942099999984 0.014959 2.8830240000000003 0.041558233530983354 0.06728993809749388 15347 94942 45 8752 320 0 0 0 0 0 0 0 0 46082 8078 39563813
16385 16384 t 942242226624359821 SELECT last_value, is_called FROM public.dl_inverter_device_data_id_seq 0 0 0 0 0 0 10 6.572925000000001 0.580529 0.70828 0.6572925 0.0433147870068641 10 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3252773050344261936 COPY public."tbl001EC6053075_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 3 4.654203000000001 0.1848 2.835561 1.551401 1.0837376246555255 972 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8243953065610935304 LOCK TABLE public."tbl001EC60506E1_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.29880099999999993 0.022313 0.047189 0.029880099999999996 0.009193618335019136 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1048896070651092744 SELECT * FROM "tbl001EC6050189_3" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 26 6.893301999999999 0.032328 1.712533 0.26512700000000006 0.359590027307702 1967 176 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 485657403143976307 CREATE TABLE IF NOT EXISTS "tbl001EC6050D06_4" ( 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.526672 5.526672 5.526672 5.526672 0 0 986 2 4 0 0 0 0 0 0 0 0 0 243 4 37677
16385 16384 t -266156796919573660 SELECT * FROM "tbl001EC6056D49_51" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 2.501753 1.0632949999999999 1.438458 1.2508765 0.18758150000000007 200 122 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8922658275746524969 COPY public."tbl001EC6050B5D_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 9 10.596854 0.06849 2.872744 1.1774282222222223 0.7978476932720343 3554 59 8 3 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 2956243589281450507 CREATE TABLE _e4729764321e501e1fbf403016de8e13(cmd_output text) 0 0 0 0 0 0 1 13.788427 13.788427 13.788427 13.788427 0 0 505 5 27 0 0 0 0 0 0 0 0 0 92 26 116494
16385 16384 t -645363146862184782 SELECT * FROM "tbl001EC6053075_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 15 2.7188250000000003 0.016231000000000002 0.9768629999999999 0.18125500000000003 0.22223612668810921 1051 153 1 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7500282981781946401 LOCK TABLE public."tbl001EC6050B87_103" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.297555 0.024105 0.052242 0.03306166666666667 0.008238302778283075 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5659881057560058090 COPY public."tbl001EC6054E7A_1" ("time", error, lowrange, highrange, "Active_Power_Total_kWh_1", "Reactive_Power_Total_kVAR_2", "Apparent_Power_Total_kVA_3", "Voltage_Average_Volts_4", "Voltage_L_L_Average_Volts_5", "Current_Average_Amps_6", "System_Power_Factor_7", "System_Frequency_Hz_8", "Voltage_Average_Angle_Degrees_9", "System_Quadrant_10", "Voltage_A_Volts_11", "Voltage_B_Volts_12", "Voltage_C_Volts_13", "Voltage_A_B_Volts_14", "Voltage_B_C_Volts_15", "Voltage_A_C_Volts_16", "Current_A_Amps_17", "Current_B_Amps_18", "Current_C_Amps_19", "Active_Power_A_kW_20", "Active_Power_B_kW_21", "Active_Power_C_kW_22", "Reactive_Power_A_kVAR_23", "Reactive_Power_B_kVAR_24", "Reactive_Power_C_kVAR_25", "Apparent_Power_A_kVA_26", "Apparent_Power_B_kVA_27", "Apparent_Power_C_kVA_28", "Power_Factor_A_29", "Power_Factor_B_30", "Power_Factor_C_31", "Voltage_Angle_AB_Degrees_32", "Voltage_Angle_BC_Degrees_33", "Voltage_Angle_CA_Degrees_34", "Quadrant_A_35", "Quadrant_B_36", "Quadrant_C_37", "Sliding_Window_Power_kW_38", "Net_Total_Energy_Revenue_kWh_39", "Total_Net_Apparent_Energy_Revenue_kVA_40", "Total_Import_Energy_Revenue_kWh_41", "Total_Export_Energy_Revenue_kWh_42", "Total_Import_Apparent_Energy_Revenue_kVA_43", "Total_Export_Apparent_Energy_Revenue_kVA_44", "Q1_Total_Reactive_Energy_Revenue_kVAR_45", "Q2_Total_Reactive_Energy_Revenue_kVAR_46", "Q3_Total_Reactive_Energy_Revenue_kVAR_47", "Q4_Total_Reactive_Energy_Revenue_kVAR_48", "Q1_Q2_Total_Inductive_Reactive_Energy_Revenue_kVAR_49", "Q3_Q4_Total_Capacitive_Reactive_Energy_Revenue_kVAR_50", "Net_Energy_Revenue_A_kWh_51", "Net_Energy_Revenue_B_kWh_52", "Net_Energy_Revenue_C_kWh_53", "Net_Apparent_Energy_Revenue_A_kVA_54", "Net_Apparent_Energy_Revenue_B_kVA_55", "Net_Apparent_Energy_Revenue_B_kVA_56", "Import_Energy_Revenue_A_kWh_57", "Import_Energy_Revenue_B_kWh_58", "Import_Energy_Revenue_C_kWh_59", "Export_Energy_Revenue_A_kWh_60", "Export_Energy_Revenue_B_kWh_61", "Export_Energy_Revenue_C_kWh_62", "Import_Apparent_Energy_Revenue_A_kVA_63", "Import_Apparent_Energy_Revenue_B_kVA_64", "Import_Apparent_Energy_Revenue_C_kVA_65", "Export_Apparent_Energy_Revenue_A_kVA_66", "Export_Apparent_Energy_Revenue_B_kVA_67", "Export_Apparent_Energy_Revenue_C_kVA_68", "Q1_Reactive_Energy_Revenue_A_kVAR_69", "Q1_Reactive_Energy_Revenue_B_kVAR_70", "Q1_Reactive_Energy_Revenue_C_kVAR_71", "Q2_Reactive_Energy_Revenue_A_kVAR_72", "Q2_Reactive_Energy_Revenue_B_kVAR_73", "Q2_Reactive_Energy_Revenue_C_kVAR_74", "Q3_Reactive_Energy_Revenue_A_kVAR_75", "Q3_Reactive_Energy_Revenue_B_kVAR_76", "Q3_Reactive_Energy_Revenue_C_kVAR_77", "Q4_Reactive_Energy_Revenue_A_kVAR_78", "Q4_Reactive_Energy_Revenue_B_kVAR_79", "Q4_Reactive_Energy_Revenue_C_kVAR_80") TO stdout 0 0 0 0 0 0 8 99.712205 0.354688 33.102379 12.464025624999998 11.178142056767047 2856 71 235 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8706656602541742245 LOCK TABLE public."tbl001EC6050F3C_10" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.032769 0.032769 0.032769 0.032769 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3508913784316536178 INSERT INTO "tbl001EC6050D30_80" 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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 8981 347.00389899999885 0.015809999999999998 2.411548 0.0386375569535686 0.06761277203340686 8981 54676 22 2436 509 0 0 0 0 0 0 0 0 26969 1877 13073076
16385 16384 t -9059909843455977522 SELECT * FROM "tbl001EC6050F3C_10" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 178 6.582698000000001 0.011482 1.2383380000000002 0.036981449438202245 0.09166167644555298 177 353 2 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8390782412840030323 SELECT name, setting::numeric AS setting FROM pg_catalog.pg_show_all_settings() WHERE name IN($1,$2,$3,$4,$5,$6,$7) ORDER BY name 0 0 0 0 0 0 1 1.095702 1.095702 1.095702 1.095702 0 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5053339295550175985 CREATE TABLE IF NOT EXISTS tbldevicelist ( serialnumber VARCHAR(64) NOT NULL, deviceid VARCHAR(32) NOT NULL, devicename VARCHAR(64), devicetype VARCHAR(64), deviceclass INTEGER NOT NULL DEFAULT 0, config BYTEA, configchangetime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, configchecksum VARCHAR(64), datatablename VARCHAR(60), PRIMARY KEY (serialnumber, deviceid) ) 0 0 0 0 0 0 3625419 149017.13361100023 0.017925 142.611668 0.04110342380039333 0.22461701966590195 0 2328 0 0 0 0 0 0 0 0 0 0 0 1 0 92
16385 16384 t -8321548535197168573 CREATE TABLE IF NOT EXISTS "tbl001EC6053075_52" ( 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.016726 6.016726 6.016726 6.016726 0 0 1115 2 2 0 0 0 0 0 0 0 0 0 276 2 37025
16385 13761 t 4101374799556151092 DROP TABLE IF EXISTS _ab6d56c31864922703c761538e38f2b8 0 0 0 0 0 0 1 0.124419 0.124419 0.124419 0.124419 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -5924288456416133397 CREATE TABLE _4672b97ec8f992b9fe0b00b4879ed49a(cmd_output text) 0 0 0 0 0 0 1 7.77979 7.77979 7.77979 7.77979 0 0 505 4 26 0 0 0 0 0 0 0 0 0 93 26 128800
16385 16384 t 271202852639995456 CREATE TABLE IF NOT EXISTS "tbl001EC6050189_32" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "Volts_A_N_Volts_1" DOUBLE PRECISION DEFAULT NULL, "Volts_B_N_Volts_2" DOUBLE PRECISION DEFAULT NULL, "Volts_C_N_Volts_3" DOUBLE PRECISION DEFAULT NULL, "Volts_A_B_Volts_4" DOUBLE PRECISION DEFAULT NULL, "Volts_B_C_Volts_5" DOUBLE PRECISION DEFAULT NULL, "Volts_C_A_Volts_6" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Amps_7" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Amps_8" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Amps_9" DOUBLE PRECISION DEFAULT NULL, "Watts_3_Ph_total_kW_10" DOUBLE PRECISION DEFAULT NULL, "VARs_3_Ph_total_kVAR_11" DOUBLE PRECISION DEFAULT NULL, "VAs_3_Ph_total_kVA_12" DOUBLE PRECISION DEFAULT NULL, "Power_Factor_3_Ph_total_13" DOUBLE PRECISION DEFAULT NULL, "Frequency_Hz_14" DOUBLE PRECISION DEFAULT NULL, "Neutral_Current_Amps_15" DOUBLE PRECISION DEFAULT NULL, "W_hours_Received_kWh_16" DOUBLE PRECISION DEFAULT NULL, "W_hours_Delivered_kWh_17" DOUBLE PRECISION DEFAULT NULL, "W_hours_Net_kWh_18" DOUBLE PRECISION DEFAULT NULL, "W_hours_Total_kWh_19" DOUBLE PRECISION DEFAULT NULL, "VAR_hours_Positive_kVARh_20" DOUBLE PRECISION DEFAULT NULL, "VAR_hours_Negative_kVARh_21" DOUBLE PRECISION DEFAULT NULL, "VAR_hours_Net_kVARh_22" DOUBLE PRECISION DEFAULT NULL, "VAR_hours_Total_kVARh_23" DOUBLE PRECISION DEFAULT NULL, "VA_hours_Total_kVAh_24" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Average_Amps_25" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Average_Amps_26" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Average_Amps_27" DOUBLE PRECISION DEFAULT NULL, "Positive_Watts_3_Ph_Average_kW_28" DOUBLE PRECISION DEFAULT NULL, "Positive_VARs_3_Ph_Average_kVAR_29" DOUBLE PRECISION DEFAULT NULL, "Negative_Watts_3_Ph_Average_kW_30" DOUBLE PRECISION DEFAULT NULL, "Negative_VARs_3_Ph_Average_kVAR_31" DOUBLE PRECISION DEFAULT NULL, "VAs_3_Ph_Average_kVA_32" DOUBLE PRECISION DEFAULT NULL, "Positive_PF_3_Ph_Average_33" DOUBLE PRECISION DEFAULT NULL, "Negative_PF_3_Ph_Average_34" DOUBLE PRECISION DEFAULT NULL, "Volts_A_N_Min_Volts_35" DOUBLE PRECISION DEFAULT NULL, "Volts_B_N_Min_Volts_36" DOUBLE PRECISION DEFAULT NULL, "Volts_C_N_Min_Volts_37" DOUBLE PRECISION DEFAULT NULL, "Volts_A_B_Min_Volts_38" DOUBLE PRECISION DEFAULT NULL, "Volts_B_C_Min_Volts_39" DOUBLE PRECISION DEFAULT NULL, "Volts_C_A_Min_Volts_40" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Min_Avg_Demand_Amps_41" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Min_Avg_Demand_Amps_42" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Min_Avg_Demand_Amps_43" DOUBLE PRECISION DEFAULT NULL, "Positive_Watts_3_Ph_Min_Avg_Demand_kW_44" DOUBLE PRECISION DEFAULT NULL, "Positive_VARs_3_Ph_Min_Avg_Demand_kVAR_45" DOUBLE PRECISION DEFAULT NULL, "Negative_Watts_3_Ph_Min_Avg_Demand_kW_46" DOUBLE PRECISION DEFAULT NULL, "Negative_VARs_3_Ph_Min_Avg_Demand_kVAR_47" DOUBLE PRECISION DEFAULT NULL, "VAs_3_Ph_Min_Avg_Demand_kVA_48" DOUBLE PRECISION DEFAULT NULL, "Positive_PF_3_Ph_Min_Avg_Demand_49" DOUBLE PRECISION DEFAULT NULL, "Negative_PF_3_Ph_Min_Avg_Demand_50" DOUBLE PRECISION DEFAULT NULL, "Frequency_Min_Hz_51" DOUBLE PRECISION DEFAULT NULL, "Volts_A_N_Max_Volts_52" DOUBLE PRECISION DEFAULT NULL, "Volts_B_N_Max_Volts_53" DOUBLE PRECISION DEFAULT NULL, "Volts_C_N_Max_Volts_54" DOUBLE PRECISION DEFAULT NULL, "Volts_A_B_Max_Volts_55" DOUBLE PRECISION DEFAULT NULL, "Volts_B_C_Max_Volts_56" DOUBLE PRECISION DEFAULT NULL, "Volts_C_A_Max_Volts_57" DOUBLE PRECISION DEFAULT NULL, "Amps_A_Max_Avg_Demand_Amps_58" DOUBLE PRECISION DEFAULT NULL, "Amps_B_Max_Avg_Demand_Amps_59" DOUBLE PRECISION DEFAULT NULL, "Amps_C_Max_Avg_Demand_Amps_60" DOUBLE PRECISION DEFAULT NULL, "Positive_Watts_3_Ph_Max_Avg_Demand_kW_61" DOUBLE PRECISION DEFAULT NULL, "Positive_VARs_3_Ph_Max_Avg_Demand_kVAR_62" DOUBLE PRECISION DEFAULT NULL, "Negative_Watts_3_Ph_Max_Avg_Demand_kW_63" DOUBLE PRECISION DEFAULT NULL, "Negative_VARs_3_Ph_Max_Avg_Demand_kVAR_64" DOUBLE PRECISION DEFAULT NULL, "VAs_3_Ph_Max_Avg_Demand_kVA_65" DOUBLE PRECISION DEFAULT NULL, "Positive_PF_3_Ph_Max_Avg_Demand_66" DOUBLE PRECISION DEFAULT NULL, "Negative_PF_3_Ph_Max_Avg_Demand_67" DOUBLE PRECISION DEFAULT NULL, "Frequency_Max_Hz_68" DOUBLE PRECISION DEFAULT NULL, "Volts_A_N_THD_69" DOUBLE PRECISION DEFAULT NULL, "Volts_B_N_THD_70" DOUBLE PRECISION DEFAULT NULL, "Volts_C_N_THD_71" DOUBLE PRECISION DEFAULT NULL, "Amps_A_THD_72" DOUBLE PRECISION DEFAULT NULL, "Amps_B_THD_73" DOUBLE PRECISION DEFAULT NULL, "Amps_C_THD_74" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_0th_harmonic_magnitude_75" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_1st_harmonic_magnitude_76" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_2nd_harmonic_magnitude_77" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_3rd_harmonic_magnitude_78" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_4th_harmonic_magnitude_79" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_5th_harmonic_magnitude_80" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_6th_harmonic_magnitude_81" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Current_7th_harmonic_magnitude_82" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Voltage_0th_harmonic_magnitude_83" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Voltage_1st_harmonic_magnitude_84" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Voltage_2nd_harmonic_magnitude_85" DOUBLE PRECISION DEFAULT NULL, "Phase_A_Voltage_3rd_harmonic_magnitude_86" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_0th_harmonic_magnitude_87" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_1st_harmonic_magnitude_88" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_2nd_harmonic_magnitude_89" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_3rd_harmonic_magnitude_90" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_4th_harmonic_magnitude_91" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_5th_harmonic_magnitude_92" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_6th_harmonic_magnitude_93" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Current_7th_harmonic_magnitude_94" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Voltage_0th_harmonic_magnitude_95" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Voltage_1st_harmonic_magnitude_96" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Voltage_2nd_harmonic_magnitude_97" DOUBLE PRECISION DEFAULT NULL, "Phase_B_Voltage_3rd_harmonic_magnitude_98" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_0th_harmonic_magnitude_99" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_1st_harmonic_magnitude_100" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_2nd_harmonic_magnitude_101" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_3rd_harmonic_magnitude_102" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_4th_harmonic_magnitude_103" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_5th_harmonic_magnitude_104" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_6th_harmonic_magnitude_105" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Current_7th_harmonic_magnitude_106" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Voltage_0th_harmonic_magnitude_107" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Voltage_1st_harmonic_magnitude_108" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Voltage_2nd_harmonic_magnitude_109" DOUBLE PRECISION DEFAULT NULL, "Phase_C_Voltage_3rd_harmonic_magnitude_110" DOUBLE PRECISION DEFAULT NULL, "Angle_Phase_A_Current_Degrees_111" DOUBLE PRECISION DEFAULT NULL, "Angle_Phase_B_Current_Degrees_112" DOUBLE PRECISION DEFAULT NULL, "Angle_Phase_C_Current_Degrees_113" DOUBLE PRECISION DEFAULT NULL, "Angle_Volts_A_B_Degrees_114" DOUBLE PRECISION DEFAULT NULL, "Angle_Volts_B_C_Degrees_115" DOUBLE PRECISION DEFAULT NULL, "Angle_Volts_C_A_Degrees_116" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 11.282467 11.282467 11.282467 11.282467 0 0 1521 5 7 0 0 0 0 0 0 0 0 0 354 4 53607
16385 16384 t 7087652273230772339 LOCK TABLE public."tbl001EC6053093_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.39794999999999997 0.026072 0.049671 0.039795000000000004 0.006809807618427997 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8926942820291894568 LOCK TABLE public."tbl001EC6053109_2" IN ACCESS SHARE MODE 0 0 0 0 0 0 3 0.061141 0.018368 0.022517 0.020380333333333334 0.0016961022636883924 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4099123888626420598 SELECT * FROM "tbl001EC6050E4D_80" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 4 0.938391 0.148749 0.35667400000000005 0.23459775 0.084294796352963 400 79 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1968476280237918918 SELECT * FROM "tbl001EC6050189_32" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1718 114.64122300000001 0.018850000000000002 2.1810940000000003 0.06672946623981375 0.1200181100312416 1717 4325 19 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4288815437679689598 INSERT INTO "tbl001EC6050D16_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 71435 1847.1845460000045 0.01401 11.806188 0.025858256400923867 0.07077342921273275 71435 429432 14 2016 661 0 0 0 0 0 0 0 0 214503 1368 19446547
16385 16384 t -5595710800441349580 INSERT INTO "tbl001EC60537E0_21" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 1994 138.1491339999999 0.021852 2.4289929999999997 0.06928241424272821 0.11568076009080538 1994 12302 99 3659 163 0 0 0 0 0 0 0 0 5988 3801 17225759
16385 16384 t 2858289407752068825 LOCK TABLE public."tbl001EC6050B08_1" IN ACCESS SHARE MODE 0 0 0 0 0 0 10 0.304676 0.019514 0.06263 0.030467600000000004 0.013780451307558837 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5319718725369918811 LOCK TABLE public."tbl001EC6050B87_4" IN ACCESS SHARE MODE 0 0 0 0 0 0 9 0.224754 0.017896 0.037753 0.02497266666666667 0.0066947710275341845 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2903019351194623448 SELECT * FROM "tbl001EC6050BAC_8" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 15 3.09947 0.086806 0.43608600000000003 0.2066313333333333 0.11212315321149727 1500 979 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2640901887234002746 LOCK TABLE public."tbl001EC6050F3C_4" IN ACCESS SHARE MODE 0 0 0 0 0 0 1 0.020202 0.020202 0.020202 0.020202 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1747314206963845971 SELECT * FROM "tbl001EC6053093_55" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 4.658082 4.658082 4.658082 4.658082 0 100 51 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8665989202865055199 SELECT * FROM "tbl001EC6050D16_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2012 52.10315599999995 0.006295 1.323339 0.02589620079522866 0.04715061267135069 2011 6027 7 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1340815256189189032 COPY public."tbl001EC60506E1_3" ("time", error, lowrange, highrange, "Real_Energy_Consumption_kWh_1", "Total_Instantaneous_Real_Power_kW_2", "Total_Instantaneous_Reactive_Power_kVAR_3", "Total_Instantaneous_Apparent_Power_kVA_4", "Total_Power_Factor_5", "Voltage_L_L_3p_Ave_Volts_6", "Voltage_L_N_3p_Ave_Volts_7", "Current_3p_Ave_Amps_8", "Real_Power_Phase_A_kW_9", "Real_Power_Phase_B_kW_10", "Real_Power_Phase_C_kW_11", "Power_Factor_Phase_A_12", "Power_Factor_Phase_B_13", "Power_Factor_Phase_C_14", "Voltage_Phase_A_B_Volts_15", "Voltage_Phase_B_C_Volts_16", "Voltage_Phase_A_C_Volts_17", "Voltage_Phase_A_N_Volts_18", "Voltage_Phase_B_N_Volts_19", "Voltage_Phase_C_N_Volts_20", "Current_Instantaneous_Phase_A_Amps_21", "Current_Instantaneous_Phase_B_Amps_22", "Current_Instantaneous_Phase_C_Amps_23", "Frequency_Hz_24", "Apparent_Energy_Consumption_kVAh_25", "Reactive_Energy_Consumption_kVARh_26", "Apparent_Power_Phase_A_kVA_27", "Apparent_Power_Phase_B_kVA_28", "Apparent_Power_Phase_C_kVA_29", "Reactive_Power_Phase_A_kVAR_30", "Reactive_Power_Phase_B_kVAR_31", "Reactive_Power_Phase_C_kVAR_32", "Total_Real_Power_Present_Demand_kW_33", "Total_Reactive_Power_Present_Demand_kVAR_34", "Total_Apparent_Power_Present_Demand_kVA_35", "Total_Real_Power_Max_Demand_kW_36", "Total_Reactive_Power_Max_Demand_kVAR_37") TO stdout 0 0 0 0 0 0 10 38042.011287 3512.006094 3966.173293 3804.2011287 127.05034231534736 2069352 977 95885 599 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6583726746227148814 SELECT * FROM "tblacquisuite" ORDER BY "serialnumber" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 20 6.935022 0.17993800000000001 1.7268260000000002 0.34675110000000003 0.3227709822330533 666 255 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1697528191539421659 LOCK TABLE public."tbl001EC6050BAC_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 7 0.20392800000000003 0.022957 0.046287 0.02913257142857143 0.00823849876853688 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 228979088722466758 COPY public."tbl001EC6056D48_9" ("time", error, lowrange, highrange, "Active_Power_Total_kW_1", "Reactive_Power_Total_kVAR_2", "Apparent_Power_Total_kVA_3", "Voltage_Average_Volts_4", "Voltage_L_L_Average_Volts_5", "Current_Average_Amps_6", "System_Power_Factor_7", "System_Frequency_Hz_8", "Voltage_Average_Angle_Degrees_9", "System_Quadrant_10", "Voltage_A_Volts_11", "Voltage_B_Volts_12", "Voltage_C_Volts_13", "Voltage_A_B_Volts_14", "Voltage_B_C_Volts_15", "Voltage_A_C_Volts_16", "Current_A_Amps_17", "Current_B_Amps_18", "Current_C_Amps_19", "Active_Power_A_kW_20", "Active_Power_B_kW_21", "Active_Power_C_kW_22", "Reactive_Power_A_kVAR_23", "Reactive_Power_B_kVAR_24", "Reactive_Power_C_kVAR_25", "Apparent_Power_A_kVA_26", "Apparent_Power_B_kVA_27", "Apparent_Power_C_kVA_28", "Power_Factor_A_29", "Power_Factor_B_30", "Power_Factor_C_31", "Voltage_Angle_AB_Degrees_32", "Voltage_Angle_BC_Degrees_33", "Voltage_Angle_CA_Degrees_34", "Quadrant_A_35", "Quadrant_B_36", "Quadrant_C_37", "Sliding_Window_Power_kW_38", "Net_Total_Energy_Revenue_kWh_39", "Total_Net_Apparent_Energy_Revenue_kVA_40", "Total_Import_Energy_Revenue_kWh_41", "Total_Export_Energy_Revenue_kWh_42", "Total_Import_Apparent_Energy_Revenue_kVA_43", "Total_Export_Apparent_Energy_Revenue_kVA_44", "Q1_Total_Reactive_Energy_Revenue_kVAR_45", "Q2_Total_Reactive_Energy_Revenue_kVAR_46", "Q3_Total_Reactive_Energy_Revenue_kVAR_47", "Q4_Total_Reactive_Energy_Revenue_kVAR_48", "Q1_Q2_Total_Inductive_Reactive_Energy_Revenue_kVAR_49", "Q3_Q4_Total_Capacitive_Reactive_Energy_Revenue_kVAR_50", "Net_Energy_Revenue_A_kWh_51", "Net_Energy_Revenue_B_kWh_52", "Net_Energy_Revenue_C_kWh_53", "Net_Apparent_Energy_Revenue_A_kVA_54", "Net_Apparent_Energy_Revenue_B_kVA_55", "Net_Apparent_Energy_Revenue_C_kVA_56", "Import_Energy_Revenue_A_kWh_57", "Import_Energy_Revenue_B_kWh_58", "Import_Energy_Revenue_C_kWh_59", "Export_Energy_Revenue_A_kWh_60", "Export_Energy_Revenue_B_kWh_61", "Export_Energy_Revenue_C_kWh_62", "Import_Apparent_Energy_Revenue_A_kVA_63", "Import_Apparent_Energy_Revenue_B_kVA_64", "Import_Apparent_Energy_Revenue_C_kVA_65", "Export_Apparent_Energy_Revenue_A_kVA_66", "Export_Apparent_Energy_Revenue_B_kVA_67", "Export_Apparent_Energy_Revenue_C_kVA_68", "Q1_Reactive_Energy_Revenue_A_kVAR_69", "Q1_Reactive_Energy_Revenue_B_kVAR_70", "Q1_Reactive_Energy_Revenue_C_kVAR_71", "Q2_Reactive_Energy_Revenue_A_kVAR_72", "Q2_Reactive_Energy_Revenue_B_kVAR_73", "Q2_Reactive_Energy_Revenue_C_kVAR_74", "Q3_Reactive_Energy_Revenue_A_kVAR_75", "Q3_Reactive_Energy_Revenue_B_kVAR_76", "Q3_Reactive_Energy_Revenue_C_kVAR_77", "Q4_Reactive_Energy_Revenue_A_kVAR_78", "Q4_Reactive_Energy_Revenue_B_kVAR_79", "Q4_Reactive_Energy_Revenue_C_kVAR_80") TO stdout 0 0 0 0 0 0 10 6187.9778240000005 357.949518 844.592507 618.7977824000001 149.51458132108075 226360 16 20809 63 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3997116843154597970 SELECT * FROM "tbl001EC6056FD2_52" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29836 762.775820000003 0.012728999999999999 4.291805999999999 0.02556561938597672 0.061290394170579715 29836 89500 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1119721483267988313 SELECT * FROM "tbl001EC6050F3C_7" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 13 0.890156 0.027032 0.174316 0.06847353846153846 0.04477058110929436 183 28 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2000320538335994435 SELECT * FROM "tbl001EC6050F3C_15" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 178 7.170804999999999 0.019511 1.308989 0.0402854213483146 0.1002421849316035 177 353 2 0 0 0 0 0 0 0 0 0 0 0 0 0