Alexander Povolotsky
Alexander Povolotsky
Okay, I need to check pg_qualstats and find out if I'm doing something wrong and nothing is stored there? Any ideas how to check why GENERIC_PLAN is not used?
GOT IT!!! Some statements are recorded as "select * from table where field is ?" GENERIC_PLAN fails on it, expecting "select * from table where field is $1" So what...
Okay, can I do something with this?
So there's no way to store OID by pg_stat_statements and I'm advised to suggest a patch?...
For me, not working with all tried adns: newest c-ares, evdns2, libc PgBouncer 1.23.1 libevent 2.1.12-stable adns: libc-2.31 tls: unsupported
Once I'm receiving it, it's stable as hell.
Thanks a lot; I guess that should be stated explicitly, not spreaded over the documentation. Activity should be enough, but I'll increase sample rate since this is a test server.
Can't wait for it. Excellent tool! It shows graphs for what DBA needs, not graphs simplest to build.
Regarding remote setup: Add (if it's true) something like "So all overhead of metrics storage and request goes to the dedicated Powa repository" And, well, some numbers helping to set...
``` diff --git a/src/main/resources/org/schemaspy/types/pgsql.properties b/src/main/resources/org/schemaspy/types/pgsql.properties index e38932b5..9af32c15 100644 --- a/src/main/resources/org/schemaspy/types/pgsql.properties +++ b/src/main/resources/org/schemaspy/types/pgsql.properties @@ -16,12 +16,12 @@ selectViewSql=select definition as view_definition from pg_views where viewname viewTypes=VIEW,MATERIALIZED VIEW selectSchemasSql=SELECT nspname AS schema_name,...