init.sql

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION pg_query_state" to load this file. \quit

CREATE FUNCTION pg_query_state(pid 		integer
							 , verbose	boolean = FALSE
							 , costs 	boolean = FALSE
							 , timing 	boolean = FALSE
							 , buffers 	boolean = FALSE
							 , triggers	boolean = FALSE
						     , format	text = 'text')
	RETURNS TABLE (pid integer
				 , frame_number integer
				 , query_text text
				 , plan text
				 , leader_pid integer)
	AS 'MODULE_PATHNAME'
	LANGUAGE C STRICT VOLATILE;

CREATE FUNCTION pg_progress_bar(pid integer)
	RETURNS FLOAT
	AS 'MODULE_PATHNAME'
	LANGUAGE C STRICT VOLATILE;

CREATE FUNCTION pg_progress_bar_visual(pid		integer
								  , delay	integer = 1)
	RETURNS FLOAT
	AS 'MODULE_PATHNAME', 'pg_progress_bar'
	LANGUAGE C STRICT VOLATILE;