PostgreSQL manager recommendations

[79wjd]

Is there a good manager for PostgreSQL that allows you to see what commands are running and a debugging tool (like SQL Server Profiler)? It could be free or cost money, but it has to work with the open source version of PostgreSQL. EnterpriseDB has something similar, but it uses a proprietary version of PostgreSQL. 

[79wjd]

1 hour ago, Name Taken said:

I usually just spin up an Adminer Docker container as part of a Docker Compose stack with a link to the PostgreSQL container and bound to localhost.

I was hoping for something a bit more official as it's going to be used in an enterprise environment. I'll be honest, I don't really understand what I'm trying to find as I have no experience with anything SQL, but I need to find a manager that's somewhat comparable (mainly the profiler) to the SQL Server manager. 

[leadeater]

10 hours ago, djdwosk97 said:

I was hoping for something a bit more official as it's going to be used in an enterprise environment. I'll be honest, I don't really understand what I'm trying to find as I have no experience with anything SQL, but I need to find a manager that's somewhat comparable (mainly the profiler) to the SQL Server manager. 

Sorry to be completely unhelpful but there is a really nice tool which I have seen in the past but damned if I can remember it's name. Will let you know if I can find it.

 

Edit: Is this the sort of thing you are looking for? EMS SQL Manager for PostgreSQL.

Also this may be helpful, https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

[79wjd]

On 7/7/2016 at 9:54 PM, leadeater said:

Sorry to be completely unhelpful but there is a really nice tool which I have seen in the past but damned if I can remember it's name. Will let you know if I can find it.

 

Edit: Is this the sort of thing you are looking for? EMS SQL Manager for PostgreSQL.

Also this may be helpful, https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

Sorry, I didn't see your edit. 

 

I looked over that list before I made this thread, but it doesn't really mean much to me. As I said, I don't really know what it is that I'm looking for since I have no experience with SQL. All I know is that I need something similar to SQLServer's profiler (which can see what lines of code are being run on the server -- see how long they take, what kind of resources they use, etc...) in order to facilitate debugging. 

[Deathfean]

this might be what you are looking for http://www.valentina-db.com/en/

[leadeater]

4 hours ago, Deathfean said:

this might be what you are looking for http://www.valentina-db.com/en/

Looks nice but isn't quite what SQL Server Profiler can do. This lets you create and debug your own queries but what SQL Server Profiler allows you to do is debug and analyse what other people are executing on the database engine. This is very useful for diagnosing slow performance, columns required to create an index, or just find out what an application is doing or who/what is talking to the database server and what are they doing.

 

Valentina Studio is more akin to SQL Management Studio.

[leadeater]

@djdwosk97 I think EMS SQL Manager for PostgreSQL is what you are after, or as close as I can find. It has a feature called SQL Monitor which is very similar.

 

http://www.sqlmanager.net/en/products/postgresql/manager/documentation/hs9190.html

http://www.sqlmanager.net/en/products/postgresql/manager/documentation/hs9192.html

 

Edit: Also are you sure you can't use EnterpriseDB Postgres Enterprise Manager, looks to me it can manage both native and their own Postgre database engine, with a fair bit of show horning to get it to work on the comunity edition.

http://www.enterprisedb.com/products-services-training/products/postgres-enterprise-manager

 

Quote

Q. Does the SQL Profiler work on community PostgreSQL versions?

 

A. The SQL Profiler only works on the EnterpriseDB packaged distribution of PostgreSQL. We will support other distributions of PostgreSQL but you will need our assistance in creating a SQL Profiler binary that is compatible with the running server or it may fail to load or even crash the server. Third party distributions of PostgreSQL may use different build settings or use different compilers which could cause binary incompatibilities, so its important to work with our team for a trouble free installation.

 

[79wjd]

54 minutes ago, leadeater said:

@djdwosk97 I think EMS SQL Manager for PostgreSQL is what you are after, or as close as I can find. It has a feature called SQL Monitor which is very similar.

 

http://www.sqlmanager.net/en/products/postgresql/manager/documentation/hs9190.html

http://www.sqlmanager.net/en/products/postgresql/manager/documentation/hs9192.html

 

Edit: Also are you sure you can't use EnterpriseDB Postgres Enterprise Manager, looks to me it can manage both native and their own Postgre database engine, with a fair bit of show horning to get it to work on the comunity edition.

http://www.enterprisedb.com/products-services-training/products/postgres-enterprise-manager

 

 

EMS SQL Manager only logs statements that you have run through the manager it doesn't log everything that's running on the server. 

 

As for EnterpriseDB, I was told (by my boss, so it's possible he was mistaken) that it only worked with EDB's version of PostgreSQL. I'll look more into that and see if I can figure anything out. 

[79wjd]

@leadeater I just called EnterpriseDB and you can use the opensource version of PostgreSQL, but it requires the purchase of a subscription (based on the #of cores, whether or not the system is virtualized, etc...). So it probably wouldn't be much cheaper than Microsoft's SQL Server at the end of the day (which is why they switched to PostgreSQL in the first place). 

[leadeater]

2 minutes ago, djdwosk97 said:

@leadeater I just called EnterpriseDB and you can use the opensource version of PostgreSQL, but it requires the purchase of a subscription (based on the #of cores, whether or not the system is virtualized, etc...). So it probably wouldn't be much cheaper than Microsoft's SQL Server at the end of the day (which is why they switched to PostgreSQL in the first place). 

Well that sucks, personally I really like Microsoft SQL so my knowledge of other database engines is rather limited.

[79wjd]

3 minutes ago, leadeater said:

Well that sucks, personally I really like Microsoft SQL so my knowledge of other database engines is rather limited.

AFAIK the only reason they switched to PostgreSQL was because Microsoft SQL was becoming stupidly expensive (seven figures range).