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 tbl001EC6053093_51 tbl001EC6053093_52 tbl001EC6053093_53 tbl001EC6053093_54 tbl001EC6053093_55 tbl001EC6053093_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

dl_meter_device_data

id
integer 		time
timestamp without time zone 		serial_number
character varying 		device_id
character varying 		sd_id
character varying 		Net Energy (kwh) 1
double precision 		Import Energy (kwh) 2
double precision 		Export Energy (kwh) 3
double precision
180043 2026-04-16 20:15:00 001EC6053093 9 001EC6053093_9 376651 379434.813 2783.801
180042 2026-04-16 20:14:00 001EC6053093 9 001EC6053093_9 376649.156 379432.969 2783.801
180041 2026-04-16 20:13:00 001EC6053093 9 001EC6053093_9 376647.406 379431.219 2783.801
180040 2026-04-16 20:12:00 001EC6053093 9 001EC6053093_9 376645.813 379429.625 2783.801
180039 2026-04-16 20:11:00 001EC6053093 9 001EC6053093_9 376644.063 379427.875 2783.801
180038 2026-04-16 20:10:00 001EC6053093 9 001EC6053093_9 376642.313 379426.125 2783.801
180037 2026-04-16 20:09:00 001EC6053093 9 001EC6053093_9 376640.5 379424.313 2783.801
180036 2026-04-16 20:08:00 001EC6053093 9 001EC6053093_9 376638.688 379422.5 2783.801
180035 2026-04-16 20:07:00 001EC6053093 9 001EC6053093_9 376636.719 379420.531 2783.801
180034 2026-04-16 20:06:00 001EC6053093 9 001EC6053093_9 376635.313 379419.125 2783.801
180033 2026-04-16 20:05:00 001EC6053093 9 001EC6053093_9 376633.844 379417.656 2783.801
180032 2026-04-16 20:04:00 001EC6053093 9 001EC6053093_9 376632.125 379415.938 2783.801
180031 2026-04-16 20:03:00 001EC6053093 9 001EC6053093_9 376629.875 379413.688 2783.801
180030 2026-04-16 20:02:00 001EC6053093 9 001EC6053093_9 376626.969 379410.781 2783.801
180029 2026-04-16 20:01:00 001EC6053093 9 001EC6053093_9 376623.875 379407.688 2783.801
180028 2026-04-16 20:00:00 001EC6053093 9 001EC6053093_9 376620.875 379404.688 2783.801
180027 2026-04-16 19:59:00 001EC6053093 9 001EC6053093_9 376617.75 379401.563 2783.801
180026 2026-04-16 19:58:00 001EC6053093 9 001EC6053093_9 376614.938 379398.75 2783.801
180025 2026-04-16 19:57:00 001EC6053093 9 001EC6053093_9 376612.281 379396.094 2783.801
180024 2026-04-16 19:56:00 001EC6053093 9 001EC6053093_9 376609.375 379393.188 2783.801
180023 2026-04-16 19:55:00 001EC6053093 9 001EC6053093_9 376606.813 379390.625 2783.801
180022 2026-04-16 19:54:00 001EC6053093 9 001EC6053093_9 376604 379387.813 2783.801
180021 2026-04-16 19:53:00 001EC6053093 9 001EC6053093_9 376600.875 379384.688 2783.801
180020 2026-04-16 19:52:00 001EC6053093 9 001EC6053093_9 376597.5 379381.313 2783.801
180019 2026-04-16 19:51:00 001EC6053093 9 001EC6053093_9 376594.406 379378.219 2783.801
180018 2026-04-16 19:50:00 001EC6053093 9 001EC6053093_9 376592.125 379375.938 2783.801
180017 2026-04-16 19:49:00 001EC6053093 9 001EC6053093_9 376590.313 379374.125 2783.801
180016 2026-04-16 19:48:00 001EC6053093 9 001EC6053093_9 376588.625 379372.438 2783.801
180015 2026-04-16 19:47:00 001EC6053093 9 001EC6053093_9 376586.938 379370.75 2783.801
180014 2026-04-16 19:46:00 001EC6053093 9 001EC6053093_9 376585.25 379369.063 2783.801
180013 2026-04-16 19:45:00 001EC6053093 9 001EC6053093_9 376583.625 379367.438 2783.801
180012 2026-04-16 19:44:00 001EC6053093 9 001EC6053093_9 376582 379365.813 2783.801
180011 2026-04-16 19:43:00 001EC6053093 9 001EC6053093_9 376580.469 379364.281 2783.801
180010 2026-04-16 19:42:00 001EC6053093 9 001EC6053093_9 376578.938 379362.75 2783.801
180009 2026-04-16 19:41:00 001EC6053093 9 001EC6053093_9 376577.375 379361.188 2783.801
180008 2026-04-16 19:40:00 001EC6053093 9 001EC6053093_9 376575.813 379359.625 2783.801
180007 2026-04-16 19:39:00 001EC6053093 9 001EC6053093_9 376574.281 379358.094 2783.801
180006 2026-04-16 19:38:00 001EC6053093 9 001EC6053093_9 376572.563 379356.375 2783.801
180005 2026-04-16 19:37:00 001EC6053093 9 001EC6053093_9 376570.781 379354.594 2783.801
180004 2026-04-16 19:36:00 001EC6053093 9 001EC6053093_9 376569 379352.813 2783.801
180003 2026-04-16 19:35:00 001EC6053093 9 001EC6053093_9 376567.031 379350.844 2783.801
180002 2026-04-16 19:34:00 001EC6053093 9 001EC6053093_9 376565.063 379348.875 2783.801
180001 2026-04-16 19:33:00 001EC6053093 9 001EC6053093_9 376562.531 379346.344 2783.801
180000 2026-04-16 19:32:00 001EC6053093 9 001EC6053093_9 376559.75 379343.563 2783.801
179999 2026-04-16 19:31:00 001EC6053093 9 001EC6053093_9 376557.5 379341.313 2783.801
179998 2026-04-16 19:30:00 001EC6053093 9 001EC6053093_9 376555.625 379339.438 2783.801
179997 2026-04-16 19:29:00 001EC6053093 9 001EC6053093_9 376553.844 379337.656 2783.801
179996 2026-04-16 19:28:00 001EC6053093 9 001EC6053093_9 376552.156 379335.969 2783.801
179995 2026-04-16 19:27:00 001EC6053093 9 001EC6053093_9 376550.406 379334.219 2783.801
179994 2026-04-16 19:26:00 001EC6053093 9 001EC6053093_9 376548.625 379332.438 2783.801
179993 2026-04-16 19:25:00 001EC6053093 9 001EC6053093_9 376546.875 379330.688 2783.801
179992 2026-04-16 19:24:00 001EC6053093 9 001EC6053093_9 376545.219 379329.031 2783.801
179991 2026-04-16 19:23:00 001EC6053093 9 001EC6053093_9 376543.313 379327.125 2783.801
179990 2026-04-16 19:22:00 001EC6053093 9 001EC6053093_9 376541.438 379325.25 2783.801
179989 2026-04-16 19:21:00 001EC6053093 9 001EC6053093_9 376539.781 379323.594 2783.801
179988 2026-04-16 19:20:02 001EC6053093 9 001EC6053093_9 376538.063 379321.875 2783.801
179987 2026-04-16 19:19:00 001EC6053093 9 001EC6053093_9 376536.125 379319.938 2783.801
179986 2026-04-16 19:18:00 001EC6053093 9 001EC6053093_9 376534.188 379318 2783.801
179985 2026-04-16 19:17:00 001EC6053093 9 001EC6053093_9 376532.094 379315.906 2783.801
179984 2026-04-16 19:16:00 001EC6053093 9 001EC6053093_9 376530.219 379314.031 2783.801
179983 2026-04-16 19:15:00 001EC6053093 9 001EC6053093_9 376528.375 379312.188 2783.801
179982 2026-04-16 19:14:00 001EC6053093 9 001EC6053093_9 376526.438 379310.25 2783.801
179981 2026-04-16 19:13:00 001EC6053093 9 001EC6053093_9 376524.625 379308.438 2783.801
179980 2026-04-16 19:12:00 001EC6053093 9 001EC6053093_9 376522.813 379306.625 2783.801
179979 2026-04-16 19:11:00 001EC6053093 9 001EC6053093_9 376521.031 379304.844 2783.801
179978 2026-04-16 19:10:00 001EC6053093 9 001EC6053093_9 376519.219 379303.031 2783.801
179977 2026-04-16 19:09:00 001EC6053093 9 001EC6053093_9 376517.5 379301.313 2783.801
179976 2026-04-16 19:08:00 001EC6053093 9 001EC6053093_9 376515.813 379299.625 2783.801
179975 2026-04-16 19:07:00 001EC6053093 9 001EC6053093_9 376514 379297.813 2783.801
179974 2026-04-16 19:06:00 001EC6053093 9 001EC6053093_9 376512.125 379295.938 2783.801
179973 2026-04-16 19:05:00 001EC6053093 9 001EC6053093_9 376510.313 379294.125 2783.801
179972 2026-04-16 19:04:00 001EC6053093 9 001EC6053093_9 376508.531 379292.344 2783.801
179971 2026-04-16 19:03:00 001EC6053093 9 001EC6053093_9 376506.813 379290.625 2783.801
179970 2026-04-16 19:02:00 001EC6053093 9 001EC6053093_9 376505.063 379288.875 2783.801
179969 2026-04-16 19:01:00 001EC6053093 9 001EC6053093_9 376503.219 379287.031 2783.801
179968 2026-04-16 19:00:00 001EC6053093 9 001EC6053093_9 376501.313 379285.125 2783.801
179967 2026-04-16 18:59:00 001EC6053093 9 001EC6053093_9 376499.438 379283.25 2783.801
179966 2026-04-16 18:58:00 001EC6053093 9 001EC6053093_9 376497.531 379281.344 2783.801
179965 2026-04-16 18:57:00 001EC6053093 9 001EC6053093_9 376495.531 379279.344 2783.801
179964 2026-04-16 18:56:00 001EC6053093 9 001EC6053093_9 376493.469 379277.281 2783.801
179963 2026-04-16 18:55:00 001EC6053093 9 001EC6053093_9 376491.344 379275.156 2783.801
179962 2026-04-16 18:54:00 001EC6053093 9 001EC6053093_9 376489.188 379273 2783.801
179961 2026-04-16 18:53:00 001EC6053093 9 001EC6053093_9 376487 379270.813 2783.801
179960 2026-04-16 18:52:00 001EC6053093 9 001EC6053093_9 376484.813 379268.625 2783.801
179959 2026-04-16 18:51:00 001EC6053093 9 001EC6053093_9 376482.406 379266.219 2783.801
179958 2026-04-16 18:50:00 001EC6053093 9 001EC6053093_9 376479.938 379263.75 2783.801
179957 2026-04-16 18:49:00 001EC6053093 9 001EC6053093_9 376477.406 379261.219 2783.801
179956 2026-04-16 18:48:00 001EC6053093 9 001EC6053093_9 376474.906 379258.719 2783.801
179955 2026-04-16 18:47:00 001EC6053093 9 001EC6053093_9 376472.5 379256.313 2783.801
179954 2026-04-16 18:46:00 001EC6053093 9 001EC6053093_9 376470 379253.813 2783.801
179953 2026-04-16 18:45:00 001EC6053093 9 001EC6053093_9 376467.656 379251.469 2783.801
179952 2026-04-16 18:44:00 001EC6053093 9 001EC6053093_9 376465.438 379249.25 2783.801
179951 2026-04-16 18:43:00 001EC6053093 9 001EC6053093_9 376463.25 379247.063 2783.801
179950 2026-04-16 18:42:00 001EC6053093 9 001EC6053093_9 376461.25 379245.063 2783.801
179949 2026-04-16 18:41:00 001EC6053093 9 001EC6053093_9 376459.313 379243.125 2783.801
179948 2026-04-16 18:40:00 001EC6053093 9 001EC6053093_9 376457.25 379241.063 2783.801
179947 2026-04-16 18:39:00 001EC6053093 9 001EC6053093_9 376455.031 379238.844 2783.801
179946 2026-04-16 18:38:00 001EC6053093 9 001EC6053093_9 376452.625 379236.438 2783.801
179945 2026-04-16 18:37:00 001EC6053093 9 001EC6053093_9 376450 379233.813 2783.801
179944 2026-04-16 18:36:00 001EC6053093 9 001EC6053093_9 376447.438 379231.25 2783.801