Simon Martín simon-contreras-deel

Cheatsheet: PostgreSQL Monitoring

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

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;

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

	--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