June 8th, 2014 by depesz | Tags: , , , | Comments Off on Anonymize CTE names on explain.depesz.com
Did it help? If yes - maybe you can help me?

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.

Sorry, comments for this post are disabled.