the same query in the worker node is 100x fater than in coordinator node
I have setup citus(v12.1.15) cluster using postgreSQL16.4 with one coordinator and tow worker in 3 physical machine,with node run in docker. coordinator has 27TB size,worker1 has 22TB,worker2 has 6TB,while excute spatial query,in any of the worker node will get result in 400ms and 185 rows ,but excute in the coordinator node will cost 40s.
I have using bellow code to explain costs.
set citus.explain_all_tasks = 1;
explain (analyze,verbose,buffers,summary,settings,costs,timing,wal)
select * from "table_name" where st_intersects(geom,st_makeenvlope(x,x,x,x,4326))
on coordinator the explain result like those: all task planing and execution time in 0.x ms, but all task will took 40s
All we can do is guess unless you share the explain output.
My guess is that Citus pulls all the data from the workers and does the filtering on the coordinator. Although I can not see why that would happen, the execution times suggest that.
Check individual queries that were run on shards, and try to understand what is going on using the explain output.
explain code
set citus.explain_all_tasks =1;
explain (analyze,verbose,buffers,summary,settings,costs,timing,wal)
select * from "some_3000w_polygon" where st_intersects(geom, st_makeenvelope(110.1918, 27.5492, 110.9919, 27.5553, 4490))
coordinator output
QUERY PLAN
Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=100000 width=2602) (actual time=120230.965..120231.675 rows=5125 loops=1)
Output: remote_scan.ogc_fid, remote_scan.bsm, remote_scan.ysdm, remote_scan.tbybh, remote_scan.tbbh, remote_scan.dlbm, remote_scan.dlmc, remote_scan.qsxz, remote_scan.qsdwdm, remote_scan.qsdwmc, remote_scan.zldwdm, remote_scan.zldwmc, remote_scan.tbmj, remote_scan.kcdlbm, remote_scan.kcxs, remote_scan.kcmj, remote_scan.tbdlmj, remote_scan.gdlx, remote_scan.xzdwkd, remote_scan.tbxhdm, remote_scan.tbxhmc, remote_scan.zzsxdm, remote_scan.zzsxmc, remote_scan.gddb, remote_scan.czcsxm, remote_scan.sjnf, remote_scan.mssm, remote_scan.gdpdjb, remote_scan.frdbs, remote_scan.hdmc, remote_scan.bz, remote_scan.shape_length, remote_scan.shape_area, remote_scan.geom
Task Count: 32
Tuple data received from nodes: 12 MB
Tasks Shown: All
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168230" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 484 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168230" on public."some_3000w_polygon_168230" "some_3000w_polygon" (cost=0.29..2696.64 rows=163 width=1514) (actual time=0.660..4.723 rows=168 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=306
Query Identifier: -2133371964472778270
Planning Time: 2.795 ms
Execution Time: 5.004 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168232" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 541 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168232" on public."some_3000w_polygon_168232" "some_3000w_polygon" (cost=0.29..2481.91 rows=150 width=1515) (actual time=0.345..4.504 rows=188 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=317
Query Identifier: -6924072062141970032
Planning Time: 2.706 ms
Execution Time: 4.769 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168237" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 344 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168237" on public."some_3000w_polygon_168237" "some_3000w_polygon" (cost=0.29..3443.92 rows=208 width=1551) (actual time=0.394..4.397 rows=163 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=268
Query Identifier: -3212844663701633649
Planning Time: 3.090 ms
Execution Time: 4.719 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168234" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 418 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168234" on public."some_3000w_polygon_168234" "some_3000w_polygon" (cost=0.29..2993.95 rows=181 width=1546) (actual time=0.359..4.073 rows=176 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=302
Query Identifier: 99178001838828763
Planning Time: 2.594 ms
Execution Time: 4.379 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168240" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 448 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168240" on public."some_3000w_polygon_168240" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1548) (actual time=0.326..4.060 rows=174 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=299
Query Identifier: -16718588836586590
Planning Time: 2.813 ms
Execution Time: 4.289 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168235" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 480 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168235" on public."some_3000w_polygon_168235" "some_3000w_polygon" (cost=0.29..2135.04 rows=129 width=1559) (actual time=0.786..4.000 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=291
Query Identifier: 2641515944561958450
Planning Time: 3.420 ms
Execution Time: 4.262 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168226" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 396 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168226" on public."some_3000w_polygon_168226" "some_3000w_polygon" (cost=0.29..2911.36 rows=176 width=1552) (actual time=0.300..3.931 rows=183 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=286
Query Identifier: -504054554030478318
Planning Time: 2.498 ms
Execution Time: 4.237 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168225" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 654 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168225" on public."some_3000w_polygon_168225" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1506) (actual time=0.314..3.914 rows=159 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=302
Query Identifier: 5575481678140567875
Planning Time: 2.385 ms
Execution Time: 4.197 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168246" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 393 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168246" on public."some_3000w_polygon_168246" "some_3000w_polygon" (cost=0.29..2564.50 rows=155 width=1519) (actual time=0.338..3.789 rows=174 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=286
Query Identifier: 3445592711454181247
Planning Time: 3.192 ms
Execution Time: 4.036 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168242" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 418 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168242" on public."some_3000w_polygon_168242" "some_3000w_polygon" (cost=0.29..2085.49 rows=126 width=1546) (actual time=0.339..3.706 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=273
Query Identifier: 2921515327759134926
Planning Time: 2.785 ms
Execution Time: 3.967 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168223" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 372 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168223" on public."some_3000w_polygon_168223" "some_3000w_polygon" (cost=0.29..3526.51 rows=213 width=1574) (actual time=0.293..3.728 rows=160 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=277
Query Identifier: -2179270637279037132
Planning Time: 2.343 ms
Execution Time: 3.962 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168245" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 476 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168245" on public."some_3000w_polygon_168245" "some_3000w_polygon" (cost=0.29..2547.98 rows=154 width=1542) (actual time=0.500..3.736 rows=155 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=277
Query Identifier: -3053232144622213106
Planning Time: 2.450 ms
Execution Time: 3.952 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168228" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 393 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168228" on public."some_3000w_polygon_168228" "some_3000w_polygon" (cost=0.29..2399.32 rows=145 width=1510) (actual time=0.388..3.646 rows=146 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=251
Query Identifier: -2628978636151639851
Planning Time: 2.685 ms
Execution Time: 3.937 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168244" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 435 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168244" on public."some_3000w_polygon_168244" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1522) (actual time=0.180..3.767 rows=147 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=237
Query Identifier: -9108272066351454681
Planning Time: 1.703 ms
Execution Time: 3.911 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168222" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 397 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168222" on public."some_3000w_polygon_168222" "some_3000w_polygon" (cost=0.29..2894.85 rows=175 width=1546) (actual time=0.322..3.647 rows=154 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=271
Query Identifier: 6454058396920762370
Planning Time: 2.577 ms
Execution Time: 3.870 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168219" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 551 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168219" on public."some_3000w_polygon_168219" "some_3000w_polygon" (cost=0.29..2184.59 rows=132 width=1565) (actual time=0.275..3.581 rows=153 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=312
Query Identifier: 7042720993224513551
Planning Time: 2.284 ms
Execution Time: 3.777 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168247" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 430 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168247" on public."some_3000w_polygon_168247" "some_3000w_polygon" (cost=0.29..2201.11 rows=133 width=1499) (actual time=0.301..3.507 rows=160 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=290
Query Identifier: 6309307195331167819
Planning Time: 2.617 ms
Execution Time: 3.758 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168239" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 493 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168239" on public."some_3000w_polygon_168239" "some_3000w_polygon" (cost=0.29..2333.25 rows=141 width=1525) (actual time=0.120..3.594 rows=190 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=292
Query Identifier: 8779924956758253131
Planning Time: 1.355 ms
Execution Time: 3.694 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168233" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 354 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168233" on public."some_3000w_polygon_168233" "some_3000w_polygon" (cost=0.29..2481.91 rows=150 width=1515) (actual time=0.291..3.350 rows=173 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=259
Query Identifier: 6734327645315906766
Planning Time: 2.736 ms
Execution Time: 3.649 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168238" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 327 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168238" on public."some_3000w_polygon_168238" "some_3000w_polygon" (cost=0.29..1837.73 rows=111 width=1520) (actual time=0.285..3.277 rows=148 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=245
Query Identifier: 6096586317239064479
Planning Time: 2.998 ms
Execution Time: 3.540 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168241" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 350 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168241" on public."some_3000w_polygon_168241" "some_3000w_polygon" (cost=0.29..2746.19 rows=166 width=1531) (actual time=0.258..3.204 rows=165 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=264
Query Identifier: -8553781815524897257
Planning Time: 2.413 ms
Execution Time: 3.451 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168216" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 390 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168216" on public."some_3000w_polygon_168216" "some_3000w_polygon" (cost=0.29..2828.78 rows=171 width=1532) (actual time=0.302..3.168 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=274
Query Identifier: -4649923235783443433
Planning Time: 2.432 ms
Execution Time: 3.436 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168236" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 241 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168236" on public."some_3000w_polygon_168236" "some_3000w_polygon" (cost=0.29..2960.92 rows=179 width=1534) (actual time=0.219..3.226 rows=137 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=191
Query Identifier: -5677975693753371306
Planning Time: 1.795 ms
Execution Time: 3.415 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168218" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 399 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168218" on public."some_3000w_polygon_168218" "some_3000w_polygon" (cost=0.29..2762.71 rows=167 width=1500) (actual time=0.319..3.165 rows=153 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=262
Query Identifier: 6280928893968379138
Planning Time: 2.495 ms
Execution Time: 3.389 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168227" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 365 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168227" on public."some_3000w_polygon_168227" "some_3000w_polygon" (cost=0.29..2201.11 rows=133 width=1530) (actual time=0.243..3.095 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=262
Query Identifier: 3075563490206673727
Planning Time: 2.190 ms
Execution Time: 3.305 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168231" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 299 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168231" on public."some_3000w_polygon_168231" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1528) (actual time=0.286..2.915 rows=134 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=217
Query Identifier: -9181727119677935606
Planning Time: 2.629 ms
Execution Time: 3.149 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168243" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 285 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168243" on public."some_3000w_polygon_168243" "some_3000w_polygon" (cost=0.29..3192.16 rows=193 width=1542) (actual time=0.303..2.885 rows=146 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=235
Query Identifier: -4190976603692720281
Planning Time: 2.357 ms
Execution Time: 3.114 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168217" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 456 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168217" on public."some_3000w_polygon_168217" "some_3000w_polygon" (cost=0.29..3208.68 rows=194 width=1531) (actual time=0.328..2.791 rows=141 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=266
Query Identifier: -7675785651018753051
Planning Time: 2.163 ms
Execution Time: 3.020 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168224" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 275 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168224" on public."some_3000w_polygon_168224" "some_3000w_polygon" (cost=0.29..2382.80 rows=144 width=1534) (actual time=0.308..2.672 rows=152 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=230
Query Identifier: 8913595294098947405
Planning Time: 2.567 ms
Execution Time: 2.952 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168229" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 356 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168229" on public."some_3000w_polygon_168229" "some_3000w_polygon" (cost=0.29..2514.94 rows=152 width=1563) (actual time=0.168..2.801 rows=173 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=256
Query Identifier: 7468856992646817353
Planning Time: 1.199 ms
Execution Time: 2.938 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168220" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 207 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168220" on public."some_3000w_polygon_168220" "some_3000w_polygon" (cost=0.29..3043.51 rows=184 width=1541) (actual time=0.314..2.563 rows=142 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=213
Query Identifier: -8356541102909487114
Planning Time: 2.454 ms
Execution Time: 2.788 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168221" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 287 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168221" on public."some_3000w_polygon_168221" "some_3000w_polygon" (cost=0.29..2250.66 rows=136 width=1558) (actual time=0.279..2.419 rows=143 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=234
Query Identifier: -4689085255781521542
Planning Time: 2.204 ms
Execution Time: 2.685 ms
Buffers: shared hit=92
Settings: temp_buffers = '1GB', work_mem = '256MB', max_parallel_workers_per_gather = '96', max_parallel_workers = '96', effective_cache_size = '256GB'
Query Identifier: -2608123903932257680
Planning:
Buffers: shared hit=580
Planning Time: 18.934 ms
Execution Time: 120232.258 ms
worker1 output
QUERY PLAN
Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=100000 width=2602) (actual time=165.710..166.446 rows=5125 loops=1)
Output: remote_scan.ogc_fid, remote_scan.bsm, remote_scan.ysdm, remote_scan.tbybh, remote_scan.tbbh, remote_scan.dlbm, remote_scan.dlmc, remote_scan.qsxz, remote_scan.qsdwdm, remote_scan.qsdwmc, remote_scan.zldwdm, remote_scan.zldwmc, remote_scan.tbmj, remote_scan.kcdlbm, remote_scan.kcxs, remote_scan.kcmj, remote_scan.tbdlmj, remote_scan.gdlx, remote_scan.xzdwkd, remote_scan.tbxhdm, remote_scan.tbxhmc, remote_scan.zzsxdm, remote_scan.zzsxmc, remote_scan.gddb, remote_scan.czcsxm, remote_scan.sjnf, remote_scan.mssm, remote_scan.gdpdjb, remote_scan.frdbs, remote_scan.hdmc, remote_scan.bz, remote_scan.shape_length, remote_scan.shape_area, remote_scan.geom
Task Count: 32
Tuple data received from nodes: 12 MB
Tasks Shown: All
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168225" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 654 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168225" on public."some_3000w_polygon_168225" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1506) (actual time=0.333..4.550 rows=159 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=302
Query Identifier: 5575481678140567875
Planning Time: 2.810 ms
Execution Time: 4.843 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168232" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 541 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168232" on public."some_3000w_polygon_168232" "some_3000w_polygon" (cost=0.29..2481.91 rows=150 width=1515) (actual time=0.328..4.580 rows=188 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=317
Query Identifier: -6924072062141970032
Planning Time: 2.575 ms
Execution Time: 4.838 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168234" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 418 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168234" on public."some_3000w_polygon_168234" "some_3000w_polygon" (cost=0.29..2993.95 rows=181 width=1546) (actual time=0.328..4.397 rows=176 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=302
Query Identifier: 99178001838828763
Planning Time: 2.584 ms
Execution Time: 4.697 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168239" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 493 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168239" on public."some_3000w_polygon_168239" "some_3000w_polygon" (cost=0.29..2333.25 rows=141 width=1525) (actual time=0.280..4.127 rows=190 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=316
Query Identifier: 8779924956758253131
Planning Time: 2.673 ms
Execution Time: 4.406 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168230" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 484 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168230" on public."some_3000w_polygon_168230" "some_3000w_polygon" (cost=0.29..2696.64 rows=163 width=1514) (actual time=0.523..3.951 rows=168 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=306
Query Identifier: -2133371964472778270
Planning Time: 2.562 ms
Execution Time: 4.192 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168219" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 551 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168219" on public."some_3000w_polygon_168219" "some_3000w_polygon" (cost=0.29..2184.59 rows=132 width=1565) (actual time=0.297..3.921 rows=153 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=312
Query Identifier: 7042720993224513551
Planning Time: 2.666 ms
Execution Time: 4.126 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168223" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 372 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168223" on public."some_3000w_polygon_168223" "some_3000w_polygon" (cost=0.29..3526.51 rows=213 width=1574) (actual time=0.278..3.847 rows=160 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=277
Query Identifier: -2179270637279037132
Planning Time: 2.451 ms
Execution Time: 4.108 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168233" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 354 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168233" on public."some_3000w_polygon_168233" "some_3000w_polygon" (cost=0.29..2481.91 rows=150 width=1515) (actual time=0.315..3.754 rows=173 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=259
Query Identifier: 6734327645315906766
Planning Time: 2.903 ms
Execution Time: 4.058 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168226" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 396 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168226" on public."some_3000w_polygon_168226" "some_3000w_polygon" (cost=0.29..2911.36 rows=176 width=1552) (actual time=0.301..3.731 rows=183 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=286
Query Identifier: -504054554030478318
Planning Time: 2.472 ms
Execution Time: 4.031 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168246" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 393 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168246" on public."some_3000w_polygon_168246" "some_3000w_polygon" (cost=0.29..2564.50 rows=155 width=1519) (actual time=0.326..3.771 rows=174 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=286
Query Identifier: 3445592711454181247
Planning Time: 2.654 ms
Execution Time: 4.009 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168245" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 476 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168245" on public."some_3000w_polygon_168245" "some_3000w_polygon" (cost=0.29..2547.98 rows=154 width=1542) (actual time=0.496..3.724 rows=155 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=277
Query Identifier: -3053232144622213106
Planning Time: 2.547 ms
Execution Time: 3.940 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168244" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 435 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168244" on public."some_3000w_polygon_168244" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1522) (actual time=0.315..3.706 rows=147 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=261
Query Identifier: -9108272066351454681
Planning Time: 2.587 ms
Execution Time: 3.933 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168235" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 480 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168235" on public."some_3000w_polygon_168235" "some_3000w_polygon" (cost=0.29..2135.04 rows=129 width=1559) (actual time=0.666..3.694 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=291
Query Identifier: 2641515944561958450
Planning Time: 3.044 ms
Execution Time: 3.921 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168229" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 356 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168229" on public."some_3000w_polygon_168229" "some_3000w_polygon" (cost=0.29..2514.94 rows=152 width=1563) (actual time=0.331..3.625 rows=173 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=280
Query Identifier: 7468856992646817353
Planning Time: 2.767 ms
Execution Time: 3.915 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168247" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 430 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168247" on public."some_3000w_polygon_168247" "some_3000w_polygon" (cost=0.29..2201.11 rows=133 width=1499) (actual time=0.186..3.742 rows=160 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=266
Query Identifier: 6309307195331167819
Planning Time: 1.452 ms
Execution Time: 3.908 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168242" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 418 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168242" on public."some_3000w_polygon_168242" "some_3000w_polygon" (cost=0.29..2085.49 rows=126 width=1546) (actual time=0.327..3.629 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=273
Query Identifier: 2921515327759134926
Planning Time: 2.525 ms
Execution Time: 3.893 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168222" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 397 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168222" on public."some_3000w_polygon_168222" "some_3000w_polygon" (cost=0.29..2894.85 rows=175 width=1546) (actual time=0.321..3.663 rows=154 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=271
Query Identifier: 6454058396920762370
Planning Time: 2.547 ms
Execution Time: 3.874 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168241" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 350 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168241" on public."some_3000w_polygon_168241" "some_3000w_polygon" (cost=0.29..2746.19 rows=166 width=1531) (actual time=0.281..3.596 rows=165 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=264
Query Identifier: -8553781815524897257
Planning Time: 2.811 ms
Execution Time: 3.853 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168227" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 365 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168227" on public."some_3000w_polygon_168227" "some_3000w_polygon" (cost=0.29..2201.11 rows=133 width=1530) (actual time=0.301..3.607 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=262
Query Identifier: 3075563490206673727
Planning Time: 2.738 ms
Execution Time: 3.852 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168237" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 344 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168237" on public."some_3000w_polygon_168237" "some_3000w_polygon" (cost=0.29..3443.92 rows=208 width=1551) (actual time=0.330..3.574 rows=163 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=268
Query Identifier: -3212844663701633649
Planning Time: 2.672 ms
Execution Time: 3.818 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168240" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 448 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168240" on public."some_3000w_polygon_168240" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1548) (actual time=0.180..3.512 rows=174 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=275
Query Identifier: -16718588836586590
Planning Time: 1.354 ms
Execution Time: 3.583 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168231" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 299 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168231" on public."some_3000w_polygon_168231" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1528) (actual time=0.296..3.335 rows=134 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=217
Query Identifier: -9181727119677935606
Planning Time: 2.685 ms
Execution Time: 3.566 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168218" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 399 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168218" on public."some_3000w_polygon_168218" "some_3000w_polygon" (cost=0.29..2762.71 rows=167 width=1500) (actual time=0.349..3.296 rows=153 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=262
Query Identifier: 6280928893968379138
Planning Time: 2.501 ms
Execution Time: 3.515 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168243" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 285 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168243" on public."some_3000w_polygon_168243" "some_3000w_polygon" (cost=0.29..3192.16 rows=193 width=1542) (actual time=0.339..3.242 rows=146 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=235
Query Identifier: -4190976603692720281
Planning Time: 2.590 ms
Execution Time: 3.493 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168228" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 393 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168228" on public."some_3000w_polygon_168228" "some_3000w_polygon" (cost=0.29..2399.32 rows=145 width=1510) (actual time=0.308..3.097 rows=146 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=251
Query Identifier: -2628978636151639851
Planning Time: 2.241 ms
Execution Time: 3.335 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168238" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 327 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168238" on public."some_3000w_polygon_168238" "some_3000w_polygon" (cost=0.29..1837.73 rows=111 width=1520) (actual time=0.207..3.103 rows=148 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=221
Query Identifier: 6096586317239064479
Planning Time: 1.467 ms
Execution Time: 3.263 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168216" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 390 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168216" on public."some_3000w_polygon_168216" "some_3000w_polygon" (cost=0.29..2828.78 rows=171 width=1532) (actual time=0.302..2.932 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=274
Query Identifier: -4649923235783443433
Planning Time: 2.247 ms
Execution Time: 3.214 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168217" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 456 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168217" on public."some_3000w_polygon_168217" "some_3000w_polygon" (cost=0.29..3208.68 rows=194 width=1531) (actual time=0.316..2.952 rows=141 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=266
Query Identifier: -7675785651018753051
Planning Time: 2.094 ms
Execution Time: 3.184 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168221" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 287 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168221" on public."some_3000w_polygon_168221" "some_3000w_polygon" (cost=0.29..2250.66 rows=136 width=1558) (actual time=0.309..2.851 rows=143 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=234
Query Identifier: -4689085255781521542
Planning Time: 2.644 ms
Execution Time: 3.099 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168224" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 275 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168224" on public."some_3000w_polygon_168224" "some_3000w_polygon" (cost=0.29..2382.80 rows=144 width=1534) (actual time=0.298..2.764 rows=152 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=230
Query Identifier: 8913595294098947405
Planning Time: 2.567 ms
Execution Time: 3.024 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168220" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 207 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168220" on public."some_3000w_polygon_168220" "some_3000w_polygon" (cost=0.29..3043.51 rows=184 width=1541) (actual time=0.329..2.643 rows=142 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=213
Query Identifier: -8356541102909487114
Planning Time: 2.419 ms
Execution Time: 2.853 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168236" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 241 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168236" on public."some_3000w_polygon_168236" "some_3000w_polygon" (cost=0.29..2960.92 rows=179 width=1534) (actual time=0.164..2.640 rows=137 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=191
Query Identifier: -5677975693753371306
Planning Time: 1.316 ms
Execution Time: 2.780 ms
Buffers: shared hit=92
Settings: temp_buffers = '1GB', work_mem = '256MB', max_parallel_workers_per_gather = '96', max_parallel_workers = '96', effective_cache_size = '256GB'
Query Identifier: -3427833685622918991
Planning:
Buffers: shared hit=809 read=5 dirtied=4
Planning Time: 30.812 ms
Execution Time: 167.127 ms
worker2 output
QUERY PLAN
Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=100000 width=2602) (actual time=243.275..244.040 rows=5125 loops=1)
Output: remote_scan.ogc_fid, remote_scan.bsm, remote_scan.ysdm, remote_scan.tbybh, remote_scan.tbbh, remote_scan.dlbm, remote_scan.dlmc, remote_scan.qsxz, remote_scan.qsdwdm, remote_scan.qsdwmc, remote_scan.zldwdm, remote_scan.zldwmc, remote_scan.tbmj, remote_scan.kcdlbm, remote_scan.kcxs, remote_scan.kcmj, remote_scan.tbdlmj, remote_scan.gdlx, remote_scan.xzdwkd, remote_scan.tbxhdm, remote_scan.tbxhmc, remote_scan.zzsxdm, remote_scan.zzsxmc, remote_scan.gddb, remote_scan.czcsxm, remote_scan.sjnf, remote_scan.mssm, remote_scan.gdpdjb, remote_scan.frdbs, remote_scan.hdmc, remote_scan.bz, remote_scan.shape_length, remote_scan.shape_area, remote_scan.geom
Task Count: 32
Tuple data received from nodes: 12 MB
Tasks Shown: All
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168232" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 541 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168232" on public."some_3000w_polygon_168232" "some_3000w_polygon" (cost=0.29..2481.91 rows=150 width=1515) (actual time=137.273..150.836 rows=188 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=303 read=14
Query Identifier: -6924072062141970032
Planning Time: 2.919 ms
Execution Time: 151.157 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168218" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 399 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168218" on public."some_3000w_polygon_168218" "some_3000w_polygon" (cost=0.29..2762.71 rows=167 width=1500) (actual time=78.306..141.591 rows=153 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=251 read=11
Query Identifier: 6280928893968379138
Planning Time: 4.316 ms
Execution Time: 141.861 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168222" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 397 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168222" on public."some_3000w_polygon_168222" "some_3000w_polygon" (cost=0.29..2894.85 rows=175 width=1546) (actual time=28.618..135.445 rows=154 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=257 read=14
Query Identifier: 6454058396920762370
Planning Time: 3.952 ms
Execution Time: 135.695 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168220" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 207 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168220" on public."some_3000w_polygon_168220" "some_3000w_polygon" (cost=0.29..3043.51 rows=184 width=1541) (actual time=16.243..111.245 rows=142 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=201 read=12
Query Identifier: -8356541102909487114
Planning Time: 3.000 ms
Execution Time: 111.552 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168238" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 327 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168238" on public."some_3000w_polygon_168238" "some_3000w_polygon" (cost=0.29..1837.73 rows=111 width=1520) (actual time=73.186..106.036 rows=148 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=233 read=12
Query Identifier: 6096586317239064479
Planning Time: 2.614 ms
Execution Time: 106.314 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168230" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 484 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168230" on public."some_3000w_polygon_168230" "some_3000w_polygon" (cost=0.29..2696.64 rows=163 width=1514) (actual time=42.218..103.146 rows=168 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=294 read=12
Query Identifier: -2133371964472778270
Planning Time: 2.658 ms
Execution Time: 103.407 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168224" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 275 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168224" on public."some_3000w_polygon_168224" "some_3000w_polygon" (cost=0.29..2382.80 rows=144 width=1534) (actual time=83.126..87.615 rows=152 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=215 read=15
Query Identifier: 8913595294098947405
Planning Time: 3.072 ms
Execution Time: 87.922 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168234" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 418 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168234" on public."some_3000w_polygon_168234" "some_3000w_polygon" (cost=0.29..2993.95 rows=181 width=1546) (actual time=44.631..74.054 rows=176 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=286 read=16
Query Identifier: 99178001838828763
Planning Time: 3.167 ms
Execution Time: 74.421 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168242" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 418 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168242" on public."some_3000w_polygon_168242" "some_3000w_polygon" (cost=0.29..2085.49 rows=126 width=1546) (actual time=38.604..60.421 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=258 read=15
Query Identifier: 2921515327759134926
Planning Time: 2.580 ms
Execution Time: 60.699 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168240" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 448 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168240" on public."some_3000w_polygon_168240" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1548) (actual time=48.702..54.759 rows=174 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=284 read=15
Query Identifier: -16718588836586590
Planning Time: 2.751 ms
Execution Time: 55.009 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168226" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 396 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168226" on public."some_3000w_polygon_168226" "some_3000w_polygon" (cost=0.29..2911.36 rows=176 width=1552) (actual time=17.693..52.146 rows=183 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=271 read=15
Query Identifier: -504054554030478318
Planning Time: 2.951 ms
Execution Time: 52.462 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168236" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 241 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168236" on public."some_3000w_polygon_168236" "some_3000w_polygon" (cost=0.29..2960.92 rows=179 width=1534) (actual time=34.696..48.198 rows=137 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=201 read=14
Query Identifier: -5677975693753371306
Planning Time: 2.751 ms
Execution Time: 48.463 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168246" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 393 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168246" on public."some_3000w_polygon_168246" "some_3000w_polygon" (cost=0.29..2564.50 rows=155 width=1519) (actual time=31.037..42.762 rows=174 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=274 read=12
Query Identifier: 3445592711454181247
Planning Time: 2.460 ms
Execution Time: 42.989 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168216" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 390 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168216" on public."some_3000w_polygon_168216" "some_3000w_polygon" (cost=0.29..2828.78 rows=171 width=1532) (actual time=22.483..41.846 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=259 read=15
Query Identifier: -4649923235783443433
Planning Time: 2.919 ms
Execution Time: 42.135 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168244" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 435 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168244" on public."some_3000w_polygon_168244" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1522) (actual time=19.797..32.977 rows=147 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=247 read=14
Query Identifier: -9108272066351454681
Planning Time: 2.905 ms
Execution Time: 33.245 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168228" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 393 kB
Node: host=citus-worker1 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168228" on public."some_3000w_polygon_168228" "some_3000w_polygon" (cost=0.29..2399.32 rows=145 width=1510) (actual time=23.818..28.278 rows=146 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=238 read=13
Query Identifier: -2628978636151639851
Planning Time: 3.062 ms
Execution Time: 28.573 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168225" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 654 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168225" on public."some_3000w_polygon_168225" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1506) (actual time=0.340..4.676 rows=159 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=302
Query Identifier: 5575481678140567875
Planning Time: 2.813 ms
Execution Time: 4.981 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168223" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 372 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168223" on public."some_3000w_polygon_168223" "some_3000w_polygon" (cost=0.29..3526.51 rows=213 width=1574) (actual time=0.297..4.247 rows=160 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=277
Query Identifier: -2179270637279037132
Planning Time: 2.686 ms
Execution Time: 4.481 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168235" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 480 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168235" on public."some_3000w_polygon_168235" "some_3000w_polygon" (cost=0.29..2135.04 rows=129 width=1559) (actual time=0.740..4.144 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=291
Query Identifier: 2641515944561958450
Planning Time: 2.797 ms
Execution Time: 4.384 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168239" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 493 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168239" on public."some_3000w_polygon_168239" "some_3000w_polygon" (cost=0.29..2333.25 rows=141 width=1525) (actual time=0.274..3.932 rows=190 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=316
Query Identifier: 8779924956758253131
Planning Time: 2.405 ms
Execution Time: 4.234 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168233" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 354 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168233" on public."some_3000w_polygon_168233" "some_3000w_polygon" (cost=0.29..2481.91 rows=150 width=1515) (actual time=0.316..3.733 rows=173 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=259
Query Identifier: 6734327645315906766
Planning Time: 2.873 ms
Execution Time: 4.043 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168219" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 551 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168219" on public."some_3000w_polygon_168219" "some_3000w_polygon" (cost=0.29..2184.59 rows=132 width=1565) (actual time=0.282..3.721 rows=153 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=312
Query Identifier: 7042720993224513551
Planning Time: 2.444 ms
Execution Time: 3.939 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168229" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 356 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168229" on public."some_3000w_polygon_168229" "some_3000w_polygon" (cost=0.29..2514.94 rows=152 width=1563) (actual time=0.334..3.610 rows=173 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=280
Query Identifier: 7468856992646817353
Planning Time: 2.617 ms
Execution Time: 3.873 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168245" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 476 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168245" on public."some_3000w_polygon_168245" "some_3000w_polygon" (cost=0.29..2547.98 rows=154 width=1542) (actual time=0.429..3.560 rows=155 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=253
Query Identifier: -3053232144622213106
Planning Time: 1.480 ms
Execution Time: 3.652 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168241" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 350 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168241" on public."some_3000w_polygon_168241" "some_3000w_polygon" (cost=0.29..2746.19 rows=166 width=1531) (actual time=0.273..3.382 rows=165 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=264
Query Identifier: -8553781815524897257
Planning Time: 2.441 ms
Execution Time: 3.637 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168247" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 430 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168247" on public."some_3000w_polygon_168247" "some_3000w_polygon" (cost=0.29..2201.11 rows=133 width=1499) (actual time=0.290..3.363 rows=160 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=290
Query Identifier: 6309307195331167819
Planning Time: 2.375 ms
Execution Time: 3.607 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168227" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 365 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168227" on public."some_3000w_polygon_168227" "some_3000w_polygon" (cost=0.29..2201.11 rows=133 width=1530) (actual time=0.309..3.269 rows=167 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=262
Query Identifier: 3075563490206673727
Planning Time: 2.518 ms
Execution Time: 3.508 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168243" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 285 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168243" on public."some_3000w_polygon_168243" "some_3000w_polygon" (cost=0.29..3192.16 rows=193 width=1542) (actual time=0.291..2.947 rows=146 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=235
Query Identifier: -4190976603692720281
Planning Time: 2.442 ms
Execution Time: 3.183 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168217" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 456 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168217" on public."some_3000w_polygon_168217" "some_3000w_polygon" (cost=0.29..3208.68 rows=194 width=1531) (actual time=0.327..2.916 rows=141 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=266
Query Identifier: -7675785651018753051
Planning Time: 2.140 ms
Execution Time: 3.167 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168237" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 344 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168237" on public."some_3000w_polygon_168237" "some_3000w_polygon" (cost=0.29..3443.92 rows=208 width=1551) (actual time=0.183..3.000 rows=163 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=244
Query Identifier: -3212844663701633649
Planning Time: 1.290 ms
Execution Time: 3.140 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168221" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 287 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168221" on public."some_3000w_polygon_168221" "some_3000w_polygon" (cost=0.29..2250.66 rows=136 width=1558) (actual time=0.313..2.844 rows=143 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Buffers: shared hit=234
Query Identifier: -4689085255781521542
Planning Time: 2.492 ms
Execution Time: 3.095 ms
-> Task
Query: SELECT ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom FROM public."some_3000w_polygon_168231" "some_3000w_polygon" WHERE public.st_intersects(geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::public.geometry)
Tuple data received from node: 299 kB
Node: host=citus-worker2 port=5433 dbname=foundationdb
-> Index Scan using "some_3000w_polygon_geom_geom_idx_168231" on public."some_3000w_polygon_168231" "some_3000w_polygon" (cost=0.29..2366.29 rows=143 width=1528) (actual time=0.263..2.869 rows=134 loops=1)
Output: ogc_fid, bsm, ysdm, tbybh, tbbh, dlbm, dlmc, qsxz, qsdwdm, qsdwmc, zldwdm, zldwmc, tbmj, kcdlbm, kcxs, kcmj, tbdlmj, gdlx, xzdwkd, tbxhdm, tbxhmc, zzsxdm, zzsxmc, gddb, czcsxm, sjnf, mssm, gdpdjb, frdbs, hdmc, bz, shape_length, shape_area, geom
Index Cond: ("some_3000w_polygon".geom && '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Filter: st_intersects("some_3000w_polygon".geom, '01030000208A1100000100000005000000DCD78173468C5B4094F6065F988C3B40DCD78173468C5B4003780B24288E3B40C139234A7BBF5B4003780B24288E3B40C139234A7BBF5B4094F6065F988C3B40DCD78173468C5B4094F6065F988C3B40'::geometry)
Rows Removed by Filter: 1
Buffers: shared hit=217
Query Identifier: -9181727119677935606
Planning Time: 2.393 ms
Execution Time: 3.090 ms
Buffers: shared hit=97
Settings: temp_buffers = '1GB', work_mem = '256MB', max_parallel_workers_per_gather = '96', max_parallel_workers = '96', effective_cache_size = '256GB'
Query Identifier: 1885837254740215436
Planning:
Buffers: shared hit=829 dirtied=18
Planning Time: 21.279 ms
Execution Time: 244.639 ms
@hanefi ,I have update the explain output , need your help!