StevenJL/psql_query_most_rows.sql

Last active August 16, 2021 06:30

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

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

Download ZIP

PSQL query most rows

Raw

psql_query_most_rows.sql

	SELECT
	rows,
	query
	FROM pg_stat_statements
	WHERE query iLIKE '%SELECT%'
	ORDER BY rows DESC
	LIMIT 100;

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