/
info.py
48 lines (41 loc) · 1.61 KB
/
info.py
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
"""
pg_statviz - stats visualization and time series analysis
"""
__author__ = "Jimmy Angelakos"
__copyright__ = "Copyright (c) 2023 Jimmy Angelakos"
__license__ = "PostgreSQL License"
import logging
from psycopg2.errors import ExternalRoutineException, InsufficientPrivilege
logging.basicConfig()
_logger = logging.getLogger(__name__)
_logger.setLevel(logging.INFO)
def getinfo(conn):
info = {}
try:
cur = conn.cursor()
cur.execute("""SELECT 1
FROM pg_extension
WHERE extname='pg_statviz'""")
if not cur.fetchone():
raise SystemExit("pg_statviz extension is not installed in this "
+ "database")
cur.execute("""CREATE TEMP TABLE _info(hostname text);
COPY _info FROM PROGRAM 'hostname';
SELECT hostname,
inet_server_addr(),
current_setting('block_size')
FROM _info""")
info['hostname'], info['inet_server_addr'], info['block_size'] \
= cur.fetchone()
cur.close()
except (ExternalRoutineException, InsufficientPrivilege) as e:
conn.rollback()
cur = conn.cursor()
_logger.error(e)
cur.execute("""SELECT inet_server_addr(),
current_setting('block_size')""")
info['inet_server_addr'], info['block_size'] = cur.fetchone()
info['hostname'] = conn.get_dsn_parameters()['host']
_logger.info(f"""Setting hostname to "{info['hostname']}" """)
cur.close()
return info