Commits

Branch selector

main

User selector

All users

All time

Commit history

Commits on Jan 11, 2023

• 1. End of life check in findings 2. WAL compression check for PG 15+

  jobinau

  committed
  542ad09View commit details

  Copy full SHA for 542ad09

  Browse repository at this point

• PostgreSQL Version advices with static meta data

  jobinau

  committed
  05485f2View commit details

  Copy full SHA for 05485f2

  Browse repository at this point

Commits on Dec 29, 2022

• Eleminate CheckpointWriteDelay and PgSleep from database time

  jobinau

  committed
  238bdbcView commit details

  Copy full SHA for 238bdbc

  Browse repository at this point

Commits on Dec 28, 2022

• fixing loopholes while collecting and analyzing the wait events of background process

  jobinau

  committed
  ae8beaaView commit details

  Copy full SHA for ae8beaa

  Browse repository at this point

• Improvement: Historically the pg_gather analysis excluded the effort of background workers, which is not the right thing to do, Now it is captured and analyzed

  jobinau

  committed
  2e9795aView commit details

  Copy full SHA for 2e9795a

  Browse repository at this point

Commits on Dec 19, 2022

• Fix count pg_toast_temp as part of temporary schema

  jobinau

  committed
  73c1034View commit details

  Copy full SHA for 73c1034

  Browse repository at this point

Commits on Dec 15, 2022

• Bug fix : Workmem calculation and summary calculation can come emtpy

  jobinau

  committed
  b2a7fcbView commit details

  Copy full SHA for b2a7fcb

  Browse repository at this point

Commits on Dec 13, 2022

• List biggest consumers of maintenance_work_mem in findings

  jobinau

  committed
  06c67d1View commit details

  Copy full SHA for 06c67d1

  Browse repository at this point

• blockers and victims analysis query and summary data. Data collection time and WAL generation rate in the report

  jobinau

  committed
  b1ffd19View commit details

  Copy full SHA for b1ffd19

  Browse repository at this point

Commits on Dec 8, 2022

• Missing tables and data collection which is part of v18 development

  jobinau

  committed
  cf13847View commit details

  Copy full SHA for cf13847

  Browse repository at this point

Commits on Dec 5, 2022

• Recommendations on AUTOVACUUM settings at table level

  jobinau

  committed
  154a5e3View commit details

  Copy full SHA for 154a5e3

  Browse repository at this point

• Crash detection logic

  jobinau

  committed
  46a00b1View commit details

  Copy full SHA for 46a00b1

  Browse repository at this point

Commits on Dec 2, 2022

• 1.New Check for vacuum frequency and report if there are more than 12 vacs per day. 2.Count the DBs and report in the table footer

  jobinau

  committed
  fd056b8View commit details

  Copy full SHA for fd056b8

  Browse repository at this point

Commits on Dec 1, 2022

• New FILLFACTOR recommendation per table

  jobinau

  committed
  bda08d4View commit details

  Copy full SHA for bda08d4

  Browse repository at this point

Commits on Nov 29, 2022

• Per table inserts,updates,deletes and HOT updates per day

  jobinau

  committed
  c0f0054View commit details

  Copy full SHA for c0f0054

  Browse repository at this point

Commits on Nov 28, 2022

• Parameters which are not visible in pg_settings will be displayed from pg_file_settings, Module/libeary specific settings in other files will be avaiable now. archive_command will be highlighted if…

  Show description for 9f623b5
  jobinau

  committed
  9f623b5View commit details

  Copy full SHA for 9f623b5

  Browse repository at this point

• bumbed up the gather.sql version to 18 which is missed while committing the new event capture, new table for end markers, comments in imphistoery.sh to accomodate findings yet

  jobinau

  committed
  bc533bfView commit details

  Copy full SHA for bc533bf

  Browse repository at this point

Commits on Nov 26, 2022

• a core change in event caputre, the pg_sleep is pushed inside the parepared statement for , infact is replaced with

  jobinau

  committed
  e111472View commit details

  Copy full SHA for e111472

  Browse repository at this point

Commits on Nov 22, 2022

• archive failure detection is added to report

  jobinau

  committed
  13e8c22View commit details

  Copy full SHA for 13e8c22

  Browse repository at this point

Commits on Nov 17, 2022

• Improvements to report generation using docker image

  jobinau

  committed
  e47446eView commit details

  Copy full SHA for e47446e

  Browse repository at this point

Commits on Nov 16, 2022

• fix to make report generation pg13 comptible and additional feature of v18 landing

  jobinau

  committed
  f010d31View commit details

  Copy full SHA for f010d31

  Browse repository at this point

Commits on Nov 10, 2022

• specify column names of pg_get_index for addition of future columns and fix for inheritance table name

  jobinau

  committed
  8d9a166View commit details

  Copy full SHA for 8d9a166

  Browse repository at this point

Commits on Nov 9, 2022

• report version to 18 (missed in previous commit). and warn the databases where there are more than 50GB temp file generation

  jobinau

  committed
  7dfeec9View commit details

  Copy full SHA for 7dfeec9

  Browse repository at this point

• Schema count and temporary schema count in findings

  jobinau

  committed
  e4ce807View commit details

  Copy full SHA for e4ce807

  Browse repository at this point

Commits on Nov 4, 2022

• Fix: Column index changed as part of new columns to table

  jobinau

  committed
  881f26dView commit details

  Copy full SHA for 881f26d

  Browse repository at this point

• Merging all changes and fixes before the v17 release

  jobinau

  committed
  a035d9fView commit details

  Copy full SHA for a035d9f

  Browse repository at this point

Commits on Nov 2, 2022

• reference to wait event documentation

  jobinau

  committed
  87a8925View commit details

  Copy full SHA for 87a8925

  Browse repository at this point

• minor syntax error

  jobinau

  committed
  39ad256View commit details

  Copy full SHA for 39ad256

  Browse repository at this point

Commits on Oct 30, 2022

• checkpoint/bgwriter analysis even if there is no prameter, Add No.of days from last bgwriter stats reset to report

  jobinau

  committed
  9c109cbView commit details

  Copy full SHA for 9c109cb

  Browse repository at this point

Commits on Oct 29, 2022

• highlight the database to which pg_gather data collection is highlighted

  jobinau

  committed
  8d4bb48View commit details

  Copy full SHA for 8d4bb48

  Browse repository at this point

• Server returns a json array of all NS and popup box does a look up of NS oid in the json to findout the nsname

  jobinau

  committed
  5680b73View commit details

  Copy full SHA for 5680b73

  Browse repository at this point

Commits on Oct 28, 2022

• JIT is reportedly causing memory leak and crashes in few cases, recommendation to disable it unless essential

  jobinau

  committed
  bcdfb72View commit details

  Copy full SHA for bcdfb72

  Browse repository at this point

Commits on Oct 25, 2022

• Calculation based on last stats reset of the database, average daily vacuum is implimented based on calculation

  jobinau

  committed
  197c7ceView commit details

  Copy full SHA for 197c7ce

  Browse repository at this point

• Server side analysis query documentation

  jobinau

  committed
  7322380View commit details

  Copy full SHA for 7322380

  Browse repository at this point

• Starting of SQL documentation

  jobinau

  committed
  0a7a2b4View commit details

  Copy full SHA for 0a7a2b4

  Browse repository at this point