An open API service for providing issue and pull request metadata for open source projects.

GitHub / NikolayS/postgres_dba issues and pull requests

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

Issue - State: open - Opened by dewey 10 months ago

#61 - Feature request: List reloptions

Issue - State: open - Opened by jalexandre0 almost 3 years ago

#60 - CI: test Postgres 14

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

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

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

#58 - bloat estimate precise question

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

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

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

#56 - Polish wording in the menu

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

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

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

#54 - Hello words

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

#53 - pg_stat_statements changed name colums

Issue - State: closed - Opened by oleg9301 almost 4 years ago - 1 comment

#52 - More queries

Pull Request - State: open - Opened by emerichunter almost 4 years ago

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

Pull Request - State: closed - Opened by NikolayS about 4 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 about 4 years ago - 2 comments

#49 - Feature request active and idle in transaction query

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

#48 - Support for the Postgresql 13 pg_stat_statements extension

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

#47 - t1 has one error,why?

Issue - State: open - Opened by msdnchina about 5 years ago - 1 comment
Labels: bug

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

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

#45 - Fix the section about installing

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

#44 - CircleCI tests refactoring. Support Postgres 12

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

#43 - Issue with query b1 on postgres 12

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

#42 - Improve version handling in SQL scripts.

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

#41 - How about Oracle port ?

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

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

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

#39 - Redundat indexes list

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

#38 - Issue of p1

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

#37 - pg_stat_statements "1st word" report

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

#36 - extend pg_stat_statements reports with pg_stat_kcache

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

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

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

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

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

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

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

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

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

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

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

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

Issue - State: closed - Opened by NikolayS almost 7 years ago - 1 comment

#29 - Better connection monitoring

Issue - State: open - Opened by NikolayS almost 7 years ago

#28 - pg_buffercache report

Issue - State: open - Opened by NikolayS almost 7 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 almost 7 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 almost 7 years ago

#25 - i3 fails when intarray is installed

Issue - State: closed - Opened by NikolayS almost 7 years ago
Labels: bug

#24 - 0: add info about pg_xlog/pg_wal

Issue - State: open - Opened by NikolayS about 7 years ago - 1 comment
Labels: help wanted

#23 - division by zero in report 0

Issue - State: closed - Opened by NikolayS about 7 years ago - 2 comments
Labels: bug

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

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

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

Issue - State: closed - Opened by sgrinko about 7 years ago

#20 - pg95: fix default value for postgres_dba.wide

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

#18 - [WIP] interactive config tuner

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

#17 - More reports: checkpoint info, databases, more

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

#16 - Vacuum activity

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

#15 - 2: fix "division by zero" when db is [almost] empty

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

#14 - relative include warmup.psql

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

#13 - Postgres10

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

#12 - pg v10.3 ERROR: function pg_last_xlog_receive_location() does not exist

Issue - State: closed - Opened by seadba over 7 years ago - 2 comments
Labels: bug

#11 - New report: Load Profile + tablespaces info for Table Sizes report

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

#10 - a1: end-of-row padding

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

#9 - new report: Current Activity

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

#8 - Alignment Padding report

Issue - State: closed - Opened by NikolayS over 7 years ago - 2 comments

#7 - p1: data types with typalign=c

Issue - State: closed - Opened by NikolayS over 7 years ago - 2 comments

#6 - a1: alignment padding report

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

#5 - Bloat estimation is wrong for tables with alignment padding

Issue - State: closed - Opened by NikolayS over 7 years ago - 2 comments

#4 - "extended" mode

Issue - State: closed - Opened by NikolayS over 7 years ago

#3 - Improve menu design

Issue - State: closed - Opened by NikolayS over 7 years ago

#2 - Report about missing extension nicely

Issue - State: closed - Opened by NikolayS over 7 years ago - 1 comment
Labels: enhancement, help wanted

#1 - pg_stat_statements report for older (<9.5) Postgres versions

Issue - State: closed - Opened by NikolayS over 7 years ago - 2 comments
Labels: help wanted