# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1575999075 -7200
# Node ID aedbd074ec54a755901385c235dffbc8968235c8
# Parent  f2b450fa4f4b456869573c25428904c82324cec3
Added extra examples of queries.

diff -r f2b450fa4f4b -r aedbd074ec54 postgres.rst
--- a/postgres.rst	Thu Nov 14 01:12:40 2019 +0200
+++ b/postgres.rst	Tue Dec 10 19:31:15 2019 +0200
@@ -202,9 +202,13 @@
   SELECT current_user;
   SELECT session_user;
 
-::
+Active sessions and queries::
+
+  select * from pg_stat_activity;
 
-   select * from pg_stat_activity;
+  select * from pg_stat_activity
+  order by usename;
+
 
 https://www.postgresql.org/docs/current/monitoring-stats.html
   The Statistics Collector.
@@ -249,6 +253,7 @@
 
   \dt
   SELECT table_schema, table_name FROM information_schema.tables ORDER BY table_schema, table_name;
+  SELECT * FROM pg_class;
 
 or in all schemas::