DBA Hub

📋Steps in this guide1/1

Find temp file usage of databases

postgres=# SELECT datname, temp_files, temp_bytes, stats_reset FROM pg_stat_database; datname    | temp_files | temp_bytes | stats_reset -----------+------------+------------+---------------------------------- | 0        | 0          | 18-APR-22.18:23:33.09366 +03:00 postgres   | 2          | 28000000   | 18-APR-22 18:23:33.093639 +03:00 edb        | 0          | 0          | 18-APR-22 18:23:37.09

postgresql configurationintermediate
by PostgreSQL
14 views
1

Find temp file usage of databases

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
postgres=#
SELECT datname, temp_files, temp_bytes, stats_reset
FROM pg_stat_database;
datname    | temp_files | temp_bytes | stats_reset
-----------+------------+------------+----------------------------------
| 0        | 0          | 18-APR-22.18:23:33.09366 +03:00
postgres   | 2          | 28000000   | 18-APR-22 18:23:33.093639 +03:00
edb        | 0          | 0          | 18-APR-22 18:23:37.095023 +03:00
template1  | 0          | 0          |
template0  | 0          | 0          |
b2cplmdev  | 0          | 0          | 18-APR-22 18:23:35.093019 +03:00
test_dev   | 0          | 0          | 19-APR-22 10:17:28.826261 +03:00
(7 rows)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!