SHARE
TWEET

Untitled

a guest Apr 23rd, 2019 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Append  (cost=4.11..275961.72 rows=16 width=32) (actual time=95.132..116.464 rows=16 loops=1)
  2.    ->  Aggregate  (cost=4.11..4.12 rows=1 width=32) (actual time=95.114..95.127 rows=1 loops=1)
  3.          ->  Append  (cost=0.00..3.95 rows=27 width=3447) (actual time=0.410..54.326 rows=27 loops=1)
  4.                ->  Append  (cost=0.00..3.54 rows=27 width=3447) (actual time=0.393..53.961 rows=27 loops=1)
  5.                      ->  Seq Scan on ne_110m_ocean  (cost=0.00..1.03 rows=2 width=41832) (actual time=0.375..51.364 rows=2 loops=1)
  6.                            Filter: ((geometry && '0103000000010000000500000093107C45F81B73C196107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B734193107C45F81B734193107C45F81B734196107C45F81B73C193107C45F81B73C196107C45F81B73C1':
  7. :geometry) AND (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 4, true) IS NOT NULL))
  8.                      ->  Seq Scan on ne_110m_lakes  (cost=0.00..2.38 rows=25 width=376) (actual time=0.159..2.227 rows=25 loops=1)
  9.                            Filter: ((geometry && '0103000000010000000500000093107C45F81B73C196107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B734193107C45F81B734193107C45F81B734196107C45F81B73C193107C45F81B73C196107C45F81B73C1':
  10. :geometry) AND (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 4, true) IS NOT NULL))
  11.    ->  Aggregate  (cost=173679.19..173679.20 rows=1 width=32) (actual time=0.213..0.226 rows=1 loops=1)
  12.          ->  Append  (cost=0.00..173673.93 rows=9 width=194) (actual time=0.199..0.205 rows=0 loops=1)
  13.                ->  Result  (cost=0.00..3.16 rows=1 width=1604) (actual time=0.007..0.013 rows=0 loops=1)
  14.                      One-Time Filter: false
  15.                      ->  Seq Scan on ne_110m_rivers_lake_centerlines  (cost=0.00..3.16 rows=1 width=1442) (never executed)
  16.                            Filter: ((featurecla)::text = 'River'::text)
  17.                ->  Result  (cost=0.00..66.78 rows=1 width=1094) (actual time=0.007..0.013 rows=0 loops=1)
  18.                      One-Time Filter: false
  19.                      ->  Seq Scan on ne_50m_rivers_lake_centerlines  (cost=0.00..66.78 rows=1 width=932) (never executed)
  20.                            Filter: ((featurecla)::text = 'River'::text)
  21.                ->  Result  (cost=0.00..446.19 rows=1 width=3023) (actual time=0.007..0.013 rows=0 loops=1)
  22.                      One-Time Filter: false
  23.                      ->  Seq Scan on ne_10m_rivers_lake_centerlines  (cost=0.00..446.19 rows=1 width=2861) (never executed)
  24.                            Filter: ((featurecla)::text = 'River'::text)
  25.                ->  Subquery Scan on "*SELECT* 4"  (cost=0.00..0.00 rows=1 width=194) (actual time=0.020..0.026 rows=0 loops=1)
  26.                      ->  Result  (cost=0.00..0.00 rows=0 width=194) (actual time=0.006..0.013 rows=0 loops=1)
  27.                            One-Time Filter: false
  28.                ->  Subquery Scan on "*SELECT* 5"  (cost=0.00..0.00 rows=1 width=194) (actual time=0.019..0.025 rows=0 loops=1)
  29.                      ->  Result  (cost=0.00..0.00 rows=0 width=194) (actual time=0.006..0.013 rows=0 loops=1)
  30.                            One-Time Filter: false
  31.                ->  Subquery Scan on "*SELECT* 6"  (cost=0.00..0.00 rows=1 width=194) (actual time=0.019..0.025 rows=0 loops=1)
  32.                      ->  Result  (cost=0.00..0.00 rows=0 width=194) (actual time=0.006..0.013 rows=0 loops=1)
  33.                            One-Time Filter: false
  34.                ->  Subquery Scan on "*SELECT* 7"  (cost=0.00..85820.53 rows=1 width=904) (actual time=0.019..0.025 rows=0 loops=1)
  35.                      ->  Result  (cost=0.00..85820.52 rows=1 width=816) (actual time=0.006..0.013 rows=0 loops=1)
  36.                            One-Time Filter: false
  37.                            ->  Seq Scan on osm_waterway_linestring  (cost=0.00..85820.52 rows=1 width=790) (never executed)
  38.                                  Filter: ((waterway)::text = ANY ('{river,canal}'::text[]))
  39.                ->  Subquery Scan on "*SELECT* 8"  (cost=0.00..87337.19 rows=1 width=904) (actual time=0.019..0.025 rows=0 loops=1)
  40.                      ->  Result  (cost=0.00..87337.18 rows=1 width=816) (actual time=0.006..0.013 rows=0 loops=1)
  41.                            One-Time Filter: false
  42.                            ->  Seq Scan on osm_waterway_linestring osm_waterway_linestring_1  (cost=0.00..87337.18 rows=1 width=790) (never executed)
  43.                                  Filter: ((waterway)::text = ANY ('{river,canal,stream,drain,ditch}'::text[]))
  44.                ->  Subquery Scan on "*SELECT* 9"  (cost=0.00..0.00 rows=1 width=194) (actual time=0.019..0.025 rows=0 loops=1)
  45.                      ->  Result  (cost=0.00..0.00 rows=0 width=194) (actual time=0.006..0.013 rows=0 loops=1)
  46.                            One-Time Filter: false
  47.    ->  Aggregate  (cost=2.90..2.91 rows=1 width=32) (actual time=9.060..9.072 rows=1 loops=1)
  48.          ->  Append  (cost=0.00..1.38 rows=21 width=168) (actual time=0.102..4.592 rows=11 loops=1)
  49.                ->  Seq Scan on ne_110m_glaciated_areas  (cost=0.00..1.17 rows=11 width=1376) (actual time=0.089..4.195 rows=11 loops=1)
  50.                      Filter: ((geometry && '0103000000010000000500000093107C45F81B73C196107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B734193107C45F81B734193107C45F81B734196107C45F81B73C193107C45F81B73C196107C45F81B73C1'::geome
  51. try) AND (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 4, true) IS NOT NULL))
  52.                ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.007..0.013 rows=0 loops=1)
  53.                      One-Time Filter: false
  54.                ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.007..0.013 rows=0 loops=1)
  55.                      One-Time Filter: false
  56.                ->  Subquery Scan on "*SELECT* 4_1"  (cost=0.00..0.00 rows=1 width=168) (actual time=0.019..0.026 rows=0 loops=1)
  57.                      ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.007..0.013 rows=0 loops=1)
  58.                            One-Time Filter: false
  59.                ->  Subquery Scan on "*SELECT* 5_1"  (cost=0.00..0.00 rows=1 width=168) (actual time=0.019..0.025 rows=0 loops=1)
  60.                      ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.006..0.013 rows=0 loops=1)
  61.                            One-Time Filter: false
  62.                ->  Subquery Scan on "*SELECT* 6_1"  (cost=0.00..0.00 rows=1 width=168) (actual time=0.020..0.026 rows=0 loops=1)
  63.                      ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.007..0.013 rows=0 loops=1)
  64.                            One-Time Filter: false
  65.                ->  Subquery Scan on "*SELECT* 7_1"  (cost=0.00..0.00 rows=1 width=168) (actual time=0.019..0.025 rows=0 loops=1)
  66.                      ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.006..0.013 rows=0 loops=1)
  67.                            One-Time Filter: false
  68.                ->  Subquery Scan on "*SELECT* 8_1"  (cost=0.00..0.00 rows=1 width=168) (actual time=0.019..0.026 rows=0 loops=1)
  69.                      ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.006..0.013 rows=0 loops=1)
  70.                            One-Time Filter: false
  71.                ->  Subquery Scan on "*SELECT* 9_1"  (cost=0.00..0.00 rows=1 width=168) (actual time=0.019..0.025 rows=0 loops=1)
  72.                      ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.006..0.013 rows=0 loops=1)
  73.                            One-Time Filter: false
  74.                ->  Subquery Scan on "*SELECT* 10"  (cost=0.00..0.00 rows=1 width=168) (actual time=0.020..0.026 rows=0 loops=1)
  75.                      ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.007..0.013 rows=0 loops=1)
  76.                            One-Time Filter: false
  77.                ->  Subquery Scan on "*SELECT* 11"  (cost=0.00..0.00 rows=1 width=168) (actual time=0.019..0.025 rows=0 loops=1)
  78.                      ->  Result  (cost=0.00..0.00 rows=0 width=168) (actual time=0.007..0.013 rows=0 loops=1)
  79.                            One-Time Filter: false
  80.    ->  Aggregate  (cost=118.09..118.10 rows=1 width=32) (actual time=0.214..0.226 rows=1 loops=1)
  81.          ->  Append  (cost=0.00..117.84 rows=9 width=172) (actual time=0.199..0.205 rows=0 loops=1)
  82.                ->  Result  (cost=0.00..117.79 rows=1 width=414) (actual time=0.006..0.013 rows=0 loops=1)
  83.                      One-Time Filter: false
  84.                      ->  Seq Scan on ne_50m_urban_areas  (cost=0.00..117.79 rows=1 width=278) (never executed)
  85.                            Filter: (scalerank <= 2)
  86.                ->  Result  (cost=0.00..0.00 rows=0 width=172) (actual time=0.007..0.013 rows=0 loops=1)
  87.                      One-Time Filter: false
  88.                ->  Result  (cost=0.00..0.00 rows=0 width=172) (actual time=0.006..0.013 rows=0 loops=1)
  89.                      One-Time Filter: false
  90.                ->  Subquery Scan on "*SELECT* 4_2"  (cost=0.00..0.00 rows=1 width=172) (actual time=0.019..0.025 rows=0 loops=1)
  91.                      ->  Result  (cost=0.00..0.00 rows=0 width=172) (actual time=0.006..0.013 rows=0 loops=1)
  92.                            One-Time Filter: false
  93.                ->  Subquery Scan on "*SELECT* 5_2"  (cost=0.00..0.00 rows=1 width=172) (actual time=0.019..0.025 rows=0 loops=1)
  94.                      ->  Result  (cost=0.00..0.00 rows=0 width=172) (actual time=0.006..0.013 rows=0 loops=1)
  95.                            One-Time Filter: false
  96.                ->  Subquery Scan on "*SELECT* 6_2"  (cost=0.00..0.00 rows=1 width=172) (actual time=0.019..0.025 rows=0 loops=1)
  97.                      ->  Result  (cost=0.00..0.00 rows=0 width=172) (actual time=0.006..0.013 rows=0 loops=1)
  98.                            One-Time Filter: false
  99.                ->  Subquery Scan on "*SELECT* 7_2"  (cost=0.00..0.00 rows=1 width=172) (actual time=0.019..0.025 rows=0 loops=1)
  100.                      ->  Result  (cost=0.00..0.00 rows=0 width=172) (actual time=0.006..0.013 rows=0 loops=1)
  101.                            One-Time Filter: false
  102.                ->  Subquery Scan on "*SELECT* 8_2"  (cost=0.00..0.00 rows=1 width=172) (actual time=0.019..0.025 rows=0 loops=1)
  103.                      ->  Result  (cost=0.00..0.00 rows=0 width=172) (actual time=0.006..0.013 rows=0 loops=1)
  104.                            One-Time Filter: false
  105.                ->  Subquery Scan on "*SELECT* 9_2"  (cost=0.00..0.00 rows=1 width=172) (actual time=0.019..0.025 rows=0 loops=1)
  106.                      ->  Result  (cost=0.00..0.00 rows=0 width=172) (actual time=0.006..0.013 rows=0 loops=1)
  107.                            One-Time Filter: false
  108.    ->  Aggregate  (cost=0.36..0.37 rows=1 width=32) (actual time=0.041..0.053 rows=1 loops=1)
  109.          ->  Sort  (cost=0.01..0.02 rows=0 width=180) (actual time=0.027..0.034 rows=0 loops=1)
  110.                Sort Key: rank
  111.                Sort Method: quicksort  Memory: 25kB
  112.                ->  Result  (cost=0.00..0.00 rows=0 width=180) (actual time=0.007..0.013 rows=0 loops=1)
  113.                      One-Time Filter: false
  114.    ->  Aggregate  (cost=0.36..0.37 rows=1 width=32) (actual time=0.078..0.091 rows=1 loops=1)
  115.          ->  Append  (cost=0.01..0.02 rows=1 width=196) (actual time=0.064..0.070 rows=0 loops=1)
  116.                ->  Subquery Scan on "*SELECT* 2"  (cost=0.01..0.02 rows=1 width=196) (actual time=0.051..0.057 rows=0 loops=1)
  117.                      Filter: (st_asmvtgeom("*SELECT* 2".geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 4, true) IS NOT NULL)
  118.                      ->  WindowAgg  (cost=0.01..0.02 rows=0 width=242) (actual time=0.038..0.044 rows=0 loops=1)
  119.                            ->  Sort  (cost=0.01..0.02 rows=0 width=262) (actual time=0.024..0.030 rows=0 loops=1)
  120.                                  Sort Key: (labelgrid(geometry_point, '25600'::numeric)), (CASE WHEN ((boundary)::text = 'national_park'::text) THEN true ELSE false END) DESC, ((COALESCE(NULLIF((tags -> 'wikipedia'::text), ''::text), NULL
  121. IF((tags -> 'wikidata'::text), ''::text)) IS NOT NULL)) DESC, area DESC
  122.                                  Sort Method: quicksort  Memory: 25kB
  123.                                  ->  Result  (cost=0.00..0.00 rows=0 width=262) (actual time=0.007..0.013 rows=0 loops=1)
  124.                                        One-Time Filter: false
  125.    ->  Aggregate  (cost=100177.55..100177.56 rows=1 width=32) (actual time=8.062..8.075 rows=1 loops=1)
  126.          ->  Append  (cost=0.00..100175.62 rows=191 width=278) (actual time=0.056..5.100 rows=186 loops=1)
  127.                ->  Seq Scan on ne_110m_admin_0_boundary_lines_land  (cost=0.00..11.79 rows=185 width=281) (actual time=0.042..2.655 rows=186 loops=1)
  128.                      Filter: ((geometry && '0103000000010000000500000093107C45F81B73C196107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B734193107C45F81B734193107C45F81B734196107C45F81B73C193107C45F81B73C196107C45F81B73C1'::geome
  129. try) AND (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 4, true) IS NOT NULL))
  130.                ->  Result  (cost=0.00..3155.24 rows=1 width=96) (actual time=0.007..0.014 rows=0 loops=1)
  131.                      One-Time Filter: false
  132.                      ->  Seq Scan on osm_border_linestring_gen8  (cost=0.00..3155.24 rows=1 width=96) (never executed)
  133.                            Filter: (admin_level <= 4)
  134.                ->  Result  (cost=0.00..3492.24 rows=1 width=120) (actual time=0.007..0.013 rows=0 loops=1)
  135.                      One-Time Filter: false
  136.                      ->  Seq Scan on osm_border_linestring_gen7  (cost=0.00..3492.24 rows=1 width=120) (never executed)
  137.                            Filter: (admin_level <= 4)
  138.                ->  Result  (cost=0.00..4056.24 rows=1 width=159) (actual time=0.007..0.013 rows=0 loops=1)
  139.                      One-Time Filter: false
  140.                      ->  Seq Scan on osm_border_linestring_gen6  (cost=0.00..4056.24 rows=1 width=159) (never executed)
  141.                            Filter: (admin_level <= 4)
  142.                ->  Result  (cost=0.00..14835.31 rows=1 width=199) (actual time=0.007..0.013 rows=0 loops=1)
  143.                      One-Time Filter: false
  144.                      ->  Seq Scan on osm_border_linestring_gen5  (cost=0.00..14835.31 rows=1 width=199) (never executed)
  145.                            Filter: (admin_level <= 6)
  146.                ->  Result  (cost=0.00..18248.31 rows=1 width=264) (actual time=0.006..0.013 rows=0 loops=1)
  147.                      One-Time Filter: false
  148.                      ->  Seq Scan on osm_border_linestring_gen4  (cost=0.00..18248.31 rows=1 width=264) (never executed)
  149.                            Filter: (admin_level <= 6)
  150.                ->  Result  (cost=0.00..56373.62 rows=1 width=289) (actual time=0.006..0.013 rows=0 loops=1)
  151.                      One-Time Filter: false
  152.                      ->  Seq Scan on osm_border_linestring_gen3  (cost=0.00..56373.62 rows=1 width=289) (never executed)
  153.                            Filter: (admin_level <= 8)
  154.    ->  Aggregate  (cost=0.03..0.04 rows=1 width=32) (actual time=0.022..0.034 rows=1 loops=1)
  155.          ->  Result  (cost=0.00..0.00 rows=0 width=96) (actual time=0.007..0.013 rows=0 loops=1)
  156.                One-Time Filter: false
  157.    ->  Aggregate  (cost=13.13..13.14 rows=1 width=32) (actual time=0.478..0.491 rows=1 loops=1)
  158.          ->  Sort  (cost=12.76..12.81 rows=20 width=192) (actual time=0.464..0.470 rows=0 loops=1)
  159.                Sort Key: zoom_levels.z_order
  160.                Sort Method: quicksort  Memory: 25kB
  161.                ->  Subquery Scan on zoom_levels  (cost=0.00..12.32 rows=20 width=192) (actual time=0.445..0.451 rows=0 loops=1)
  162.                      ->  Append  (cost=0.00..0.12 rows=20 width=285) (actual time=0.432..0.438 rows=0 loops=1)
  163.                            ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.007..0.013 rows=0 loops=1)
  164.                                  One-Time Filter: false
  165.                            ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.006..0.013 rows=0 loops=1)
  166.                                  One-Time Filter: false
  167.                            ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.007..0.013 rows=0 loops=1)
  168.                                  One-Time Filter: false
  169.                            ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.007..0.013 rows=0 loops=1)
  170.                                  One-Time Filter: false
  171.                            ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.006..0.013 rows=0 loops=1)
  172.                                  One-Time Filter: false
  173.                            ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.006..0.013 rows=0 loops=1)
  174.                                  One-Time Filter: false
  175.                            ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.006..0.013 rows=0 loops=1)
  176.                                  One-Time Filter: false
  177.                            ->  Subquery Scan on "*SELECT* 8_3"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  178.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.006..0.013 rows=0 loops=1)
  179.                                        One-Time Filter: false
  180.                            ->  Subquery Scan on "*SELECT* 9_3"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  181.                                  ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.006..0.013 rows=0 loops=1)
  182.                                        One-Time Filter: false
  183.                            ->  Subquery Scan on "*SELECT* 10_1"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.020..0.026 rows=0 loops=1)
  184.                                  ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.007..0.013 rows=0 loops=1)
  185.                                        One-Time Filter: false
  186.                            ->  Subquery Scan on "*SELECT* 11_1"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  187.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.006..0.013 rows=0 loops=1)
  188.                                        One-Time Filter: false
  189.                            ->  Subquery Scan on "*SELECT* 12"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  190.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.007..0.013 rows=0 loops=1)
  191.                                        One-Time Filter: false
  192.                            ->  Subquery Scan on "*SELECT* 13"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  193.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.006..0.013 rows=0 loops=1)
  194.                                        One-Time Filter: false
  195.                            ->  Subquery Scan on "*SELECT* 14"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  196.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.006..0.013 rows=0 loops=1)
  197.                                        One-Time Filter: false
  198.                            ->  Subquery Scan on "*SELECT* 15"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  199.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.006..0.013 rows=0 loops=1)
  200.                                        One-Time Filter: false
  201.                            ->  Subquery Scan on "*SELECT* 16"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  202.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.007..0.013 rows=0 loops=1)
  203.                                        One-Time Filter: false
  204.                            ->  Subquery Scan on "*SELECT* 17"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  205.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.007..0.013 rows=0 loops=1)
  206.                                        One-Time Filter: false
  207.                            ->  Subquery Scan on "*SELECT* 18"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  208.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.007..0.013 rows=0 loops=1)
  209.                                        One-Time Filter: false
  210.                            ->  Subquery Scan on "*SELECT* 19"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  211.                                  ->  Result  (cost=0.00..0.00 rows=0 width=283) (actual time=0.006..0.013 rows=0 loops=1)
  212.                                        One-Time Filter: false
  213.                            ->  Subquery Scan on "*SELECT* 20"  (cost=0.00..0.00 rows=1 width=285) (actual time=0.019..0.025 rows=0 loops=1)
  214.                                  ->  Result  (cost=0.00..0.00 rows=0 width=285) (actual time=0.006..0.013 rows=0 loops=1)
  215.                                        One-Time Filter: false
  216.    ->  Aggregate  (cost=0.10..0.11 rows=1 width=32) (actual time=0.101..0.113 rows=1 loops=1)
  217.          ->  Sort  (cost=0.06..0.06 rows=1 width=57) (actual time=0.087..0.093 rows=0 loops=1)
  218.                Sort Key: "*SELECT* 2_1".render_height, (st_ymin(("*SELECT* 2_1".geometry)::box3d)) DESC
  219.                Sort Method: quicksort  Memory: 25kB
  220.                ->  Result  (cost=0.01..0.05 rows=1 width=57) (actual time=0.071..0.077 rows=0 loops=1)
  221.                      ->  Append  (cost=0.01..0.03 rows=1 width=41) (actual time=0.059..0.065 rows=0 loops=1)
  222.                            ->  Subquery Scan on "*SELECT* 2_1"  (cost=0.01..0.03 rows=1 width=41) (actual time=0.046..0.053 rows=0 loops=1)
  223.                                  Filter: (st_asmvtgeom("*SELECT* 2_1".geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 4, true) IS NOT NULL)
  224.                                  ->  Unique  (cost=0.01..0.02 rows=1 width=49) (actual time=0.034..0.040 rows=0 loops=1)
  225.                                        ->  Sort  (cost=0.01..0.02 rows=0 width=49) (actual time=0.021..0.027 rows=0 loops=1)
  226.                                              Sort Key: osm_id
  227.                                              Sort Method: quicksort  Memory: 25kB
  228.                                              ->  Result  (cost=0.00..0.00 rows=0 width=49) (actual time=0.007..0.013 rows=0 loops=1)
  229.                                                    One-Time Filter: false
  230.    ->  Aggregate  (cost=326.20..326.21 rows=1 width=32) (actual time=2.230..2.242 rows=1 loops=1)
  231.          ->  Function Scan on layer_water_name  (cost=0.25..12.75 rows=995 width=200) (actual time=2.213..2.219 rows=0 loops=1)
  232.                Filter: (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 256, true) IS NOT NULL)
  233.    ->  Aggregate  (cost=0.36..0.37 rows=1 width=32) (actual time=0.036..0.048 rows=1 loops=1)
  234.          ->  Sort  (cost=0.01..0.02 rows=0 width=316) (actual time=0.022..0.028 rows=0 loops=1)
  235.                Sort Key: z_order
  236.                Sort Method: quicksort  Memory: 25kB
  237.                ->  Result  (cost=0.00..0.00 rows=0 width=316) (actual time=0.007..0.013 rows=0 loops=1)
  238.                      One-Time Filter: false
  239.    ->  Aggregate  (cost=50.47..50.48 rows=1 width=32) (actual time=0.276..0.289 rows=1 loops=1)
  240.          ->  Sort  (cost=22.60..22.82 rows=85 width=240) (actual time=0.184..0.197 rows=1 loops=1)
  241.                Sort Key: (1)
  242.                Sort Method: quicksort  Memory: 27kB
  243.                ->  Append  (cost=0.00..19.88 rows=85 width=240) (actual time=0.060..0.166 rows=1 loops=1)
  244.                      ->  Seq Scan on osm_continent_point  (cost=0.00..16.60 rows=80 width=240) (actual time=0.009..0.016 rows=0 loops=1)
  245.                            Filter: ((geometry && '0103000000010000000500000093107C45F81B73C196107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B734193107C45F81B734193107C45F81B734196107C45F81B73C193107C45F81B73C196107C45F81B73C1':
  246. :geometry) AND (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 256, true) IS NOT NULL))
  247.                      ->  Subquery Scan on "*SELECT* 2_2"  (cost=0.00..1.04 rows=1 width=1767) (actual time=0.031..0.057 rows=1 loops=1)
  248.                            ->  Seq Scan on osm_country_point  (cost=0.00..1.03 rows=1 width=1738) (actual time=0.018..0.031 rows=1 loops=1)
  249.                                  Filter: ((geometry && '0103000000010000000500000093107C45F81B73C196107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B734193107C45F81B734193107C45F81B734196107C45F81B73C193107C45F81B73C196107C45F81B
  250. 73C1'::geometry) AND (rank <= 1) AND ((name)::text <> ''::text) AND (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 256, true) IS NOT NULL))
  251.                      ->  Seq Scan on osm_state_point  (cost=0.00..1.01 rows=1 width=240) (actual time=0.010..0.017 rows=0 loops=1)
  252.                            Filter: ((geometry && '0103000000010000000500000093107C45F81B73C196107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B734193107C45F81B734193107C45F81B734196107C45F81B73C193107C45F81B73C196107C45F81B73C1':
  253. :geometry) AND ((name)::text <> ''::text) AND (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 256, true) IS NOT NULL) AND ((rank + 2) <= 0) AND (((is_in_country)::text = A
  254. NY ('{"United Kingdom",USA,Россия,Brasil,China,India}'::text[])) OR ((is_in_country_code)::text = ANY ('{AU,CN,IN,BR,US}'::text[]))))
  255.                      ->  Result  (cost=0.00..0.00 rows=0 width=240) (actual time=0.007..0.013 rows=0 loops=1)
  256.                            One-Time Filter: false
  257.                      ->  Result  (cost=0.00..0.00 rows=0 width=240) (actual time=0.006..0.013 rows=0 loops=1)
  258.                            One-Time Filter: false
  259.                      ->  Subquery Scan on "*SELECT* 6_3"  (cost=0.00..0.00 rows=1 width=240) (actual time=0.019..0.025 rows=0 loops=1)
  260.                            ->  Result  (cost=0.00..0.00 rows=0 width=240) (actual time=0.007..0.013 rows=0 loops=1)
  261.                                  One-Time Filter: false
  262.    ->  Aggregate  (cost=1554.81..1554.82 rows=1 width=32) (actual time=0.021..0.033 rows=1 loops=1)
  263.          ->  Result  (cost=0.00..1554.78 rows=1 width=39) (actual time=0.007..0.013 rows=0 loops=1)
  264.                One-Time Filter: false
  265.                ->  Seq Scan on osm_housenumber_point  (cost=0.00..1554.78 rows=1 width=39) (never executed)
  266.                      Filter: (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 8, true) IS NOT NULL)
  267.    ->  Aggregate  (cost=0.37..0.38 rows=1 width=32) (actual time=0.077..0.089 rows=1 loops=1)
  268.          ->  Subquery Scan on layer_poi  (cost=0.03..0.03 rows=1 width=252) (actual time=0.063..0.069 rows=0 loops=1)
  269.                Filter: (st_asmvtgeom(layer_poi.geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 64, true) IS NOT NULL)
  270.                ->  Sort  (cost=0.03..0.03 rows=0 width=288) (actual time=0.050..0.056 rows=0 loops=1)
  271.                      Sort Key: ((row_number() OVER (?))::integer)
  272.                      Sort Method: quicksort  Memory: 25kB
  273.                      ->  WindowAgg  (cost=0.01..0.02 rows=0 width=288) (actual time=0.035..0.042 rows=0 loops=1)
  274.                            ->  Sort  (cost=0.01..0.02 rows=0 width=377) (actual time=0.022..0.028 rows=0 loops=1)
  275.                                  Sort Key: (labelgrid(geometry, '25600'::numeric)), (CASE WHEN ((name)::text = ''::text) THEN 2000 ELSE CASE CASE WHEN ((subclass)::text = ANY ('{accessories,antiques,beauty,bed,boutique,camera,carpet,chari
  276. ty,chemist,chocolate,coffee,computer,confectionery,convenience,copyshop,cosmetics,garden_centre,doityourself,erotic,electronics,fabric,florist,frozen_food,furniture,video_games,video,general,gift,hardware,hearing_aids,hifi,ice_cream,inter
  277. ior_decoration,jewelry,kiosk,lamps,mall,massage,motorcycle,mobile_phone,newsagent,optician,outdoor,perfumery,perfume,pet,photo,second_hand,shoes,sports,stationery,tailor,tattoo,ticket,tobacco,toys,travel_agency,watches,weapons,wholesale}'
  278. ::text[])) THEN 'shop'::text WHEN ((subclass)::text = ANY ('{townhall,public_building,courthouse,community_centre}'::text[])) THEN 'town_hall'::text WHEN ((subclass)::text = ANY ('{golf,golf_course,miniature_golf}'::text[])) THEN 'golf'::
  279. text WHEN ((subclass)::text = ANY ('{fast_food,food_court}'::text[])) THEN 'fast_food'::text WHEN ((subclass)::text = ANY ('{park,bbq}'::text[])) THEN 'park'::text WHEN ((subclass)::text = ANY ('{bus_stop,bus_station}'::text[])) THEN 'bus
  280. '::text WHEN ((((subclass)::text = 'station'::text) AND ((mapping_key)::text = 'railway'::text)) OR ((subclass)::text = ANY ('{halt,tram_stop,subway}'::text[]))) THEN 'railway'::text WHEN (((subclass)::text = 'station'::text) AND ((mappin
  281. g_key)::text = 'aerialway'::text)) THEN 'aerialway'::text WHEN ((subclass)::text = ANY ('{subway_entrance,train_station_entrance}'::text[])) THEN 'entrance'::text WHEN ((subclass)::text = ANY ('{camp_site,caravan_site}'::text[])) THEN 'ca
  282. mpsite'::text WHEN ((subclass)::text = ANY ('{laundry,dry_cleaning}'::text[])) THEN 'laundry'::text WHEN ((subclass)::text = ANY ('{supermarket,deli,delicatessen,department_store,greengrocer,marketplace}'::text[])) THEN 'grocery'::text WH
  283. EN ((subclass)::text = ANY ('{books,library}'::text[])) THEN 'library'::text WHEN ((subclass)::text = ANY ('{university,college}'::text[])) THEN 'college'::text WHEN ((subclass)::text = ANY ('{hotel,motel,bed_and_breakfast,guest_house,hos
  284. tel,chalet,alpine_hut,camp_site}'::text[])) THEN 'lodging'::text WHEN ((subclass)::text = ANY ('{chocolate,confectionery}'::text[])) THEN 'ice_cream'::text WHEN ((subclass)::text = ANY ('{post_box,post_office}'::text[])) THEN 'post'::text
  285.  WHEN ((subclass)::text = 'cafe'::text) THEN 'cafe'::text WHEN ((subclass)::text = ANY ('{school,kindergarten}'::text[])) THEN 'school'::text WHEN ((subclass)::text = ANY ('{alcohol,beverages,wine}'::text[])) THEN 'alcohol_shop'::text WHE
  286. N ((subclass)::text = ANY ('{bar,nightclub}'::text[])) THEN 'bar'::text WHEN ((subclass)::text = ANY ('{marina,dock}'::text[])) THEN 'harbor'::text WHEN ((subclass)::text = ANY ('{car,car_repair,taxi}'::text[])) THEN 'car'::text WHEN ((su
  287. bclass)::text = ANY ('{hospital,nursing_home,clinic}'::text[])) THEN 'hospital'::text WHEN ((subclass)::text = ANY ('{grave_yard,cemetery}'::text[])) THEN 'cemetery'::text WHEN ((subclass)::text = ANY ('{attraction,viewpoint}'::text[])) T
  288. HEN 'attraction'::text WHEN ((subclass)::text = ANY ('{biergarten,pub}'::text[])) THEN 'beer'::text WHEN ((subclass)::text = ANY ('{music,musical_instrument}'::text[])) THEN 'music'::text WHEN ((subclass)::text = ANY ('{american_football,
  289. stadium,soccer}'::text[])) THEN 'stadium'::text WHEN ((subclass)::text = ANY ('{art,artwork,gallery,arts_centre}'::text[])) THEN 'art_gallery'::text WHEN ((subclass)::text = ANY ('{bag,clothes}'::text[])) THEN 'clothing_store'::text WHEN
  290. ((subclass)::text = ANY ('{swimming_area,swimming}'::text[])) THEN 'swimming'::text WHEN ((subclass)::text = ANY ('{castle,ruins}'::text[])) THEN 'castle'::text ELSE (subclass)::text END WHEN 'hospital'::text THEN 20 WHEN 'railway'::text
  291. THEN 40 WHEN 'bus'::text THEN 50 WHEN 'attraction'::text THEN 70 WHEN 'harbor'::text THEN 75 WHEN 'college'::text THEN 80 WHEN 'school'::text THEN 85 WHEN 'stadium'::text THEN 90 WHEN 'zoo'::text THEN 95 WHEN 'town_hall'::text THEN 100 WH
  292. EN 'campsite'::text THEN 110 WHEN 'cemetery'::text THEN 115 WHEN 'park'::text THEN 120 WHEN 'library'::text THEN 130 WHEN 'police'::text THEN 135 WHEN 'post'::text THEN 140 WHEN 'golf'::text THEN 150 WHEN 'shop'::text THEN 400 WHEN 'groce
  293. ry'::text THEN 500 WHEN 'fast_food'::text THEN 600 WHEN 'clothing_store'::text THEN 700 WHEN 'bar'::text THEN 800 ELSE 1000 END END)
  294.                                  Sort Method: quicksort  Memory: 25kB
  295.                                  ->  Result  (cost=0.00..0.00 rows=0 width=377) (actual time=0.007..0.013 rows=0 loops=1)
  296.                                        One-Time Filter: false
  297.    ->  Aggregate  (cost=33.30..33.31 rows=1 width=32) (actual time=0.020..0.033 rows=1 loops=1)
  298.          ->  Result  (cost=0.00..32.90 rows=1 width=435) (actual time=0.006..0.013 rows=0 loops=1)
  299.                One-Time Filter: false
  300.                ->  Seq Scan on osm_aerodrome_label_point  (cost=0.00..32.90 rows=1 width=435) (never executed)
  301.                      Filter: (st_asmvtgeom(geometry, 'BOX(-20037508.3427892 -20037508.3427893,20037508.3427892 20037508.3427892)'::box2d, 4096, 64, true) IS NOT NULL)
  302.  Planning Time: 23.360 ms
  303.  Execution Time: 120.424 ms
  304. (276 rows)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top