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.