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 3879473893788712207 COPY public."tbl001EC6050BAC_51" ("time", error, lowrange, highrange, "Analog_In_1_1", "Analog_In_2_2", "Analog_In_3_3", "Analog_In_4_4", "Pulse_1_5", "Pulse_2_6", "Pulse_3_7", "Pulse_4_8", "Status_register_9", firmware_version_10, "Uptime_Seconds_11", "Pulse_State_Register_12", "Pulse_1_ontime_Sec_sec_13", "Pulse_2_ontime_Sec_sec_14", "Pulse_3_ontime_Sec_sec_15", "Pulse_4_ontime_Sec_sec_16", "Pulse_1_last_minute_change_17", "Pulse_2_last_minute_change_18", "Pulse_3_last_minute_change_19", "Pulse_4_last_minute_change_20") TO stdout 0 0 0 0 0 0 8 151.825825 0.154256 39.348138 18.978228125 12.81733734129167 40656 740 453 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8803423234280775787 INSERT INTO "tbl001EC6050B87_4" 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 6745 429.32266900000025 0.024123 2.3988519999999998 0.06365050689399569 0.10553370282377687 6745 42362 162 7446 672 0 0 0 0 0 0 0 0 20254 6262 30977231
16385 16384 t -1872795438687850368 SELECT classid, objid, refobjid FROM pg_depend WHERE refclassid = $1::regclass AND deptype = $2 ORDER BY 3 0 0 0 0 0 0 11 59.203832 1.336262 29.627086000000002 5.382166545454545 7.861834238255766 4081 189 12 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2258128279028637121 LOCK TABLE public."tbl001EC6050EFC_211" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.4722320000000001 0.022032 0.123776 0.04293018181818181 0.027491633969820316 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -4351289693671996479 COPY public."tbl001EC6056FD2_52" ("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 11 1039.798057 59.681069 231.890329 94.52709609090911 45.42669013397612 257543 12 5333 13 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 1487539438423969421 SELECT * FROM "tbl001EC6056300_53" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.31833 0.31833 0.31833 0.31833 0 100 27 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3961926472845367899 SELECT * FROM "tbl001EC60537AE_2" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 1 0.151609 0.151609 0.151609 0.151609 0 100 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -977905132212972358 CREATE TABLE _c9a3c9c4c96f52739fc931dd3c85fea5(cmd_output text) 0 0 0 0 0 0 1 10.853241 10.853241 10.853241 10.853241 0 0 505 5 28 1 0 0 0 0 0 0 0 0 94 27 138469
16385 16384 t 6889792822003414169 SELECT * FROM "tbl001EC6056D48_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30590 1398.5780179999947 0.019724 7.291701000000001 0.04572010519777707 0.05866624492467359 30590 91764 6 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5764167197384598814 LOCK TABLE public."tbl001EC6050D30_80" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.45198000000000005 0.01783 0.10626 0.04108909090909091 0.032108743497554305 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -4881158244601953987 DROP TABLE IF EXISTS _2aa7106d5df56d0970ddefac4806b437 0 0 0 0 0 0 1 0.110903 0.110903 0.110903 0.110903 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 9208141611274204643 SELECT * FROM "tbl001EC6050F3A_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2090 91.201821 0.018958 2.654489 0.043637234928229636 0.15050658584690152 2090 6237 33 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2142683441719782525 SELECT set_config($1,$2,$3) FROM pg_show_all_settings() WHERE name = $4 0 0 0 0 0 0 4 5.439598999999999 1.135074 1.8190190000000002 1.3598997499999999 0.26888378086765946 4 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4773270243600844049 SELECT * FROM "tbl001EC6056300_51" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30732 851.3012579999997 0.015492999999999998 5.964413 0.027700808863724988 0.05540117713020297 30732 122892 36 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7696924723746410624 INSERT INTO "tbl001EC6056FD2_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15766 691.1756590000014 0.014731 7.228384 0.04383963332487621 0.1030283396775329 15766 97435 47 8956 338 0 0 0 0 0 0 0 0 47341 8247 39536757
16385 16384 t 3302737369012305715 LOCK TABLE public."tbl001EC6050D05_51" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.359292 0.020251 0.106664 0.03266290909090909 0.024183140793290255 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2598340946295396933 INSERT INTO "tbl001EC6056D48_53" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15769 843.1874040000008 0.018005 3.25761 0.05347120324687644 0.07262189545706318 15769 99691 31 11218 1458 0 0 0 0 0 0 0 0 47350 8427 47414922
16385 16384 t 6326490895673415451 LOCK TABLE public."tbl001EC605309C_54" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.25539000000000006 0.01846 0.036092 0.023217272727272725 0.005503899544718008 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -9060600289112616575 LOCK TABLE public."tbl001EC6056FD2_67" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.359622 0.018301 0.052502 0.03269290909090909 0.010220517176511758 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -2851746447113459869 CREATE TABLE _a0e3ebb07eb3031dc27640c5e62fd99c(cmd_output text) 0 0 0 0 0 0 1 61.719128 61.719128 61.719128 61.719128 0 0 434 87 29 1 0 0 0 0 0 0 0 0 95 27 146658
16385 16384 t -3962163088937118665 SELECT * FROM "tbl001EC605309C_53" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 29398 1207.2483349999916 0.021289 3.4042909999999997 0.04106566211987229 0.044532480611828774 29398 88170 24 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 8179896165877533666 SELECT * FROM "tbl001EC6050BAC_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 21 36.106583 0.083604 29.019044 1.7193610952380953 6.11184694564559 2100 2545 47 2 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -2500068333474953968 INSERT INTO "tbl001EC6050D17_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 533 22.90808600000001 0.021214 0.757544 0.04297952345215764 0.050802141651036734 533 2473 4 285 28 0 0 0 0 0 0 0 0 1601 245 1045086
16385 16384 t -2338304633893173223 LOCK TABLE public."tbl001EC6050F3C_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 2 0.25197400000000003 0.01748 0.234494 0.12598700000000002 0.10850700000000002 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6220900825029849627 SELECT * FROM "tbl001EC6050B87_4" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 13396 525.1571259999979 0.010187 9.594133 0.039202532547029136 0.08487308452219419 13395 39374 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5734318202858769270 SELECT * FROM "tbl001EC6050BAC_52" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 22 58.31240899999999 0.040071999999999997 46.038416 2.6505640454545456 9.473176615345675 2116 5514 75 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3115089256870894380 COPY public."tbl001EC60537AE_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 11 236.279181 13.101511 58.7572 21.479925545454545 12.681132018476314 54743 275 1102 4 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 5729042525868507828 DROP TABLE IF EXISTS _71bea648143aab999847d89a6e7edaf0 0 0 0 0 0 0 1 0.091361 0.091361 0.091361 0.091361 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t -4117862555479237961 CREATE TABLE _ccafc861c6b1d39fc441af1df7a5aec0(cmd_output text) 0 0 0 0 0 0 1 7.901667 7.901667 7.901667 7.901667 0 0 505 1 24 0 0 0 0 0 0 0 0 0 93 25 125151
16385 16384 t -2973456993556154282 SELECT * FROM "tbl001EC6050F3A_2" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 2090 72.13429200000004 0.012783 2.812853 0.03451401531100477 0.14199117856805132 2090 6235 35 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4882226368212586955 LOCK TABLE public."tbl001EC60537AE_41" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.403206 0.017736 0.095235 0.03665509090909091 0.02714366107970547 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 4707437177723149985 INSERT INTO "tbl001EC6053093_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) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 15769 708.5283189999996 0.01599 2.541239 0.044931721669097355 0.05651584770511373 15769 98887 29 9018 820 0 0 0 0 0 0 0 0 47351 7813 36347754
16385 16384 t 6363315961552066800 INSERT INTO "tbl001EC6050B42_4" 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 600 47.27525199999995 0.021542000000000002 0.986951 0.07879208666666665 0.11462006142579272 600 3213 14 1223 52 0 0 0 0 0 0 0 0 1802 1138 4832548
16385 16384 t -6231790230389274721 INSERT INTO "tbl001EC6050189_6" VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84) ON CONFLICT (time) DO NOTHING 0 0 0 0 0 0 889 75.91594899999998 0.024193 2.505004 0.08539476827896501 0.15361745846943223 889 5195 20 1850 96 0 0 0 0 0 0 0 0 2670 1674 7383627
16385 16384 t -1514139376648305906 INSERT INTO "tbl001EC6050D06_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 1791 118.61339800000009 0.021977999999999998 3.539228 0.06622746957007249 0.15172693493850611 1791 10746 51 2927 38 0 0 0 0 0 0 0 0 5378 3492 14470393
16385 16384 t -1630968816071563086 CREATE TABLE IF NOT EXISTS "tbl001EC60537E0_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 54.93706 54.93706 54.93706 54.93706 0 0 619 79 45 0 0 0 0 0 0 0 0 0 138 39 209000
16385 16384 t 7348385314352234550 SELECT * FROM "tbl001EC6054E88_11" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 21 22.316150000000004 0.083011 11.242359 1.0626738095238097 2.324790308062615 2100 3781 26 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6245430002417615101 SELECT * FROM "tbl001EC6053075_54" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 1882 62.33772000000008 0.019086 1.060399 0.03312312433581295 0.0369857522450361 1881 4834 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 965774770117354495 SELECT * FROM "tbl001EC6056FD2_28" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 2 1.5975019999999998 0.419082 1.1784199999999998 0.798751 0.37966899999999987 200 122 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 2067132578811232197 SELECT * FROM "tbl001EC6053075_5" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 21 5.145627 0.01495 0.887249 0.24502985714285716 0.2570269609588486 1048 350 3 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6876507117363648581 INSERT INTO "tbl001EC6050B5D_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 888 54.103076 0.022173 1.347364 0.06092688738738742 0.09621837551299096 888 4934 14 1725 12 0 0 0 0 0 0 0 0 2667 1718 7056772
16385 16384 t -4748272208961283044 CREATE TABLE IF NOT EXISTS "tbl001EC6053075_6" ( time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, error INTEGER DEFAULT 0, lowrange BIGINT DEFAULT 0, highrange BIGINT DEFAULT 0, "DC_Voltage_V_1" DOUBLE PRECISION DEFAULT NULL, "Apparent_AC_Power_VA_2" DOUBLE PRECISION DEFAULT NULL, "AC_Grid_Frequency_Hz_3" DOUBLE PRECISION DEFAULT NULL, "AC_Power_Stage_Current_A_4" DOUBLE PRECISION DEFAULT NULL, "L1_to_L2_AC_Voltage_V_5" DOUBLE PRECISION DEFAULT NULL, "L2_to_L3_AC_Voltage_V_6" DOUBLE PRECISION DEFAULT NULL, "L1_to_L3_AC_Voltage_V_7" DOUBLE PRECISION DEFAULT NULL, "Phase_Sequence_8" DOUBLE PRECISION DEFAULT NULL, "AC_Energy_kWh_9" DOUBLE PRECISION DEFAULT NULL, "On_Grid_Hours_Hrs_10" DOUBLE PRECISION DEFAULT NULL, "Fan_On_Time_Hours_Hrs_11" DOUBLE PRECISION DEFAULT NULL, "AC_Contactors_Cycles_12" DOUBLE PRECISION DEFAULT NULL, "Network_ID_13" DOUBLE PRECISION DEFAULT NULL, "Informative_Alarms_14" DOUBLE PRECISION DEFAULT NULL, "Inverter_AC_Output_Current_A_15" DOUBLE PRECISION DEFAULT NULL, "Critical_Alarms_16" DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY (time) ) 0 0 0 0 0 0 1 5.254403 5.254403 5.254403 5.254403 0 0 540 1 7 1 0 0 0 0 0 0 0 0 136 4 27821
16385 16384 t 2255072364230800083 INSERT INTO "tbl001EC6056FD2_66" 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 15766 651.9986029999985 0.014644 2.6938169999999997 0.04135472554864895 0.05977289848142138 15766 97513 46 9034 333 0 0 0 0 0 0 0 0 47341 8327 40602455
16385 13761 t 6912053081163473493 CREATE TABLE _705ee56e71c6b033df44deb6aedf36f5(cmd_output text) 0 0 0 0 0 0 1 7.904975 7.904975 7.904975 7.904975 0 0 502 4 24 0 0 0 0 0 0 0 0 0 93 25 98019
16385 16384 t -6599831107475226438 LOCK TABLE public."tbl001EC6050F3C_16" IN ACCESS SHARE MODE 0 0 0 0 0 0 2 0.040893 0.017873 0.02302 0.0204465 0.0025734999999999994 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -8967426194514560537 SELECT * FROM "tbl001EC60530AB_9" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 30734 1430.9841610000021 0.028125 5.40867 0.04656029677230433 0.06378015197467166 30734 92179 23 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7695694190437571930 COPY public."tbl001EC6050F3A_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 11 53.76734900000001 1.812544 7.286878 4.887940818181818 1.4862801804854244 12804 85 171 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 5306927514882487384 COPY public."tbl001EC6050F42_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 2 0.32357800000000003 0.058671 0.264907 0.16178900000000002 0.103118 120 3 0 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -7178632324861739112 COPY public."tbl001EC6050D16_4" ("time", error, lowrange, highrange, "DC_Voltage_V_1", "Apparent_AC_Power_VA_2", "AC_Grid_Frequency_Hz_3", "AC_Power_Stage_Current_A_4", "L1_to_L2_AC_Voltage_V_5", "L2_to_L3_AC_Voltage_V_6", "L1_to_L3_AC_Voltage_V_7", "Phase_Sequence_8", "AC_Energy_kWh_9", "On_Grid_Hours_Hrs_10", "Fan_On_Time_Hours_Hrs_11", "AC_Contactors_Cycles_12", "Network_ID_13", "Informative_Alarms_14", "Inverter_AC_Output_Current_A_15", "Critical_Alarms_16") TO stdout 0 0 0 0 0 0 7 1426.586615 185.045834 232.621856 203.79808785714286 13.654724099189721 472385 1241 6129 202 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 7035780359982550094 INSERT INTO "tbl001EC6056D49_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 15769 846.1940640000058 0.018976 2.330015 0.05366187228105761 0.06407809005505598 15769 99552 31 10987 1504 0 0 0 0 0 0 0 0 47351 8340 46949771
16385 16384 t 592915675297585391 INSERT INTO "tbl001EC6050D05_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 15769 765.6916359999981 0.017952 4.054447 0.048556765552666734 0.07525613873421275 15769 99038 28 8833 897 0 0 0 0 0 0 0 0 47352 7972 38699061
16385 16384 t 4202048471692796787 COPY public."tbl001EC6050B87_7" ("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 392.272973 1.560689 79.128233 39.227297300000004 24.334145572834014 34020 1068 2027 3 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6914743467925604354 LOCK TABLE public."tbl001EC6053093_54" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.479416 0.02514 0.119531 0.04358327272727272 0.025563814650225312 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -1010847098176256167 SELECT * FROM "tbl001EC6050D15_11" ORDER BY "time" DESC LIMIT $1 OFFSET $2 0 0 0 0 0 0 8 7.151896000000002 0.094499 5.126987000000001 0.8939870000000001 1.6089392775403306 338 361 8 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 3241078883670397884 LOCK TABLE public."tbl001EC605309C_9" IN ACCESS SHARE MODE 0 0 0 0 0 0 11 0.284908 0.017977 0.048397 0.025900727272727273 0.00903082215215213 0 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 59099419239392898 SELECT * FROM "tbl001EC6053CD9_1" ORDER BY time DESC LIMIT $1 0 0 0 0 0 0 6196 165.979183 0.008542000000000001 2.597678 0.026788118624919265 0.06572622985483957 6195 17766 18 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 13761 t 1437869368167774727 DROP TABLE IF EXISTS _a0e3ebb07eb3031dc27640c5e62fd99c 0 0 0 0 0 0 1 4.315242 4.315242 4.315242 4.315242 0 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t 6147824155953632616 COPY public."tbl001EC6053093_51" ("time", error, lowrange, highrange, "Operating_State_I_Status_1", "Vendor_Operating_State_I_Status_Vendor_2", "Event_Flags_I_Event_1_bits_0_31_3", "Event_Flags_I_Event_2_bits_32_63_4", "Vendor_Event_Flags_I_Event_1_Vendor_bits_0_31_5", "Vendor_Event_Flags_I_Event_2_Vendor_bits_32_63_6", "Vendor_Event_Flags_I_Event_3_Vendor_bits_64_95_7", "Vendor_Event_Flags_I_Event_4_Vendor_bits_96_127_8", "AC_Total_Current_I_AC_Current_A_9", "AC_Phase_A_Current_I_AC_CurrentA_A_10", "AC_Phase_B_Current_I_AC_CurrentB_A_11", "AC_Phase_C_Current_I_AC_CurrentC_A_12", "ac_current_Scale_Factor_I_AC_Current_SF_13", "AC_Voltage_Phase_AB_I_AC_VoltageAB_V_14", "AC_Voltage_Phase_BC_I_AC_VoltageBC_V_15", "AC_Voltage_Phase_CA_I_AC_VoltageCA_V_16", "AC_Voltage_Phase_A_to_neutral_I_AC_VoltageAN_V_17", "AC_Voltage_Phase_B_to_neutral_I_AC_VoltageBN_V_18", "AC_Voltage_Phase_C_to_neutral_I_AC_VoltageCN_V_19", "ac_voltage_Scale_Factor_I_AC_Voltage_SF_20", "AC_Power_I_AC_Power_W_21", "ac_power_Scale_Factor_I_AC_Power_SF_22", "AC_Frequency_I_AC_Frequency_Hz_23", "ac_frequency_Scale_Factor_I_AC_Frequency_SF_24", "Apparent_Power_I_AC_VA_VA_25", "apparent_power_Scale_Factor_I_AC_VA_SF_26", "Reactive_Power_I_AC_VAR_Var_27", "reactive_power_Scale_Factor_I_AC_VAR_28", "Power_Factor_I_AC_PF_29", "power_factor_Scale_Factor_I_AC_PF_SF_30", "AC_Lifetime_Energy_I_AC_Energy_WH_Wh_31", "ac_lifetime_energy_Scale_Factor_I_AC_Energy_WH_SF_32", "DC_Current_I_DC_Current_A_33", "dc_current_Scale_Factor_I_DC_Current_SF_34", "DC_Voltage_I_DC_Voltage_V_35", "dc_voltage_Scale_Factor_I_DC_Voltage_SF_36", "DC_Power_I_DC_Power_W_37", "dc_power_Scale_Factor_I_DC_Power_SF_38", "Cabinet_Temperature_I_Temp_Cab_Deg_C_39", "Coolant_or_Heat_Sink_Temp_I_Temp_Sink_Deg_C_40", "Transformer_Temperature_I_Temp_Trans_Deg_C_41", "Other_Temperature_I_Temp_Other_Deg_C_42", "temperature_Scale_Factor_I_Temp_SF_43", "C_SunSpec_ID_44", "C_SunSpec_DID_Model_Block_45", "C_SunSpec_Length_46", "Manufacturer_C_Manufacturer_string_part_1_47", "Manufacturer_C_Manufacturer_string_part_2_48", "Manufacturer_C_Manufacturer_string_part_3_49", "Manufacturer_C_Manufacturer_string_part_4_50", "Manufacturer_C_Manufacturer_string_part_5_51", "Manufacturer_C_Manufacturer_string_part_6_52", "Manufacturer_C_Manufacturer_string_part_7_53", "Manufacturer_C_Manufacturer_string_part_8_54", "Inverter_Type_C_Model_string_part_1_55", "Inverter_Type_C_Model_string_part_2_56", "Inverter_Type_C_Model_string_part_3_57", "Inverter_Type_C_Model_string_part_4_58", "Inverter_Type_C_Model_string_part_5_59", "Inverter_Type_C_Model_string_part_6_60", "Inverter_Type_C_Model_string_part_7_61", "Inverter_Type_C_Model_string_part_8_62", "C_Options_Manufacturer_specific_string_part_1_63", "C_Options_Manufacturer_specific_string_part_2_64", "C_Options_Manufacturer_specific_string_part_3_65", "C_Options_Manufacturer_specific_string_part_4_66", "C_Version_Manufacturer_specific_string_part_1_67", "C_Version_Manufacturer_specific_string_part_2_68", "C_Version_Manufacturer_specific_string_part_3_69", "C_Version_Manufacturer_specific_string_part_4_70", "C_SerialNumber_Manufacturer_specific_string_part_1_71", "C_SerialNumber_Manufacturer_specific_string_part_2_72", "C_SerialNumber_Manufacturer_specific_string_part_3_73", "C_SerialNumber_Manufacturer_specific_string_part_4_74", "C_SerialNumber_Manufacturer_specific_string_part_5_75", "C_SerialNumber_Manufacturer_specific_string_part_6_76", "C_SerialNumber_Manufacturer_specific_string_part_7_77", "C_SerialNumber_Manufacturer_specific_string_part_8_78", "C_DeviceAddress_Modbus_ID_79", "C_SunSpec_DID_End_Block_matches_FFFF_80", "C_SunSpec_Length_Last_Block_matches_0_81") TO stdout 0 0 0 0 0 0 11 32008.914707000007 2583.650439 3597.972585 2909.9013370000002 260.398644676598 2344507 15167 213847 48 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -5105135417921574691 COPY public."tbl001EC6050BAC_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 8 108.78399199999998 0.101187 32.112383 13.597999 9.956352183142567 40656 457 143 1 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -3447176434246213356 SELECT p.tableoid, p.oid, p.proname AS aggname, p.pronamespace AS aggnamespace, p.pronargs, p.proargtypes, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = p.proowner) AS rolname, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(p.proacl,pg_catalog.acldefault($1,p.proowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT $2 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault($3,p.proowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS aggacl, (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,p.proowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT $5 FROM pg_catalog.unnest(coalesce(p.proacl,pg_catalog.acldefault($6,p.proowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) AS raggacl, $7 AS initaggacl, $8 AS initraggacl FROM pg_proc p LEFT JOIN pg_init_privs pip ON (p.oid = pip.objoid AND pip.classoid = $9::regclass AND pip.objsubid = $10) WHERE p.prokind = $11 AND (p.pronamespace != (SELECT oid FROM pg_namespace WHERE nspname = $12) OR p.proacl IS DISTINCT FROM pip.initprivs) 0 0 0 0 0 0 11 16.432028 1.1725640000000002 3.417968 1.4938207272727273 0.6196754509894076 55 1375 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16385 16384 t -6785110097669042851 COPY public."tbl001EC6053109_5" ("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 4 20.143692 0.656788 8.489909 5.035923 3.215936951016842 10040 55 28 1 0 0 0 0 0 0 0 0 0 0 0 0
10 16384 t <insufficient privilege> 0 0 0 0 0 0 1 1.2414990000000001 1.2414990000000001 1.2414990000000001 1.2414990000000001 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0
10 16384 t <insufficient privilege> 0 0 0 0 0 0 11 3.02783 0.22306 0.430348 0.27525727272727274 0.07348601038304181 22 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 16384 t <insufficient privilege> 0 0 0 0 0 0 2 26.737291 11.324854 15.412436999999999 13.3686455 2.0437914999999993 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 16384 t <insufficient privilege> 0 0 0 0 0 0 2 0.05190500000000001 0.025147000000000003 0.026758 0.025952500000000003 0.0008054999999999981 10 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 13761 t <insufficient privilege> 0 0 0 0 0 0 8 0.17066199999999998 0.015869 0.029346999999999998 0.02133275 0.004343157628672945 6 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 16384 t <insufficient privilege> 0 0 0 0 0 0 11 4.675831 0.31419 0.8505649999999999 0.42507554545454546 0.1541315711800465 22 276 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 16384 t <insufficient privilege> 0 0 0 0 0 0 1 0.895739 0.895739 0.895739 0.895739 0 0 25 1 1 0 0 0 0 0 0 0 0 0 1 1 809
10 16384 t <insufficient privilege> 0 0 0 0 0 0 11 0.063735 0.004415 0.008564 0.0057940909090909085 0.0013688525688955336 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 16384 t <insufficient privilege> 0 0 0 0 0 0 1 4.479678 4.479678 4.479678 4.479678 0 0 1584 2 27 0 0 0 0 0 0 0 0 0 692 26 198044
10 16384 t <insufficient privilege> 0 0 0 0 0 0 11 17.834406 0.068504 4.438974 1.6213096363636363 1.0250338340385978 0 36 30 0 0 0 0 0 0 0 0 0 0 0 0 0
10 16384 t <insufficient privilege> 0 0 0 0 0 0 11 0.182913 0.014509 0.01848 0.016628454545454547 0.0011710193976839436 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 13761 t <insufficient privilege> 0 0 0 0 0 0 2 0.175895 0.082097 0.09379799999999999 0.0879475 0.005850499999999995 8 26 0 0 0 0 0 0 0 0 0 0 0 0 0 0