Tables

conditions dl_device_type dl_inverter_device_data dl_meter_device_data pg_stat_statements pg_stat_statements_info tbl001EC60506E1_1 tbl001EC60506E1_10 tbl001EC60506E1_3 tbl001EC6050D05_103 tbl001EC6050D05_51 tbl001EC6050D05_80 tbl001EC6050EFC_211 tbl001EC6050EFC_213 tbl001EC6052F1E_51 tbl001EC6052F1E_9 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 tbl001EC6053113_10 tbl001EC6053113_51 tbl001EC6053113_52 tbl001EC6053113_53 tbl001EC6053113_9 tbl001EC605311A_1 tbl001EC605311A_2 tbl001EC605311A_3 tbl001EC6056300_10 tbl001EC6056300_15 tbl001EC6056300_50 tbl001EC6056300_51 tbl001EC6056300_52 tbl001EC6056300_53 tbl001EC6056300_55 tbl001EC6057D26_4 tblacquisuite tbldevicelist

tbl001EC605309C_9

time
timestamp without time zone 		error
integer 		lowrange
bigint 		highrange
bigint 		Active_Power_Total_kW_1
double precision 		Reactive_Power_Total_kVAR_2
double precision 		Apparent_Power_Total_kVA_3
double precision 		Voltage_Average_Volts_4
double precision 		Voltage_L_L_Average_Volts_5
double precision 		Current_Average_Amps_6
double precision 		System_Power_Factor_7
double precision 		System_Frequency_Hz_8
double precision 		Voltage_Average_Angle_Degrees_9
double precision 		System_Quadrant_10
double precision 		Voltage_A_Volts_11
double precision 		Voltage_B_Volts_12
double precision 		Voltage_C_Volts_13
double precision 		Voltage_A_B_Volts_14
double precision 		Voltage_B_C_Volts_15
double precision 		Voltage_A_C_Volts_16
double precision 		Current_A_Amps_17
double precision 		Current_B_Amps_18
double precision 		Current_C_Amps_19
double precision 		Active_Power_A_kW_20
double precision 		Active_Power_B_kW_21
double precision 		Active_Power_C_kW_22
double precision 		Reactive_Power_A_kVAR_23
double precision 		Reactive_Power_B_kVAR_24
double precision 		Reactive_Power_C_kVAR_25
double precision 		Apparent_Power_A_kVA_26
double precision 		Apparent_Power_B_kVA_27
double precision 		Apparent_Power_C_kVA_28
double precision 		Power_Factor_A_29
double precision 		Power_Factor_B_30
double precision 		Power_Factor_C_31
double precision 		Voltage_Angle_AB_Degrees_32
double precision 		Voltage_Angle_BC_Degrees_33
double precision 		Voltage_Angle_CA_Degrees_34
double precision 		Quadrant_A_35
double precision 		Quadrant_B_36
double precision 		Quadrant_C_37
double precision 		Sliding_Window_Power_kW_38
double precision 		Net_Total_Energy_Revenue_kWh_39
double precision 		Total_Net_Apparent_Energy_Revenue_kVA_40
double precision 		Total_Import_Energy_Revenue_kWh_41
double precision 		Total_Export_Energy_Revenue_kWh_42
double precision 		Total_Import_Apparent_Energy_Revenue_kVA_43
double precision 		Total_Export_Apparent_Energy_Revenue_kVA_44
double precision 		Q1_Total_Reactive_Energy_Revenue_kVAR_45
double precision 		Q2_Total_Reactive_Energy_Revenue_kVAR_46
double precision 		Q3_Total_Reactive_Energy_Revenue_kVAR_47
double precision 		Q4_Total_Reactive_Energy_Revenue_kVAR_48
double precision 		Q1_Q2_Total_Inductive_Reactive_Energy_Revenue_kVAR_49
double precision 		Q3_Q4_Total_Capacitive_Reactive_Energy_Revenue_kVAR_50
double precision 		Net_Energy_Revenue_A_kWh_51
double precision 		Net_Energy_Revenue_B_kWh_52
double precision 		Net_Energy_Revenue_C_kWh_53
double precision 		Net_Apparent_Energy_Revenue_A_kVA_54
double precision 		Net_Apparent_Energy_Revenue_B_kVA_55
double precision 		Net_Apparent_Energy_Revenue_C_kVA_56
double precision 		Import_Energy_Revenue_A_kWh_57
double precision 		Import_Energy_Revenue_B_kWh_58
double precision 		Import_Energy_Revenue_C_kWh_59
double precision 		Export_Energy_Revenue_A_kWh_60
double precision 		Export_Energy_Revenue_B_kWh_61
double precision 		Export_Energy_Revenue_C_kWh_62
double precision 		Import_Apparent_Energy_Revenue_A_kVA_63
double precision 		Import_Apparent_Energy_Revenue_B_kVA_64
double precision 		Import_Apparent_Energy_Revenue_C_kVA_65
double precision 		Export_Apparent_Energy_Revenue_A_kVA_66
double precision 		Export_Apparent_Energy_Revenue_B_kVA_67
double precision 		Export_Apparent_Energy_Revenue_C_kVA_68
double precision 		Q1_Reactive_Energy_Revenue_A_kVAR_69
double precision 		Q1_Reactive_Energy_Revenue_B_kVAR_70
double precision 		Q1_Reactive_Energy_Revenue_C_kVAR_71
double precision 		Q2_Reactive_Energy_Revenue_A_kVAR_72
double precision 		Q2_Reactive_Energy_Revenue_B_kVAR_73
double precision 		Q2_Reactive_Energy_Revenue_C_kVAR_74
double precision 		Q3_Reactive_Energy_Revenue_A_kVAR_75
double precision 		Q3_Reactive_Energy_Revenue_B_kVAR_76
double precision 		Q3_Reactive_Energy_Revenue_C_kVAR_77
double precision 		Q4_Reactive_Energy_Revenue_A_kVAR_78
double precision 		Q4_Reactive_Energy_Revenue_B_kVAR_79
double precision 		Q4_Reactive_Energy_Revenue_C_kVAR_80
double precision
2026-09-10 18:34:00 0 0 0 187.66 -3.49 187.73 120.04 207.94 528.92 -1 59.99 159.5 4 119.66 119.05 121.4 205.53 208.62 209.67 528.28 529.4 529.08 62.25 62.12 63.29 -1.65 -0.8 -1.04 62.28 62.13 63.31 -1 -1 -1 118.8 120.3 239.3 4 4 4 196.48 314856.38 314243.25 315067.09 210.73 316026.66 1783.39 573.67 1621.57 0 4478.35 2195.23 4478.35 104585.83 104509.32 105761.21 104409.03 104296.02 105538.23 104665 104564.4 105837.7 79.17 55.08 76.49 105001.13 104875.78 106149.76 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1925.05 1313.58 1239.72
2026-09-10 18:33:00 0 0 0 167.24 -2.55 167.29 119.86 207.7 460.93 -1 59.98 159.6 4 119.47 118.93 121.19 205.33 208.4 209.37 460.36 461.43 461 55.47 55.38 56.39 -1.27 -0.54 -0.75 55.49 55.39 56.41 -1 -1 -1 118.8 120.4 239.4 4 4 4 193.58 314853.38 314240.25 315064.09 210.73 316023.66 1783.39 573.67 1621.57 0 4478.3 2195.23 4478.3 104584.83 104508.33 105760.2 104408.03 104295.03 105537.2 104664 104563.41 105836.69 79.17 55.08 76.49 105000.13 104874.79 106148.73 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1925.02 1313.57 1239.7
2026-09-10 18:32:00 0 0 0 168.52 -2.56 168.57 120.02 207.83 468.69 -1 59.97 159.6 4 119.66 119.16 121.25 205.69 208.66 209.15 468.11 469.19 468.78 55.94 55.81 56.77 -1.24 -0.57 -0.75 55.96 55.82 56.79 -1 -1 -1 118.9 120.4 239.5 4 4 4 190.12 314850.66 314237.53 315061.38 210.73 316020.94 1783.39 573.67 1621.57 0 4478.25 2195.23 4478.25 104583.93 104507.43 105759.29 104407.13 104294.13 105536.29 104663.1 104562.51 105835.77 79.17 55.08 76.49 104999.23 104873.89 106147.82 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1925 1313.56 1239.69
2026-09-10 18:31:00 0 0 0 182.49 -3.04 182.55 120.16 208.17 501.57 -1 59.96 159.5 4 119.78 119.29 121.4 205.91 208.76 209.84 500.97 502.13 501.6 60.59 60.45 61.45 -1.44 -0.71 -0.88 60.61 60.46 61.47 -1 -1 -1 119 120.3 239.4 4 4 4 183.08 314847.69 314234.59 315058.41 210.73 316018 1783.39 573.67 1621.57 0 4478.2 2195.23 4478.2 104582.95 104506.45 105758.28 104406.15 104293.15 105535.3 104662.12 104561.52 105834.77 79.17 55.08 76.49 104998.25 104872.91 106146.83 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.98 1313.55 1239.67
2026-09-10 18:30:00 0 0 0 213.2 -3.99 213.27 120.44 208.68 590.3 -1 59.97 159.5 4 120.19 119.53 121.61 206.6 209.08 210.37 589.72 590.76 590.43 70.8 70.62 71.78 -1.77 -1.04 -1.18 70.83 70.64 71.81 -1 -1 -1 119 120.2 239.4 4 4 4 177.45 314844.31 314231.19 315055.03 210.73 316014.59 1783.39 573.67 1621.57 0 4478.13 2195.23 4478.13 104581.83 104505.33 105757.15 104405.03 104292.03 105534.16 104661 104560.41 105833.63 79.17 55.08 76.49 104997.13 104871.79 106145.7 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.95 1313.53 1239.65
2026-09-10 18:29:00 0 0 0 216.12 -4.42 216.2 120.46 208.71 596.9 -1 59.97 159.5 4 120.19 119.53 121.65 206.61 209.12 210.41 596.26 597.43 597.02 71.79 71.55 72.78 -1.93 -1.18 -1.31 71.83 71.57 72.8 -1 -1 -1 119 120.2 239.4 4 4 4 177.93 314840.75 314227.59 315051.47 210.73 316011 1783.39 573.67 1621.57 0 4478.06 2195.23 4478.06 104580.64 104504.15 105755.95 104403.84 104290.84 105532.95 104659.81 104559.23 105832.43 79.17 55.08 76.49 104995.94 104870.6 106144.48 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.92 1313.51 1239.63
2026-09-10 18:28:00 0 0 0 202.87 -4.14 202.95 120.09 208.06 565.26 -1 59.96 159.5 4 119.85 119.18 121.26 206.01 208.48 209.7 564.71 565.76 565.31 67.41 67.15 68.31 -1.82 -1.1 -1.22 67.45 67.17 68.33 -1 -1 -1 119 120.2 239.3 4 4 4 179.52 314837.25 314224.13 315047.97 210.73 316007.53 1783.39 573.67 1621.57 0 4478 2195.23 4478 104579.49 104503 105754.77 104402.69 104289.7 105531.79 104658.66 104558.08 105831.26 79.17 55.08 76.49 104994.79 104869.46 106143.32 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.89 1313.5 1239.61
2026-09-10 18:27:00 0 0 0 220.99 -4.29 221.07 120.18 208.21 613.79 -1 59.97 159.5 4 119.95 119.23 121.36 206.14 208.62 209.88 613.18 614.22 613.96 73.45 73.11 74.43 -1.94 -1.13 -1.22 73.49 73.13 74.45 -1 -1 -1 119 120.1 239.3 4 4 4 180.4 314833.72 314220.59 315044.44 210.73 316004 1783.39 573.67 1621.57 0 4477.93 2195.23 4477.93 104578.3 104501.82 105753.58 104401.5 104288.52 105530.58 104657.48 104556.9 105830.06 79.17 55.08 76.49 104993.6 104868.27 106142.11 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.86 1313.48 1239.59
2026-09-10 18:26:00 0 0 0 223.15 -4.2 223.22 120.28 208.33 618.23 -1 59.98 159.5 4 120.02 119.28 121.53 206.17 208.73 210.08 617.61 618.66 618.42 74.11 73.86 75.18 -1.91 -1.08 -1.2 74.14 73.87 75.2 -1 -1 -1 119 120.1 239.3 4 4 4 181.19 314829.97 314216.84 315040.69 210.73 316000.25 1783.39 573.67 1621.57 0 4477.85 2195.23 4477.85 104577.06 104500.59 105752.32 104400.27 104287.28 105529.34 104656.23 104555.66 105828.8 79.17 55.08 76.49 104992.37 104867.04 106140.87 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.82 1313.46 1239.57
2026-09-10 18:25:00 0 0 0 224.98 -4.41 225.06 120.3 208.44 623.83 -1 59.97 159.6 4 119.99 119.42 121.51 206.26 208.96 210.11 623.16 624.28 624.04 74.74 74.47 75.77 -1.96 -1.13 -1.32 74.77 74.49 75.8 -1 -1 -1 119 120.3 239.4 4 4 4 181.79 314826.25 314213.09 315036.97 210.73 315996.5 1783.39 573.67 1621.57 0 4477.78 2195.23 4477.78 104575.82 104499.35 105751.06 104399.02 104286.05 105528.08 104654.99 104554.43 105827.55 79.17 55.08 76.49 104991.13 104865.8 106139.61 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.79 1313.44 1239.55
2026-09-10 18:24:00 0 0 0 227.06 -4.5 227.13 120.45 208.72 628.5 -1 59.98 159.6 4 120.14 119.56 121.66 206.58 209.21 210.37 627.91 628.85 628.75 75.4 75.2 76.45 -1.97 -1.18 -1.36 75.44 75.22 76.47 -1 -1 -1 119 120.3 239.4 4 4 4 175.35 314822.47 314209.31 315033.19 210.73 315992.72 1783.39 573.67 1621.57 0 4477.7 2195.23 4477.7 104574.57 104498.1 105749.8 104397.77 104284.8 105526.8 104653.74 104553.18 105826.28 79.17 55.08 76.49 104989.88 104864.56 106138.34 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.76 1313.42 1239.53
2026-09-10 18:23:00 0 0 0 208.32 -3.87 208.38 120.49 208.61 575.03 -1 59.98 159.6 4 120.13 119.69 121.64 206.69 209.25 209.9 574.25 575.59 575.26 69.18 69.05 70.09 -1.7 -0.98 -1.2 69.21 69.06 70.11 -1 -1 -1 119 120.2 239.5 4 4 4 170.6 314819.06 314205.94 315029.78 210.73 315989.34 1783.39 573.67 1621.57 0 4477.64 2195.23 4477.64 104573.44 104496.98 105748.64 104396.64 104283.66 105525.66 104652.61 104552.05 105825.13 79.17 55.08 76.49 104988.74 104863.42 106137.19 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.73 1313.4 1239.51
2026-09-10 18:22:00 0 0 0 205.62 -4.02 205.7 120.36 208.52 562.2 -1 59.98 159.5 4 119.99 119.49 121.6 206.34 209.04 210.19 561.56 562.68 562.36 68.26 68.12 69.24 -1.78 -1.02 -1.22 68.3 68.14 69.26 -1 -1 -1 119 120.3 239.5 4 4 4 166.67 314815.59 314202.44 315026.31 210.73 315985.84 1783.39 573.67 1621.57 0 4477.57 2195.23 4477.57 104572.27 104495.82 105747.48 104395.48 104282.52 105524.48 104651.45 104550.9 105823.96 79.17 55.08 76.49 104987.58 104862.27 106136.01 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.7 1313.39 1239.49
2026-09-10 18:21:00 0 0 0 194.21 -3.42 194.26 120.23 208.21 537.71 -1 59.98 159.6 4 119.89 119.35 121.44 206.2 208.85 209.58 537.19 538.13 537.8 64.45 64.35 65.39 -1.54 -0.84 -1.04 64.49 64.37 65.41 -1 -1 -1 119 120.3 239.5 4 4 4 163.46 314812.19 314199.06 315022.91 210.73 315982.47 1783.39 573.67 1621.57 0 4477.51 2195.23 4477.51 104571.16 104494.7 105746.34 104394.36 104281.4 105523.34 104650.33 104549.77 105822.82 79.17 55.08 76.49 104986.46 104861.16 106134.88 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.67 1313.37 1239.47
2026-09-10 18:20:00 0 0 0 102.79 -0.89 102.83 119.47 206.87 295.92 -1 59.96 159.6 4 119.1 118.61 120.69 204.81 207.63 208.18 295.44 296.46 295.85 34.11 34.06 34.62 -0.56 -0.12 -0.21 34.12 34.07 34.63 -1 -1 -1 119 120.3 239.5 4 4 4 164.95 314809.31 314196.19 315020.03 210.73 315979.59 1783.39 573.67 1621.57 0 4477.46 2195.23 4477.46 104570.2 104493.74 105745.36 104393.41 104280.44 105522.37 104649.38 104548.82 105821.84 79.17 55.08 76.49 104985.51 104860.2 106133.9 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.65 1313.36 1239.45
2026-09-10 18:19:00 0 0 0 184.65 -3.42 184.71 120.01 207.96 525.25 -1 59.98 159.6 4 119.7 119.07 121.29 205.77 208.46 209.66 524.59 525.67 525.47 61.28 61.15 62.22 -1.56 -0.86 -1 61.31 61.17 62.24 -1 -1 -1 119 120.3 239.4 4 4 4 162.63 314807.25 314194.09 315017.97 210.73 315977.5 1783.39 573.67 1621.57 0 4477.43 2195.23 4477.43 104569.52 104493.06 105744.66 104392.72 104279.76 105521.67 104648.69 104548.14 105821.15 79.17 55.08 76.49 104984.82 104859.52 106133.2 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.64 1313.35 1239.44
2026-09-10 18:18:00 0 0 0 103.07 -0.93 103.1 119.37 206.85 295.86 -1 59.98 159.6 4 118.95 118.38 120.77 204.41 207.56 208.57 295.34 296.38 295.86 34.16 34.15 34.76 -0.61 -0.1 -0.22 34.17 34.16 34.77 -1 -1 -1 118.9 120.4 239.4 4 4 4 164.15 314804.47 314191.34 315015.19 210.73 315974.75 1783.39 573.67 1621.57 0 4477.39 2195.23 4477.39 104568.59 104492.15 105743.73 104391.8 104278.84 105520.74 104647.77 104547.23 105820.22 79.17 55.08 76.49 104983.9 104858.59 106132.27 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.61 1313.34 1239.43
2026-09-10 18:17:00 0 0 0 118.56 -1.22 118.59 119.42 206.85 316.03 -1 59.98 159.5 4 118.97 118.44 120.83 204.29 207.67 208.58 315.48 316.54 316.06 39.31 39.24 40 -0.76 -0.16 -0.3 39.33 39.25 40.01 -1 -1 -1 118.7 120.4 239.3 4 4 4 165.64 314802.47 314189.31 315013.19 210.73 315972.72 1783.39 573.67 1621.57 0 4477.36 2195.23 4477.36 104567.92 104491.47 105743.05 104391.13 104278.17 105520.05 104647.09 104546.55 105819.53 79.17 55.08 76.49 104983.23 104857.93 106131.59 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.6 1313.34 1239.42
2026-09-10 18:16:00 0 0 0 100.49 -0.83 100.52 119.39 206.84 270.5 -1 59.99 159.5 4 118.98 118.4 120.8 204.39 207.59 208.55 270 271.06 270.45 33.31 33.28 33.9 -0.58 -0.07 -0.18 33.33 33.28 33.91 -1 -1 -1 118.8 120.4 239.3 4 4 4 173.09 314800.5 314187.34 315011.22 210.73 315970.75 1783.39 573.67 1621.57 0 4477.34 2195.23 4477.34 104567.27 104490.82 105742.39 104390.47 104277.52 105519.39 104646.45 104545.9 105818.88 79.17 55.08 76.49 104982.57 104857.27 106130.92 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.59 1313.33 1239.42
2026-09-10 18:15:00 0 0 0 98 -0.68 98.03 119.37 206.77 266.76 -1 59.96 159.5 4 118.87 118.43 120.81 204.2 207.63 208.47 266.41 267.31 266.55 32.5 32.47 33.03 -0.55 0.02 -0.14 32.51 32.48 33.04 -1 1 -1 118.7 120.4 239.3 4 1 4 173.94 314799.03 314185.88 315009.75 210.73 315969.28 1783.39 573.67 1621.57 0 4477.32 2195.23 4477.32 104566.78 104490.34 105741.89 104389.98 104277.02 105518.89 104645.95 104545.41 105818.38 79.17 55.08 76.49 104982.08 104856.78 106130.42 592.1 579.76 611.53 112.06 160.92 300.69 529.54 535.51 556.52 0 0 0 1924.58 1313.33 1239.41