{"repo":"postgrespro/pg_query_state","free":true,"listed":false,"github":"https://github.com/postgrespro/pg_query_state","clone":"git clone https://github.com/postgrespro/pg_query_state.git","description":"Tool for query progress monitoring in PostgreSQL","language":"C","stars":160,"topics":["postgresql","query-monitoring"],"license":null,"category":"databases-storage","readme_excerpt":"pg\\ query\\ state The pg query state module provides facility to know the current state of query execution on working backend. To enable this extension you have to patch the stable version of PostgreSQL, recompile it and deploy new binaries. All patch files are located in patches/ directory and tagged with suffix of PostgreSQL version number. Overview Each nonutility query statement (SELECT/INSERT/UPDATE/DELETE) after optimization/planning stage is translated into plan tree which is kind of imperative representation of SQL query execution algorithm. EXPLAIN ANALYZE request allows to demonstrate execution statistics gathered from each node of plan tree (full time of execution, number rows emitted to upper nodes, etc). But this statistics is collected after execution of query. This module allows to show actual statistics of query running gathered from external backend. At that, format of resulting output is almost identical to ordinal EXPLAIN ANALYZE. Thus users are able to track of query execution in progress. In fact, this module is able to explore external backend and determine its actual state. Particularly it's helpful when backend executes a heavy query and gets stuck. Use cases Using this module there can help in the following things: - detect a long query (along with other monitoring tools) - overwatch the query execution Installation To install pg query state , please apply corresponding patches custom signal (PG VERSION).patch and runtime explain (PG VERSION).patch (or","default_branch":null,"files":null,"tree":[],"storefront":"/r/postgrespro","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/postgrespro/pg_query_state/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}