How to see active connections and “current activity” in PostgreSQL 8.4

OK, got it from someone else. This query should do the trick:

select *
from pg_stat_activity
where datname="mydatabasename";

Related Posts:

  1. PostgreSQL: Show tables in PostgreSQL
  2. Psql could not connect to server: No such file or directory, 5432 error?
  3. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  4. What is the format for the PostgreSQL connection string / URL?
  5. “use database_name” command in PostgreSQL
  6. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  7. psql: FATAL: Ident authentication failed for user “postgres”
  8. fe_sendauth: no password supplied
  9. How can I drop all the tables in a PostgreSQL database?
  10. How to restart PostgreSQL in Ubuntu 18.04
  11. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  12. Postgresql: Scripting psql execution with password
  13. postgresql duplicate key violates unique constraint
  14. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  15. How to change PostgreSQL user password?
  16. No function matches the given name and argument types
  17. PostgreSQL error: Fatal: role “username” does not exist
  18. How to change PostgreSQL user password?
  19. How to exit from PostgreSQL command line utility: psql
  20. psql: FATAL: database “” does not exist
  21. eroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  22. Permission denied for relation
  23. postgres does not know where to find server configuration
  24. input file appears to be a text format dump. Please use psql
  25. PG COPY error: invalid input syntax for integer
  26. Postgres: INSERT if does not exist already
  27. What’s the default superuser username/password for postgres after a new install?
  28. pg_dump and pg_restore: input file does not appear to be a valid archive
  29. What is this JavaScript “require”?
  30. What is this JavaScript “require”?
  31. PostgreSQL “DESCRIBE TABLE”
  32. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  33. How to restart Postgresql
  34. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  35. What is the default password for Postgres
  36. Postgresql 9.2 pg_dump version mismatch
  37. missing FROM-clause entry for table
  38. PostgreSQL: Remotely connecting to Postgres instance using psql command
  39. Simple Random Samples from a Sql database
  40. Insert text with single quotes in PostgreSQL
  41. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  42. Cannot simply use PostgreSQL table name (“relation does not exist”)
  43. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  44. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  45. could not connect to server: No such file or directory (PG::ConnectionBad)
  46. Postgresql tables exists, but getting “relation does not exist” when querying
  47. PG::ConnectionBad: fe_sendauth: no password supplied
  48. “extra data after last expected column” while trying to import a csv file into postgresql
  49. postgresql: error duplicate key value violates unique constraint
  50. psql: command not found Mac
  51. pg_ctl: no database directory specified and environment variable PGDATA unset
  52. psql: FATAL: role “postgres” does not exist
  53. Postgres Error: More than one row returned by a subquery used as an expression
  54. PostgreSQL: Query has no destination for result data
  55. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  56. PostgreSQL create table if not exists
  57. updating table rows in postgres using subquery
  58. PostgreSQL visual interface similar to phpMyAdmin?
  59. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  60. GROUP BY and COUNT using ActiveRecord
  61. Postgresql column reference “id” is ambiguous
  62. What is a postgres superuser
  63. GRANT SELECT to all tables in postgresql
  64. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  65. Postgres equivalent to MySQL’s \G?
  66. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
  67. Postgres equivalent to MySQL’s \G?
  68. Postgres equivalent to MySQL’s \G?

Leave a Comment