--Setup extension CREATE SCHEMA "PGSS"; CREATE EXTENSION pg_stat_statements WITH SCHEMA "PGSS"; CREATE EXTENSION btree_gist; CREATE SCHEMA "PoWA"; CREATE EXTENSION powa WITH SCHEMA "PoWA"; -- Test created ojects SELECT * FROM "PoWA".powa_functions ORDER BY name, operation, priority, function_name; srvid | kind | name | operation | external | function_name | query_source | query_cleanup | enabled | priority -------+-----------+----------------------------+-----------+----------+----------------------------------------+----------------------------------+---------------+---------+---------- 0 | module | pg_database | reset | f | powa_catalog_database_reset | | | t | 100 0 | module | pg_database | snapshot | f | powa_catalog_database_snapshot | powa_catalog_database_src | | t | 100 0 | module | pg_replication_slots | aggregate | f | powa_replication_slots_aggregate | | | t | 100 0 | module | pg_replication_slots | purge | f | powa_replication_slots_purge | | | t | 100 0 | module | pg_replication_slots | reset | f | powa_replication_slots_reset | | | t | 100 0 | module | pg_replication_slots | snapshot | f | powa_replication_slots_snapshot | powa_replication_slots_src | | t | 100 0 | module | pg_role | reset | f | powa_catalog_role_reset | | | t | 100 0 | module | pg_role | snapshot | f | powa_catalog_role_snapshot | powa_catalog_role_src | | t | 100 0 | module | pg_stat_activity | aggregate | f | powa_stat_activity_aggregate | | | t | 100 0 | module | pg_stat_activity | purge | f | powa_stat_activity_purge | | | t | 100 0 | module | pg_stat_activity | reset | f | powa_stat_activity_reset | | | t | 100 0 | module | pg_stat_activity | snapshot | f | powa_stat_activity_snapshot | powa_stat_activity_src | | t | 100 0 | module | pg_stat_archiver | aggregate | f | powa_stat_archiver_aggregate | | | t | 100 0 | module | pg_stat_archiver | purge | f | powa_stat_archiver_purge | | | t | 100 0 | module | pg_stat_archiver | reset | f | powa_stat_archiver_reset | | | t | 100 0 | module | pg_stat_archiver | snapshot | f | powa_stat_archiver_snapshot | powa_stat_archiver_src | | t | 100 0 | module | pg_stat_bgwriter | aggregate | f | powa_stat_bgwriter_aggregate | | | t | 100 0 | module | pg_stat_bgwriter | purge | f | powa_stat_bgwriter_purge | | | t | 100 0 | module | pg_stat_bgwriter | reset | f | powa_stat_bgwriter_reset | | | t | 100 0 | module | pg_stat_bgwriter | snapshot | f | powa_stat_bgwriter_snapshot | powa_stat_bgwriter_src | | t | 100 0 | module | pg_stat_checkpointer | aggregate | f | powa_stat_checkpointer_aggregate | | | t | 100 0 | module | pg_stat_checkpointer | purge | f | powa_stat_checkpointer_purge | | | t | 100 0 | module | pg_stat_checkpointer | reset | f | powa_stat_checkpointer_reset | | | t | 100 0 | module | pg_stat_checkpointer | snapshot | f | powa_stat_checkpointer_snapshot | powa_stat_checkpointer_src | | t | 100 0 | module | pg_stat_database | aggregate | f | powa_stat_database_aggregate | | | t | 100 0 | module | pg_stat_database | purge | f | powa_stat_database_purge | | | t | 100 0 | module | pg_stat_database | reset | f | powa_stat_database_reset | | | t | 100 0 | module | pg_stat_database | snapshot | f | powa_stat_database_snapshot | powa_stat_database_src | | t | 100 0 | module | pg_stat_database_conflicts | aggregate | f | powa_stat_database_conflicts_aggregate | | | t | 100 0 | module | pg_stat_database_conflicts | purge | f | powa_stat_database_conflicts_purge | | | t | 100 0 | module | pg_stat_database_conflicts | reset | f | powa_stat_database_conflicts_reset | | | t | 100 0 | module | pg_stat_database_conflicts | snapshot | f | powa_stat_database_conflicts_snapshot | powa_stat_database_conflicts_src | | t | 100 0 | module | pg_stat_io | aggregate | f | powa_stat_io_aggregate | | | t | 100 0 | module | pg_stat_io | purge | f | powa_stat_io_purge | | | t | 100 0 | module | pg_stat_io | reset | f | powa_stat_io_reset | | | t | 100 0 | module | pg_stat_io | snapshot | f | powa_stat_io_snapshot | powa_stat_io_src | | t | 100 0 | module | pg_stat_replication | aggregate | f | powa_stat_replication_aggregate | | | t | 100 0 | module | pg_stat_replication | purge | f | powa_stat_replication_purge | | | t | 100 0 | module | pg_stat_replication | reset | f | powa_stat_replication_reset | | | t | 100 0 | module | pg_stat_replication | snapshot | f | powa_stat_replication_snapshot | powa_stat_replication_src | | t | 100 0 | module | pg_stat_slru | aggregate | f | powa_stat_slru_aggregate | | | t | 100 0 | module | pg_stat_slru | purge | f | powa_stat_slru_purge | | | t | 100 0 | module | pg_stat_slru | reset | f | powa_stat_slru_reset | | | t | 100 0 | module | pg_stat_slru | snapshot | f | powa_stat_slru_snapshot | powa_stat_slru_src | | t | 100 0 | extension | pg_stat_statements | aggregate | f | powa_statements_aggregate | | | t | 10 0 | extension | pg_stat_statements | purge | f | powa_databases_purge | | | t | 10 0 | extension | pg_stat_statements | purge | f | powa_statements_purge | | | t | 10 0 | extension | pg_stat_statements | reset | f | powa_statements_reset | | | t | 10 0 | extension | pg_stat_statements | snapshot | f | powa_databases_snapshot | powa_databases_src | | t | -3 0 | extension | pg_stat_statements | snapshot | f | powa_statements_snapshot | powa_statements_src | | t | -2 0 | module | pg_stat_subscription | aggregate | f | powa_stat_subscription_aggregate | | | t | 100 0 | module | pg_stat_subscription | purge | f | powa_stat_subscription_purge | | | t | 100 0 | module | pg_stat_subscription | reset | f | powa_stat_subscription_reset | | | t | 100 0 | module | pg_stat_subscription | snapshot | f | powa_stat_subscription_snapshot | powa_stat_subscription_src | | t | 100 0 | module | pg_stat_subscription_stats | aggregate | f | powa_stat_subscription_stats_aggregate | | | t | 100 0 | module | pg_stat_subscription_stats | purge | f | powa_stat_subscription_stats_purge | | | t | 100 0 | module | pg_stat_subscription_stats | reset | f | powa_stat_subscription_stats_reset | | | t | 100 0 | module | pg_stat_subscription_stats | snapshot | f | powa_stat_subscription_stats_snapshot | powa_stat_subscription_stats_src | | t | 100 0 | module | pg_stat_wal | aggregate | f | powa_stat_wal_aggregate | | | t | 100 0 | module | pg_stat_wal | purge | f | powa_stat_wal_purge | | | t | 100 0 | module | pg_stat_wal | reset | f | powa_stat_wal_reset | | | t | 100 0 | module | pg_stat_wal | snapshot | f | powa_stat_wal_snapshot | powa_stat_wal_src | | t | 100 0 | module | pg_stat_wal_receiver | aggregate | f | powa_stat_wal_receiver_aggregate | | | t | 100 0 | module | pg_stat_wal_receiver | purge | f | powa_stat_wal_receiver_purge | | | t | 100 0 | module | pg_stat_wal_receiver | reset | f | powa_stat_wal_receiver_reset | | | t | 100 0 | module | pg_stat_wal_receiver | snapshot | f | powa_stat_wal_receiver_snapshot | powa_stat_wal_receiver_src | | t | 100 (66 rows)