3 ms·
I read your profile and see that you are a CTO of a fintech. Given that, by what method do you navigate that tool's [explain.dalibo.com] assertion of "It is rec
by uudecoded 3y ago
I read your profile and see that you are a CTO of a fintech. Given that, by what method do you navigate that tool's [explain.dalibo.com] assertion of "It is recommended not to send any critical or sensitive information"?
Is there an explain plan sanitizer that is helpful for this situation?
- Defman 3y agoYou can download the whole visualizer as a simple html file and use it this way. No need to obfuscate or sanitize anything at all. https://github.com/dalibo/pev2 https://github.com/dalibo/pev2
- uudecoded 3y agoThank you for sharing - I misunderstood - this is a javascript visualizer, and has no additional analytic capability beyond visualization, or did I miss something?
- Defman 3y agoYeah, you’re right. This is the visualizer that’s linked in the parent comment. I just wanted to point out that you can use it locally without sending your explain plan to anyone. Sorry for the confusion, I’ll edit my original comment.
- derhuerst 3y agoI do the same, but because it became tedious to insert the query & query plan manually, I wrote pev2-cli [1]. [1] https://github.com/derhuerst/pev2-cli https://github.com/derhuerst/pev2-cli
- williamdclt 3y agoWhatever the domain, a query isn't necessarily critical or sensitive. It only is if it contains personal information (eg querying by a bank account number or a name), or if the query itself is part of your competitive advantage (unlikely)