View Brian Mansell's profile
MySQL to Postgres: SHOW FULL PROCESSLIST
2008-01-18
Over the next few weeks, I'll make an attempt to share a few tips on learning PostgreSQL from a MySQL user's prospective
SHOW FULL PROCESSLIST / SHOW PROCESSLIST
- Start up the Postgres shell (psql)
- select * from pg_stat_activity;
From here you will see the client details, query, the state of the query, and the timestamp from when it was executed.
Labels: postgres mysql
posted by Brian Mansell @ 9:49:00 AM,
