Document how the Promscale SQL data are stored in the PostgreSQL database
It would be very handy to provide us with some good visual representation of how exactly the SQL data are stored in the PostgreSQL database (also clarifying relations between them) so that writting complex SQL queries become less painful and more obvious. Thank you.
Thank you for the feedback. I agree, a visual representation is something that is helpful to understand the promscale SQL arch better and will be useful in writing queries.
cc @cevian
@mjf We have recently added documentation on SQL schema for metrics. Below are the docs pages created for same:
- https://github.com/timescale/promscale/blob/master/docs/sql_schema.md#data-model-schema
- https://github.com/timescale/promscale/blob/master/docs/data-model.md
Would appreciate your feedback on docs. Also, if the docs offer the information that the issue expects, feel free to close the issue. :)