pSQL & pl/pgSQL PostGreSQL Flashcards
1
Q
Write a query to return active connections/ queries from a PostgreSQL instance.
A
SELECT * FROM pg_stat_activity;
Data Engineer/SQL Developer/SQL DBA Study Topics > pSQL & pl/pgSQL PostGreSQL > Flashcards
Write a query to return active connections/ queries from a PostgreSQL instance.
SELECT * FROM pg_stat_activity;