I want to understand a database layout.

It has 180 tables.

I only know the high level use case: Owncloud (File Hosting Server. Can be compared to DropBox).

How to understand the database layout?

How to identify the most important tables?

Is there a tool which helps me to understand the layout?

At the moment am interested in two facts:

  • ForeignKey Relations: It would be nice to have graph
  • Number of rows in the table.

I use PostgreSQL 9.5.5


SchemaSpy is a free piece of software that enables you to output html documentation of your databases, one of the many vendors it supports is PostgreSQL.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.