Winslett/pg_state_statements.sql

Last active February 28, 2022 20:33

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Winslett/16932a89fc383c8e6ba14eb311f4dbe0.js"></script>
Save Winslett/16932a89fc383c8e6ba14eb311f4dbe0 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

pg_state_statements.sql

	SELECT
	total_exec_time,
	mean_exec_time AS avg_ms,
	calls,
	query
	FROM pg_stat_statements
	ORDER BY mean_exec_time DESC
	LIMIT 10;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment