have you seen these functions in PostgreSQL? in psql say `\df` Maybe they are internal...I don't know but they might help
/B setof record | pg_catalog | pg_show_all_settings | text | pg_catalog | pg_stat_get_backend_activity | integer oid | pg_catalog | pg_stat_get_backend_dbid | integer setof integer | pg_catalog | pg_stat_get_backend_idset | integer | pg_catalog | pg_stat_get_backend_pid | integer oid | pg_catalog | pg_stat_get_backend_userid | integer bigint | pg_catalog | pg_stat_get_blocks_fetched | oid bigint | pg_catalog | pg_stat_get_blocks_hit | oid bigint | pg_catalog | pg_stat_get_db_blocks_fetched | oid bigint | pg_catalog | pg_stat_get_db_blocks_hit | oid integer | pg_catalog | pg_stat_get_db_numbackends | oid bigint | pg_catalog | pg_stat_get_db_xact_commit | oid bigint | pg_catalog | pg_stat_get_db_xact_rollback | oid bigint | pg_catalog | pg_stat_get_numscans | oid bigint | pg_catalog | pg_stat_get_tuples_deleted | oid bigint | pg_catalog | pg_stat_get_tuples_fetched | oid bigint | pg_catalog | pg_stat_get_tuples_inserted | oid bigint | pg_catalog | pg_stat_get_tuples_returned | oid bigint | pg_catalog | pg_stat_get_tuples_updated | oid boolean | pg_catalog | pg_stat_reset | boolean | pg_catalog | pg_table_is_visible | oid boolean | pg_catalog | pg_type_is_visible | oid ----- Original Message ----- From: "Delao, Darryl W" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 06:08 Subject: Postgres connection monitor > Is anyone aware of any tool or command that will allow me to see active and > inactive postgres connections in Red Hat 7.3? If there is a command out > there, what command could I use to kill a specific connection? > > Thank you, > Darryl > > > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED] > https://listman.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
