From: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
---|---|
To: | Craig James <cjames(at)emolecules(dot)com> |
Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: BASH script for collecting analyze-related info |
Date: | 2013-09-29 21:24:52 |
Message-ID: | CAD3a31UojmsQo5zPuy8-AhnLf13sxS7PPjEfkH_VbF=xTvco8w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
>
> 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 )
From | Date | Subject | |
---|---|---|---|
Next Message | Craig James | 2013-09-29 23:59:05 | Re: BASH script for collecting analyze-related info |
Previous Message | Craig James | 2013-09-29 16:57:15 | Re: BASH script for collecting analyze-related info |