On Sun, Sep 29, 2013 at 2:09 AM, Ken Tanzer <ken.tan...@gmail.com> 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. > > Ken > > p.s., This script runs fine on my computer (Ubuntu 13.04), but on a > Fedora 11 machine it dies with > > pg_analyze_info.sh: line 18: unexpected EOF while looking for matching `)' > pg_analyze_info.sh: line 57: syntax error: unexpected end of file > > If 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 Software > A data system that puts you in control > 100% Free Software > *http://agency-software.org/* > ken.tan...@agency-software.org > (253) 245-3801 > > Subscribe to the mailing > list<agency-general-requ...@lists.sourceforge.net?body=subscribe> > to > learn more about AGENCY or > follow the discussion. > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > >
