pg-monitor | : computer : Events monitor for pg-promise | Runtime Evironment library

by vitaly-t JavaScript Version: 2.1.0 License: MIT

X-Ray Key Features Code Snippets Community Discussions(2)Vulnerabilities Install Support

kandi X-RAY | pg-monitor Summary

pg-monitor is a JavaScript library typically used in Server, Runtime Evironment, Nodejs applications. pg-monitor has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can install using 'npm i pg-monitor' or download it from GitHub, npm.

This library takes the flexible event system provided by [pg-promise] and outputs it on screen, with full details available, and in the most informative way. Its purpose is to give you the full picture of how the database is used in your application, providing full details with the context, such as tasks and transactions in which queries are executed. In addition, it simplifies [events logging] #log) for your application.

Support

Quality

Security

License

Reuse

Support

pg-monitor has a low active ecosystem.

It has 145 star(s) with 3 fork(s). There are 3 watchers for this library.

There were 1 major release(s) in the last 12 months.

There are 0 open issues and 24 have been closed. On average issues are closed in 71 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of pg-monitor is 2.1.0

Quality

pg-monitor has 0 bugs and 0 code smells.

Security

pg-monitor has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

pg-monitor code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

pg-monitor is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

pg-monitor releases are available to install and integrate.

Deployable package is available in npm.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi has reviewed pg-monitor and discovered the below as its top functions. This is intended to give you an instant insight into pg-monitor implemented functionality, and help decide if they suit your requirements.

Print a message .
Gets the tag name from the given event object .
Format a duration in milliseconds .
Writes data to a JSON string .
Pads value with zeros
Remove colors from text
Format a time object .
Determine if value is null

Get all kandi verified functions for this library.

pg-monitor Key Features

No Key Features are available at this moment for pg-monitor.

pg-monitor Examples and Code Snippets

No Code Snippets are available at this moment for pg-monitor.

Community Discussions

Trending Discussions on pg-monitor

Log specific postgresql query using pg-promise

Get executed SQL statement from pgPromise query result

QUESTION

Log specific postgresql query using pg-promise

Asked 2018-Nov-18 at 15:51

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:

...

ANSWER

Answered 2018-Jun-18 at 17:37

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.

Source https://stackoverflow.com/questions/43780737

QUESTION

Get executed SQL statement from pgPromise query result

Asked 2018-Apr-02 at 16:52

I'm writing an API that does queries over multiple postgres databases using node and pg-promise.

I'm interested in getting the executed SQL statement from query result. Something like pg-monitor outputs to console. I've set up pg-monitor and noticed there is a setLog method which I can use to get the data I need, but it would be perfect if I could get the same data from the place I'm executing the query from.

Point of this would be to enable the API to return both the query results and the metadata like the executed SQL. Is this possible? Thanks!

...

ANSWER

Answered 2018-Apr-02 at 16:52

it would be perfect if I could get the same data from the place I'm executing the query from.

In this case you can format the query yourself, log it and then pass it into the query method:

Source https://stackoverflow.com/questions/44096522

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install pg-monitor

You can install using 'npm i pg-monitor' or download it from GitHub, npm.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: