NikolayS/postgres_dba issues and pull requests

#62 - "operator is not unique" on i3 check

Issue - State: open - Opened by dewey about 1 month ago

#61 - Feature request: List reloptions

Issue - State: open - Opened by jalexandre0 about 2 years ago

#60 - CI: test Postgres 14

Pull Request - State: closed - Opened by NikolayS almost 3 years ago

#60 - CI: test Postgres 14

Pull Request - State: closed - Opened by NikolayS almost 3 years ago

#59 - s1 problem, needs conditional for the order by

Issue - State: closed - Opened by KiriakosGeorgiou almost 3 years ago - 1 comment

#59 - s1 problem, needs conditional for the order by

Issue - State: closed - Opened by KiriakosGeorgiou almost 3 years ago - 1 comment

#58 - bloat estimate precise question

Issue - State: closed - Opened by bagafoot almost 3 years ago - 1 comment

#58 - bloat estimate precise question

Issue - State: closed - Opened by bagafoot almost 3 years ago - 1 comment

#57 - New "lock trees" query, based on pg_blocking_pids()

Pull Request - State: closed - Opened by NikolayS about 3 years ago

#57 - New "lock trees" query, based on pg_blocking_pids()

Pull Request - State: closed - Opened by NikolayS about 3 years ago

#56 - Polish wording in the menu

Pull Request - State: closed - Opened by NikolayS about 3 years ago

#56 - Polish wording in the menu

Pull Request - State: closed - Opened by NikolayS about 3 years ago

#55 - Fix i2 (redundant indexes) for wide (10+ columns) tables

Pull Request - State: closed - Opened by NikolayS about 3 years ago

#55 - Fix i2 (redundant indexes) for wide (10+ columns) tables

Pull Request - State: closed - Opened by NikolayS about 3 years ago

#54 - Hello words

Pull Request - State: closed - Opened by NikolayS about 3 years ago

#53 - pg_stat_statements changed name colums

Issue - State: closed - Opened by oleg9301 about 3 years ago - 1 comment

#53 - pg_stat_statements changed name colums

Issue - State: closed - Opened by oleg9301 about 3 years ago - 1 comment

#52 - More queries

Pull Request - State: open - Opened by emerichunter about 3 years ago

#52 - More queries

Pull Request - State: open - Opened by emerichunter about 3 years ago

#51 - make echo for .psqlrc work both for bash and zsh

Pull Request - State: closed - Opened by NikolayS over 3 years ago - 2 comments

#51 - make echo for .psqlrc work both for bash and zsh

Pull Request - State: closed - Opened by NikolayS over 3 years ago - 2 comments

#50 - Fix some wrong detect redundant indexes when the table have more than 10 columns

Pull Request - State: closed - Opened by v0112358 over 3 years ago - 2 comments

#50 - Fix some wrong detect redundant indexes when the table have more than 10 columns

Pull Request - State: closed - Opened by v0112358 over 3 years ago - 2 comments

#49 - Feature request active and idle in transaction query

Issue - State: open - Opened by oleg9301 almost 4 years ago

#49 - Feature request active and idle in transaction query

Issue - State: open - Opened by oleg9301 almost 4 years ago

#48 - Support for the Postgresql 13 pg_stat_statements extension

Pull Request - State: closed - Opened by unhandled-exception almost 4 years ago - 2 comments

#48 - Support for the Postgresql 13 pg_stat_statements extension

Pull Request - State: closed - Opened by unhandled-exception almost 4 years ago - 2 comments

#47 - t1 has one error,why?

Issue - State: open - Opened by msdnchina over 4 years ago - 1 comment
Labels: bug

#46 - 2 new reports: lock trees and autovacuum queue

Pull Request - State: closed - Opened by NikolayS over 4 years ago

#46 - 2 new reports: lock trees and autovacuum queue

Pull Request - State: closed - Opened by NikolayS over 4 years ago

#45 - Fix the section about installing

Pull Request - State: closed - Opened by unhandled-exception over 4 years ago - 4 comments

#45 - Fix the section about installing

Pull Request - State: closed - Opened by unhandled-exception over 4 years ago - 4 comments

#44 - CircleCI tests refactoring. Support Postgres 12

Pull Request - State: closed - Opened by NikolayS almost 5 years ago

#44 - CircleCI tests refactoring. Support Postgres 12

Pull Request - State: closed - Opened by NikolayS almost 5 years ago

#43 - Issue with query b1 on postgres 12

Issue - State: closed - Opened by gowtham500 almost 5 years ago - 1 comment
Labels: enhancement

#43 - Issue with query b1 on postgres 12

Issue - State: closed - Opened by gowtham500 almost 5 years ago - 1 comment
Labels: enhancement

#42 - Improve version handling in SQL scripts.

Pull Request - State: closed - Opened by alexeyklyukin over 5 years ago - 1 comment

#41 - How about Oracle port ?

Issue - State: closed - Opened by mgramin over 5 years ago - 2 comments
Labels: wontfix

#41 - How about Oracle port ?

Issue - State: closed - Opened by mgramin over 5 years ago - 2 comments
Labels: wontfix

#40 - Improve i1,i2,i5 and b1 reports

Pull Request - State: closed - Opened by dmius almost 6 years ago

#40 - Improve i1,i2,i5 and b1 reports

Pull Request - State: closed - Opened by dmius almost 6 years ago

#39 - Redundat indexes list

Pull Request - State: closed - Opened by dmius almost 6 years ago

#39 - Redundat indexes list

Pull Request - State: closed - Opened by dmius almost 6 years ago

#38 - Issue of p1

Issue - State: open - Opened by nemfir almost 6 years ago - 1 comment

#38 - Issue of p1

Issue - State: open - Opened by nemfir almost 6 years ago - 1 comment

#37 - pg_stat_statements "1st word" report

Issue - State: open - Opened by NikolayS almost 6 years ago
Labels: help wanted

#37 - pg_stat_statements "1st word" report

Issue - State: open - Opened by NikolayS almost 6 years ago
Labels: help wanted

#36 - extend pg_stat_statements reports with pg_stat_kcache

Issue - State: open - Opened by NikolayS almost 6 years ago
Labels: enhancement, help wanted

#36 - extend pg_stat_statements reports with pg_stat_kcache

Issue - State: open - Opened by NikolayS almost 6 years ago
Labels: enhancement, help wanted

#35 - i3: Reformat SQL and fix collision with intarray #25

Pull Request - State: closed - Opened by NikolayS almost 6 years ago

#35 - i3: Reformat SQL and fix collision with intarray #25

Pull Request - State: closed - Opened by NikolayS almost 6 years ago

#34 - ERROR: relation "pg_stat_statements" does not exist

Issue - State: closed - Opened by wolandec almost 6 years ago - 1 comment

#34 - ERROR: relation "pg_stat_statements" does not exist

Issue - State: closed - Opened by wolandec almost 6 years ago - 1 comment

#33 - e1: highlight outdated extension versions (fix logic)

Pull Request - State: closed - Opened by NikolayS almost 6 years ago - 4 comments
Labels: bug

#33 - e1: highlight outdated extension versions (fix logic)

Pull Request - State: closed - Opened by NikolayS almost 6 years ago - 4 comments
Labels: bug

#32 - e1: highlight outdated extension versions (fix logic)

Pull Request - State: closed - Opened by NikolayS almost 6 years ago

#32 - e1: highlight outdated extension versions (fix logic)

Pull Request - State: closed - Opened by NikolayS almost 6 years ago

#31 - Extensions report, "wide" removed, fix /0 error, more

Pull Request - State: closed - Opened by NikolayS almost 6 years ago

#31 - Extensions report, "wide" removed, fix /0 error, more

Pull Request - State: closed - Opened by NikolayS almost 6 years ago

#30 - List of SQL reports with `\if` (pre-10 version)

Issue - State: closed - Opened by NikolayS about 6 years ago - 1 comment

#30 - List of SQL reports with `\if` (pre-10 version)

Issue - State: closed - Opened by NikolayS about 6 years ago - 1 comment

#29 - Better connection monitoring

Issue - State: open - Opened by NikolayS about 6 years ago

#29 - Better connection monitoring

Issue - State: open - Opened by NikolayS about 6 years ago

#28 - pg_buffercache report

Issue - State: open - Opened by NikolayS about 6 years ago - 2 comments
Labels: help wanted

#28 - pg_buffercache report

Issue - State: open - Opened by NikolayS about 6 years ago - 2 comments
Labels: help wanted

#27 - New report: check int2 and int4 PK columns to be out-of-capacity soon

Issue - State: closed - Opened by NikolayS about 6 years ago - 4 comments
Labels: help wanted

#27 - New report: check int2 and int4 PK columns to be out-of-capacity soon

Issue - State: closed - Opened by NikolayS about 6 years ago - 4 comments
Labels: help wanted

#26 - Fix: b4 fails if there are multiple schemas, reported by @sgrinko #21

Pull Request - State: closed - Opened by NikolayS about 6 years ago

#26 - Fix: b4 fails if there are multiple schemas, reported by @sgrinko #21

Pull Request - State: closed - Opened by NikolayS about 6 years ago

#25 - i3 fails when intarray is installed

Issue - State: closed - Opened by NikolayS about 6 years ago
Labels: bug

#25 - i3 fails when intarray is installed

Issue - State: closed - Opened by NikolayS about 6 years ago
Labels: bug

#24 - 0: add info about pg_xlog/pg_wal

Issue - State: open - Opened by NikolayS over 6 years ago - 1 comment
Labels: help wanted

#24 - 0: add info about pg_xlog/pg_wal

Issue - State: open - Opened by NikolayS over 6 years ago - 1 comment
Labels: help wanted

#23 - division by zero in report 0

Issue - State: closed - Opened by NikolayS over 6 years ago - 2 comments
Labels: bug

#22 - i2: use CONCURRENTLY when drop/create indexes

Issue - State: closed - Opened by NikolayS over 6 years ago - 1 comment

#22 - i2: use CONCURRENTLY when drop/create indexes

Issue - State: closed - Opened by NikolayS over 6 years ago - 1 comment

#21 - ошибка в b4_btree_pgstattuple.sql

Issue - State: closed - Opened by sgrinko over 6 years ago