diff --git a/collectd/files/collectd_postgresql.conf b/collectd/files/collectd_postgresql.conf
new file mode 100644
index 0000000..7943623
--- /dev/null
+++ b/collectd/files/collectd_postgresql.conf
@@ -0,0 +1,114 @@
+<LoadPlugin postgresql>
+  Globals false
+</LoadPlugin>
+
+
+<Plugin postgresql>
+    <Query deadlocks>
+      Statement "SELECT deadlocks as num_deadlocks \
+          FROM pg_stat_database \
+          WHERE datname = $1;"
+
+      Param database
+
+      <Result>
+          Type "pg_xact"
+          InstancePrefix "num_deadlocks"
+          ValuesFrom "num_deadlocks"
+      </Result>
+    </Query>
+
+    <Query stream_lag>
+        Statement "SELECT coalesce(round(extract(epoch from (now() - \
+        pg_last_xact_replay_timestamp()))),0) AS time_lag"
+        <Result>
+            Type gauge
+            InstancePrefix "replication_stream_lag"
+            ValuesFrom "time_lag"
+        </Result>
+    </Query>
+
+    <Query row_stats>
+         Statement "SELECT sum(n_tup_ins) AS inserts, \
+             sum(n_tup_upd) AS updates, \
+             sum(n_tup_del) AS deletes \
+             FROM pg_stat_user_tables"
+         <Result>
+             Type derive
+             InstancePrefix "rows_inserted"
+             ValuesFrom "inserts"
+         </Result>
+         <Result>
+             Type derive
+             InstancePrefix "rows_updated"
+             ValuesFrom "updates"
+         </Result>
+         <Result>
+             Type derive
+             InstancePrefix "rows_deleted"
+             ValuesFrom "deletes"
+         </Result>
+    </Query>
+
+    <Query client_activity>
+         Statement "SELECT count(1) AS total, \
+             sum(CASE WHEN state = 'idle' \
+             THEN 1 ELSE 0 END) AS idle, \
+             sum(CASE WHEN state LIKE 'idle in%' \
+             THEN 1 ELSE 0 END) AS trans_idle, \
+             sum(CASE WHEN state = 'active' \
+             THEN 1 ELSE 0 END) AS active, \
+             sum(CASE WHEN now()-query_start > INTERVAL '1s' \
+             AND state = 'active' THEN 1 ELSE 0 END) AS slow \
+             FROM pg_stat_activity;"
+         <Result>
+             Type gauge
+             InstancePrefix "clients_total"
+             ValuesFrom "total"
+         </Result>
+         <Result>
+             Type gauge
+             InstancePrefix "clients_idle"
+             ValuesFrom "idle"
+         </Result>
+         <Result>
+             Type gauge
+             InstancePrefix "clients_idle_transaction"
+             ValuesFrom "trans_idle"
+         </Result>
+         <Result>
+             Type gauge
+             InstancePrefix "clients_active"
+             ValuesFrom "active"
+         </Result>
+         <Result>
+             Type gauge
+             InstancePrefix "clients_slow"
+             ValuesFrom "slow"
+         </Result>
+    </Query>
+
+  {%- for db_name, db in plugin.data.iteritems() %}
+  <Database {{db_name}}>
+    Host "{{db.users.0.host}}"
+    Port "{{db.users.0.get('port', 5432)}}"
+    User "{{db.users.0.name}}"
+    Password "{{db.users.0.password}}"
+    Query row_stats
+    Query client_activity
+    Query stream_lag
+    Query deadlocks
+    Query backends
+    Query transactions
+    Query queries
+    Query queries_by_table
+    Query query_plans
+    Query table_states
+    Query query_plans_by_table
+    Query table_states_by_table
+    Query disk_io
+    Query disk_io_by_table
+    Query disk_usage
+  </Database>
+  {%- endfor %}
+</Plugin>