Postgres Pro
Downloads
Home   >   mailing lists

Re: BASH script for collecting analyze-related info - Mailing list pgsql-performance

From Ken Tanzer
Subject Re: BASH script for collecting analyze-related info
Date
Msg-id CAD3a31UojmsQo5zPuy8-AhnLf13sxS7PPjEfkH_VbF=xTvco8w@mail.gmail.com
Whole thread Raw
In response to Re: BASH script for collecting analyze-related info  (Craig James <cjames@emolecules.com>)
Responses Re: BASH script for collecting analyze-related info
List pgsql-performance
Tree view
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


Well that made perfect sense, but after making that change I'm still getting the same error.

# Get tables
TABLES=$( \
cat <( \
# Indexed tables \
egrep -o 'Index Scan using \b[a-zA-Z0-9_-]* on [a-zA-Z0-9_-]*' $FILE  | cut -f 6 -d ' ' \
) <( \
# Scanned Tables \
egrep -o 'Seq Scan on \b[a-zA-Z0-9_-]* ' $FILE | cut -f 4 -d ' ' \
) | sort | uniq )



pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: BASH script for collecting analyze-related info
Next
From: Craig James
Date:
Subject: Re: BASH script for collecting analyze-related info