PostgreSQL 10 – other highlights
by Admin | Jun 13, 2017 | News |
- View “pg_stat_activity” contains new useful or updated existing columns which can help us to better track what is going on in the database:
- wait_event_type – has now interesting values “Activity”, “Extension”, “Client”, “IPC”, “Timeout”, “IO”
- “wait_event” – name of activity for new event types
- “backend_type” – new column
- View “pg_stat_replication” is heavily updated so you can see even lags.
- New extended additional statistics for columns – new commands “CREATE STATISTICS” and “ALTER STATISTICS” + catalog in “pg_statistic_ext”
