Log specific postgresql query using pg-promise

Question

I am using pg-promise package with Nodejs to execute PostgreSQL queries. I want to see the queries executed. Only specific queries, say, just one query that I want to debug.

I can see that one recommended way is to use the pg-monitor to catch the events and log them as mentioned here in the examples documentation.

Without using pg-monitor, is there a simple way to just print the prepared query that is executed. I can't see it in the docs.

Example:

db.query("SELECT * FROM table WHERE id = $/id/", {id: 2})

How to print this query to yield?

SELECT * FROM table WHERE id = 2

vitaly-t · Accepted Answer · 2021-05-23 14:22:32Z

27

is there a simple way to just print the prepared query that is executed...

A query in general - yes, see below. A Prepared Query - no, those are by definition formatted on the server-side.

const query = pgp.as.format('SELECT * FROM table WHERE id = $/id/', {id: 2});
console.log(query);
await db.any(query);

And if you want to print all queries executed by your module, without using pg-monitor, simply add event query handler when initializing the library:

const initOptions = {
  query(e) {
    console.log(e.query);
  }
};
const pgp = require('pg-promise')(initOptions);

edited May 23, 2021 at 14:22

answered May 4, 2017 at 11:54

vitaly-t

26.1k18 gold badges129 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mythicalcoder Over a year ago

The options is awesome. I am yet to explore it fully. Thanks.

mythicalcoder Over a year ago

not sure this question might be related to options - for quicker visibility commenting here. Pl check. Thanks - stackoverflow.com/questions/65152018/…

PirateApp Over a year ago

when I see a library with too many open issues I often go and tell them "maybe you should manage a library like vitaly-t" first

Collectives™ on Stack Overflow

Log specific postgresql query using pg-promise

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related