• pg_stat_activity

pg_stat_activity is a view that belongs to the postgresql catalog, it helps you to view the status of the queries that are in execution, the explanation of each column can be found in the postgresql manual The Statistics Collector section (I don't want to do a simply copy-paste, so …

How to install Skype in Debian amd64

• Check if your system has i386 arch support enabled

$ dpkg --print-foreign-architectures
i386

• If you don't have i386 support enable it with the following commands:

# dpkg --add-architecture i386
# apt-get update

• Then install the skype's dependencies with the following command:

# apt-get install libqtgui4:i386 \
      libqtwebkit4 …

The Rxvt terminal is a really good terminal emulator, actually it has been my default terminal since at least 4 years ago. I started using it after getting tired of gnome-terminal (it's too fat and heavy for me).

To install it you just must do the follow:

aptitude install rxvt-unicode …