View Brian Mansell's profile
Patience is a virtue
2008-01-22
Here's hoping that Apple decides to ship my new laptop sooner rather than later. This 'secondary machine' as I've coined it, will be useful in the daily migration of projects between work, school, and home. Also, the ability to watch movies on occasion is an added benefit.
posted by Brian Mansell @ 12:00:00 PM,
, links to this post
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,
, links to this post