Re: tracking scripts...

On 11/26/2013 9:24 AM, Joey Quinn wrote:
> When I ran that command (select * from pg_stat_activity"), it returned
> the first six lines of the scripts. I'm fairly sure it has gotten a
> bit beyond that (been running over 24 hours now, and the size has
> increased about 300 GB). Am I missing something for it to tell me what
> the last line processed was?

that means your GUI lobbed the entire file at postgres in a single
PQexec call, so its all being executed as a single statement.

psql -f "filename.sql" dbname   would have processed the queries one at
a time.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast