dgaubert

Cheatsheet: PostgreSQL Monitoring

To query these metrics, you must be logged into PostgreSQL as a user that has read access to pg_stat_database

Useful psql commands

• Check version of PostgreSQL: SELECT version();
• Show location of postgresql.conf file (requires superuser privileges): SHOW config_file;
• Show location of data directory (requires superuser privileges): SHOW data_directory;
• Show location of log directory (may be a path relative to data directory, requires superuser privileges): SHOW log_directory;

clhenrick

PostgreSQL & PostGIS Cheatsheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.

TOC

• Installing Postgres & PostGIS
• Using Postgres on the command line: PSQL
• Importing Data into Postgres
• Exporting Data from Postgres
• Joining Tables

listochkin

  --log_gc (Log heap samples on garbage collection for the hp2ps tool.)
        type: bool  default: false
  --expose_gc (expose gc extension)
        type: bool  default: false
  --max_new_space_size (max size of the new generation (in kBytes))
        type: int  default: 0
  --max_old_space_size (max size of the old generation (in Mbytes))
        type: int  default: 0
  --max_executable_size (max size of executable memory (in Mbytes))
        type: int  default: 0