django-postgres-refresher 1.0.0

安装

$ pip install django-postgres-refresher

settings.py

INSTALLED_APPS+=['django_postgres_refresher']

migrate

$ python manage.py migrate

功能

• 管理界面
• 刷新报告（duration、time）和统计（count、avg_duration、min_duration、max_duration）

示例

刷新matviews

python manage.py postgres_refresher

INSERT到postgres_refresher_config

INSERT INTO postgres_refresher_config(schemaname,matviewname,"concurrently",seconds)
VALUES
('schemaname','matviewname',true,600),
('schemaname','matviewname2',true,600)
ON CONFLICT(schemaname,matviewname) DO NOTHING;