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