A colleague recently let me know that anonymization in explain.depesz.com doesn't handle CTE names. For example, in plan:
QUERY PLAN --------------------------------------------------------------------------------------------------- CTE Scan ON some_name (cost=0.01..0.03 ROWS=1 width=8) (actual TIME=0.027..0.028 ROWS=1 loops=1) CTE some_name -> RESULT (cost=0.00..0.01 ROWS=1 width=0) (actual TIME=0.023..0.023 ROWS=1 loops=1) Planning TIME: 0.217 ms Execution TIME: 0.124 ms (5 ROWS)
“some_name" was kept even if anonymization was turned on.
Now it's fixed, and new code should properly anonymize all CTE names. Of course the change is live on explain.depesz.com too.