Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Pgbadger Feature In Postgresql

1. pgBadger reports everything about your SQL queries
           Overall statistics
           The most frequent waiting queries.
           Queries that waited the most.
           Queries generating the most temporary files.
           Queries generating the largest temporary files.
           The slowest queries.
           Queries that took up the most time.
           The most frequent queries.
           The most frequent errors.
           Histogram of query times.
           Histogram of sessions times.
           Users involved in top queries.
           Applications involved in top queries.
           Queries generating the most cancellation.
           Queries most cancelled.

 2. The following reports are also available with hourly charts divided into periods of five minutes:
            SQL queries statistics.
           Temporary file statistics.
           Checkpoints statistics.
           Autovacuum and autoanalyze statistics.
           Cancelled queries.
           Error events (panic, fatal, error and warning).

 3. There are also some pie charts about distribution of:
            Locks statistics.
           Queries by type (select/insert/update/delete).
           Distribution of queries type per database/application
           Sessions per database/user/client/application.
           Connections per database/user/client/application.
           Autovacuum and autoanalyze per table.
           Queries per user and total duration per user.

    All charts are zoomable and can be saved as PNG images. SQL queries
   reported are highlighted and beautified automatically.

 4. pgBadger is also able to parse pgbouncer log files and to create the
   following reports:
           Request Throughput
           Bytes I/O Throughput
           Queries Average duration
           Simultaneous sessions
           Histogram of sessions times
           Sessions per database
           Sessions per user
           Sessions per host
           Established connections
           Connections per database
           Connections per user
           Connections per host
           Most used reserved pools
           Most Frequent Errors/Events

    You can also have incremental reports with one report per day and a
   cumulative report per week. Two multiprocess modes are available to
   speed up log parsing, one using one core per log file, and the second
   using multiple cores to parse a single file. These modes can be

    Histogram granularity can be adjusted using the -A command line option.
   By default they will report the mean of each top queries/errors occuring
   per hour, but you can specify the granularity down to the minute.

    pgBadger can also be used in a central place to parse remote log files
   using a passwordless SSH connection. This mode can be used with
   compressed files and in the multiprocess per file mode (-J) but can not
   be used with the CSV log format


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

PostgreSQL Monitoring Tools

PostgreSQL pgBadger