On Sun, Sep 29, 2013 at 2:09 AM, Ken Tanzer <ken.tanzer@xxxxxxxxx> wrote:
I just sent off to this list for query help, and found the process of gathering all the requested info somewhat tedious. So I created a little BASH script to try to pull together as much of this information as possible.The script reads an analyze file, and generates SQL queries to retrieve the following information:
- Postgres Version
- Changes to postgresql.conf
- Description of all tables scanned
- Description of all Indices
- Actual and estimated row counts for all the tables
Hopefully this may be of use to others as well. This list doesn't include definitions for any views or custom functions--I don't think they're in the analyze output, but if they are please let me know.Any comments or suggestions for improvement would be most welcome. Thanks.Kenp.s., This script runs fine on my computer (Ubuntu 13.04), but on a Fedora 11 machine it dies withpg_analyze_info.sh: line 18: unexpected EOF while looking for matching `)'pg_analyze_info.sh: line 57: syntax error: unexpected end of fileIf anyone knows why, or encounters a similar error and fixes it, please let me know!
It's the blank line on line 26. Put a backslash on that line or delete it entirely.
Craig
--
AGENCY SoftwareA data system that puts you in control100% Free Software(253) 245-3801learn more about AGENCY orfollow the discussion.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
