Grafana with pg_stat_statements

Grafana with pg_stat_statements

Grafana with pg_stat_statements In this post i describe an option to visualize the statement statistics collected by pg_stat_statments in Grafana. When using PostgreSQL you probably already know the fabulous pg_stat_statements extension. For those who don’t know it,...
Partial Restore of a Table

Partial Restore of a Table

Partial Restore of a Table Consider a case were you recognized that some entries in your production database are missing or corrupted. If you are lucky enough you have a recent backup in place, but now the question arises, how can we only restore the missing entries...
GDPR Database Security – SSL Encryption

GDPR Database Security – SSL Encryption

GDPR Database Security – SSL Encryption The General Data Protection Regulation (GDPR) is a regulation to strengthen and unify the data protection for people living in the European Union. It will become mandatory in May 2018 for all companies working with...
Monitoring PostgreSQL with Sensu

Monitoring PostgreSQL with Sensu

Monitoring PostgreSQL with Sensu Sensu is a relative new Player in the Monitoring World. Upon now i’ve monitored my PostgreSQL Infrastructurs with Nagios or Icinga 2, now it’s time to see what Sensu offers. Here i will share some experience from a test i run today. ...
Index-only Scan

Index-only Scan

Index-only Scan Was andere Datenbank-Systeme, wie Mysql oder Oracle schon seit längerem unterstützen, ist seit Version 9.2 auch für PostgreSQL verfügbar, der Index-only Scan. Kurz erklärt, ist ein Index-only Scan ein Scan der das komplette Ergebnis einer Query aus dem...
Index für LIKE-Abfragen optimieren

Index für LIKE-Abfragen optimieren

Index für LIKE-Abfragen optimieren SELECT-Statements, welche LIKE in der WHERE-Clause nutzen, können einen Index benutzen, wenn dieser mit der Option: var_char_pattern_ops erstellt wurde. Dazu ein Beispiel: CREATE DATABASE foo; CREATE TABLE test (x int, name text);...