PostgreSQL 101: Who is Using This Table?
It is a popular and dangerous motto, especially in the IT sector: If it works, leave it alone! However, as a responsible database administrator or application developer, let's take the initiative and see who is using these tables, and which tables are no longer used at all.
PostgreSQL 101: Activity Monitoring
When track_activities is set to on, PostgreSQL starts collecting data for all executed queries. Users with appropriate privileges can monitor user activity through this feature using the system view pg_stat_activities.
PostgreSQL 101: Connected Users
One of the PostgreSQL system views, pg_stat_activity, keeps a list of all currently running PostgreSQL background processes. This information includes which queries are running, connected users and when they connected, and the start time of running transactions and queries.
We were at PostgreSQL Day
We attended the 3rd PostgreSQL Conference held in Ankara on December 6, 2015. Profelis sponsored the event as an EnterpriseDB (EDB) Strategic Partner.
Profelis: BalabitTeknoloji İş Ortağı
Balabit, mühendislik ve geliştirme katkılarından dolayı Profelis'i Teknoloji İş Ortağı olarak ilan etti.
The cookies used are necessary for the website to function and cannot be switched off. These cookies are only set in response to actions made by you. If you block these cookies through your browser, some parts of the site may not work.
For more information, review our privacy policy.
Close