Simplify

Parallel plan

 Gather  (cost=1185.45..19261.74 rows=5311 width=32) (actual time=3.832..29.083 rows=5104 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   ->  Parallel Bitmap Heap Scan on benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293  (cost=185.45..17730.64 rows=2213 width=32) (actual time=1.166..6.391 rows=1701 loops=3)
         Recheck Cond: (the_geom_webmercator && '01030000A0110F000001000000050000007C39382FE1AF5FC106722D878A79524100000000000000007C39382FE1AF5FC158DE886016D9524100000000000000002ACDDC5555505FC158DE886016D9524100000000000000002ACDDC5555505FC106722D878A79524100000000000000007C39382FE1AF5FC106722D878A7952410000000000000000'::geometry)
         Heap Blocks: exact=3924
         ->  Bitmap Index Scan on table_2015streettreescensus_trees_1_the_geom_webmercator_idx  (cost=0.00..184.12 rows=5311 width=0) (actual time=2.234..2.234 rows=5104 loops=1)
               Index Cond: (the_geom_webmercator && '01030000A0110F000001000000050000007C39382FE1AF5FC106722D878A79524100000000000000007C39382FE1AF5FC158DE886016D9524100000000000000002ACDDC5555505FC158DE886016D9524100000000000000002ACDDC5555505FC106722D878A79524100000000000000007C39382FE1AF5FC106722D878A7952410000000000000000'::geometry)
 Planning time: 0.302 ms
 Execution time: 33.065 ms

Query

SELECT ST_AsTWKB(ST_Simplify(ST_RemoveRepeatedPoints("the_geom_webmercator",10),10,true),-1) AS geom FROM (select * from benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293) as cdbq WHERE "the_geom_webmercator" && ST_SetSRID('BOX3D(-8306564.737806674 4843050.112148767,-8208725.341601649 4940889.508353792)'::box3d, 3857)

Sequential plan

     QUERY PLAN                                                                                                                                                                  
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on benchmark_7773a711c8441d4b494a51fd9feebeac7a9b9c734619398620293  (cost=160.10..14591.85 rows=4621 width=32) (actual time=2.375..12.481 rows=5104 loops=1)
   Recheck Cond: (the_geom_webmercator && '01030000A0110F000001000000050000007C39382FE1AF5FC106722D878A79524100000000000000007C39382FE1AF5FC158DE886016D9524100000000000000002ACDDC5555505FC158DE886016D9524100000000000000002ACDDC5555505FC106722D878A79524100000000000000007C39382FE1AF5FC106722D878A7952410000000000000000'::geometry)
   Heap Blocks: exact=3931
   ->  Bitmap Index Scan on table_2015streettreescensus_trees_the_geom_webmercator_idx  (cost=0.00..158.94 rows=4621 width=0) (actual time=1.462..1.462 rows=5104 loops=1)
         Index Cond: (the_geom_webmercator && '01030000A0110F000001000000050000007C39382FE1AF5FC106722D878A79524100000000000000007C39382FE1AF5FC158DE886016D9524100000000000000002ACDDC5555505FC158DE886016D9524100000000000000002ACDDC5555505FC106722D878A79524100000000000000007C39382FE1AF5FC106722D878A7952410000000000000000'::geometry)
 Planning Time: 0.290 ms
 Execution Time: 12.886 ms
(7 rows)