CODEWITHSUNDEEP
javascriptnode.jspostgresqlbookshelf.jsknex.js
Andre Pena
Andre Pena

Reputation: 59336

How can I have a live view of queries being executed on Postgres?

I'm building an application on Node, Bookshelf and Knex and for learning and performance reasons I'd like to see what queries are being executed live on Postgres.

How can I do it? I'm not paricularly interested in a profiler if that means the queries will be stored on log files. I just want to see what is happening right now.

Possible solutions:

Unfortunately I searched Google to no avail.

Upvotes: 1

Views: 1647

Answers (1)

Patrick
Patrick

Reputation: 32199

If you want to see this live information on a tool outside of your application, your best bet is pgAdmin III: connect to the server of interest and then select Tools | Server Status. This, incidentally, will also show you the server log which is extremely useful when building applications because it gives you immediate access to errors at the PG server.

Upvotes: 1

Related Questions