Schema obfuscator for performance question

[Joseph Pravato]

Good Afternoon,

We are having a performance issue with our views in PostgreSQL and based
on the requirements for assistance you recommend providing the full
table and index schema besides additional information from this site.
https://wiki.postgresql.org/wiki/Slow_Query_Questions

We have been unsuccessful in finding a tool to obfuscate the schema
before providing it for review, is there an open source tool you
recommend to use?

Thanks!

[Victor Yegorov]

Post by Joseph Pravato
We are having a performance issue with our views in PostgreSQL and based
on the requirements for assistance you recommend providing the full table
and index schema besides additional information from this site.
https://wiki.postgresql.org/wiki/Slow_Query_Questions
**
We have been unsuccessful in finding a tool to obfuscate the schema before
providing it for review, is there an open source tool you recommend to use?

You can anonymize EXPLAIN output here: http://explain.depesz.com/

Not sure bout the schema...

[Claudio Freire]

On Mon, Mar 4, 2013 at 6:31 PM, Joseph Pravato

Post by Joseph Pravato
Good Afternoon,
We are having a performance issue with our views in PostgreSQL and based on
the requirements for assistance you recommend providing the full table and
index schema besides additional information from this site.
https://wiki.postgresql.org/wiki/Slow_Query_Questions
We have been unsuccessful in finding a tool to obfuscate the schema before
providing it for review, is there an open source tool you recommend to use?
Thanks!

Without getting into the ugly business of asking why you'd want to
obfuscate schema, I can imagine a few (wrong) answers, I'll start by
noting that schema transmits meaning in the very names used, so
obfuscation, especially automatic and mindless obfuscation, will make
the problem a lot harder to review, because it will be a lot harder to
understand the schema.

So... I'd suggest, if you need obfuscation, that it should be done
manually, so that you may preserve meaningful names.