Search code examples
node.jspostgresqlpg-promise

Log specific postgresql query using pg-promise


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

Solution

  • 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);