search

pgadmin-org / pgagent

pgAgent - A job scheduler for PostgreSQL
https://www.pgadmin.org/
Other
97 stars 41 forks source link

Update pgagent.sql #16

Closed wavle closed 5 years ago

wavle commented 5 years ago

Added indexes on creation date for log tables (takes much less time to find i.e. one week period in two years log history) Also added index on pga_jobsteplog.jsljstid in order to find exact occurances of any jobstep history

wavle commented 5 years ago

Hope this helps lots of people to speed up their log search queries

repo-lockdown[bot] commented 5 years ago

Thanks for your Pull Request! :smile: This repo on GitHub is just a mirror of our real git repositories though, and can't really handle PRs. :frowning: Hopefully you can redo the PR, and direct it to the git.postgresql.org repos? We have a developer guide, if that helps: https://wiki.postgresql.org/wiki/So,_you_want_to_be_a_developer%3F. If this was a PR for pgAdmin, please visit https://www.pgadmin.org/docs/pgadmin4/dev/submitting_patches.html.