E - show execution plan (UPDATE/DELETE safe)When you press E, you are prompted for a process ID:
Re-determine execution plan: 119692
But I kept getting the message:
Query Plan:
ERROR: relation "myschema.mytable" does not exist
LINE 4: from myschema.mytable
^
Hit any key to continue:
Solution: Execute pg_top with database name, host name, port, username and password, like this:
$ pg_top -d mydb -h myhost.mydomain.com -p 5432 -U mysuperuser -W
No comments:
Post a Comment