1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
--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)
|
