Skip to content

Instantly share code, notes, and snippets.

@rueian

rueian/like15.sql

Created January 1, 2020 18:07
Show Gist options
  • Save rueian/3fa1b768197eee7dc87046f17a80cc65 to your computer and use it in GitHub Desktop.
Save rueian/3fa1b768197eee7dc87046f17a80cc65 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
like15.sql
postgres=# SELECT unnest(histogram_bounds::text::text[]) FROM pg_stats WHERE tablename='counters' AND attname='id';
 unnest
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 ms:103734:p
 ms:1074631:cl
 ms:1103301:c
 ms:1137423:pn
 ms:1168158:pr
 ms:1192862:p
 ms:1221019:cl
 ms:1243628:c
 …
(101 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment