# Another API Options
# All rules in all environments
URL: /v1/tuning/get-config-all-environments (opens new window)
Show all rules for all environments. This endpoint is currently used by the site.
...
"data": [
{
"configuration": [..],
"environment": "WEB"
},
{
"configuration": [..],
"environment": "OLTP"
},
{
"configuration": [..],
"environment": "DW"
},
{
"configuration": [..],
"environment": "Mixed"
},
{
"configuration": [..],
"environment": "Desktop"
}
]
...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
# List Environments
URL: /v1/tuning/list-environments` (opens new window)
Show all environments.
...
"data": [
"WEB",
"OLTP",
"DW",
"Mixed",
"Desktop"
],
...
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
# PGBadger Configuration
URL: /v1/generators/pgbadger/get-config` (opens new window)
Show the pgbadger configurations (accepts the format parameter)
...
"data": [
{
"category": "log_config",
"description": "Logging configuration for pgbadger",
"parameters": [
{
"config_value": "on",
"name": "logging_collector"
},
{
"config_value": "on",
"name": "log_checkpoints"
},
{
"config_value": "on",
"name": "log_connections"
},
{
"config_value": "on",
"name": "log_disconnections"
},
{
"config_value": "on",
"name": "log_lock_waits"
},
{
"config_value": "0",
"name": "log_temp_files"
},
{
"config_value": "C",
"format": "String",
"name": "lc_messages"
},
{
"comment": "Adjust the minimum time to collect data",
"config_value": "10s",
"format": "Time",
"name": "log_min_duration_statement"
},
{
"config_value": "0",
"name": "log_autovacuum_min_duration"
}
]
},
...
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
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