# pg_querylog

**Repository Path**: mirrors_adjust/pg_querylog

## Basic Information

- **Project Name**: pg_querylog
- **Description**: Show queries running on PostgreSQL backends
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-08
- **Last Updated**: 2026-05-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

[![Build Status](https://travis-ci.org/adjust/pg_querylog.svg?branch=master)](https://travis-ci.org/adjust/pg_querylog)

pg_querylog
===========

Show queries running on PostgreSQL backends.

Installation
------------

	make && make install
	echo "shared_preload_libraries='pg_querylog'" >> postgresql.conf
	psql postgres -c "create schema querylog; create extension pg_querylog schema querylog;"
	
Also you can use `session_preload_libraries`, but then `enabled` option should be always `on` since each starting
backend will rewrite the value.

	echo "session_preload_libraries='pg_querylog'" >> postgresql.conf

Using
-----

Make sure it's loaded:

	show session_preload_libraries

and enabled (by default it is disabled):

	show pg_querylog.enabled

Get all saved queries using `get_queries` function:

	select * from querylog.get_queries()

Result columns:

* `pid` - backend process ID
* `query` - running (or runned) query
* `params` - query parameters in case of parametrized query
* `start_time` - query start time
* `end_time` - query end time (if `running` == false)
* `running` - running status
* `overflow` - shows that `buffer_size` is enough for this item

Parameters:

* `pg_querylog.buffer_size` - buffer size for each saved query, calculated as sum of lenghts of query and its params.
* `pg_querylog.enabled` - controls saving queries.

For only running queries `running_queries` use this view:

	select * from querylog.running_queries;