Sha256: 22527c98b31ea1ab2f87254de33ec57d9bb4b845cf955fd85cb2701e6cd26b06

Contents?: true

Size: 938 Bytes

Versions: 32

Compression:

Stored size: 938 Bytes

Contents

# PostgreSQL explain plan obfuscation tests

These tests show how explain plans for PostgreSQL should be obfuscated when
SQL obfuscation is enabled. Obfuscation of explain plans for PostgreSQL is
necessary because they can include portions of the original query that may
contain sensitive data.

Each test case consists of a set of files with the following extensions:

* `.query.txt` - the original SQL query that is being explained
* `.explain.txt` - the raw un-obfuscated output from running `EXPLAIN <query>`
* `.colon_obfuscated.txt` - the desired obfuscated explain output if using the
default, more aggressive obfuscation strategy described [here](https://newrelic.atlassian.net/wiki/display/eng/Obfuscating+PostgreSQL+Explain+plans).
* `.obfuscated.txt` - the desired obfuscated explain output if using a more
accurate, less aggressive obfuscation strategy detailed in this
[Jive thread](https://newrelic.jiveon.com/thread/1851).

Version data entries

32 entries across 32 versions & 2 rubygems

Version Path
newrelic_rpm-4.1.0.333 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-4.0.0.332 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.18.1.330 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.18.0.329 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.17.2.327 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.17.1.326 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.17.0.325 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.16.3.323 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.16.2.321 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.16.1.320 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.16.0.318 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
ish_lib_manager-0.0.1 test/dummy/vendor/bundle/ruby/2.3.0/gems/newrelic_rpm-3.15.2.317/test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.15.2.317 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.15.1.316 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.15.0.314 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.14.3.313 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.14.2.312 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.14.1.311 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.14.0.305 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md
newrelic_rpm-3.13.2.302 test/fixtures/cross_agent_tests/postgres_explain_obfuscation/README.md