import psycopg
import pandas as pd
conn = psycopg.connect("postgresql://eam:PASSWORD@Db:5432/UIS_MV")
with conn.cursor() as cur:
      for record in cur.execute("""
                  SELECT oid,table_schema,table_name, row_estimate::int, pg_size_pretty(total_bytes) AS total
                     , pg_size_pretty(index_bytes) AS index
                     , pg_size_pretty(toast_bytes) AS toast
                     , pg_size_pretty(table_bytes) AS table
                         FROM (
                         SELECT *, total_bytes-index_bytes-coalesce(toast_bytes,0) AS table_bytes FROM (
                             SELECT c.oid,nspname AS table_schema, relname AS table_name
                                     , c.reltuples AS row_estimate
                                     , pg_total_relation_size(c.oid) AS total_bytes
                                     , pg_indexes_size(c.oid) AS index_bytes
                                     , pg_total_relation_size(reltoastrelid) AS toast_bytes
                                 FROM pg_class c
                                 LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
                                 WHERE relkind = 'r'
                             ) a
                         ) a order by  total_bytes desc
                         limit 10
                      """):
          print(record)
print(sql)
dat = pd.read_sql_query(sql, conn)

import email.utils
import datetime
 
date_tuple=email.utils.parsedate_tz('Fri, 20 Jul 2007 15:31:21 +0400')
date=datetime.datetime.fromtimestamp(email.utils.mktime_tz(date_tuple))
 
 
import email.utils
import datetime
 
try:
    date_tuple=email.utils.parsedate_tz('Fri, 20 Jul 2007 15:31:21 +0400')
    date_v=datetime.datetime.fromtimestamp(email.utils.mktime_tz(date_tuple)
    date_str=date_v.strftime('%Y-%m-%d %H:%M')
except:
    date_str="1900-01-01 00:00"
 
from_str=email.utils.parseaddr(getHeader(headers,u'From'))[1]

Install multiple versions and library independence

• https://dev.to/macdub/pyenv-multiple-users-and-a-plugin-solution-3k16
• https://github.com/pyenv/pyenv
• https://github.com/macdub/pyenv-multiuser

# .bashrc
export PYENV_ROOT="/home/melnikov_ea/.pyenv"
export PATH="$PYENV_ROOT/bin:$PATH"
export PIPENV_PYTHON="$PYENV_ROOT/shims/python"
 
eval "$(pyenv init -)"
eval "$(pyenv virtualenv-init -)"
export PYENV_LOCAL_SHIM=/home/melnikov_ea/.pyenv_local_shim
 
export PYENV_LOCAL_SHIM="$HOME/.pyenv_local_shim"
export PATH="$PYENV_LOCAL_SHIM:$HOME/.pyenv/bin:$PATH"
eval "$(pyenv virtualenv-init -)"