explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eNW0

Settings
# exclusive inclusive rows x rows loops node
1. 2.261 15,774.173 ↑ 1.0 3 1

Subquery Scan on q (cost=90,191.73..90,191.95 rows=3 width=80) (actual time=15,773.545..15,774.173 rows=3 loops=1)

2. 0.014 15,771.912 ↑ 1.0 3 1

Limit (cost=90,191.73..90,191.74 rows=3 width=44) (actual time=15,771.899..15,771.912 rows=3 loops=1)

3. 0.226 15,771.898 ↑ 66.7 3 1

Sort (cost=90,191.73..90,192.23 rows=200 width=44) (actual time=15,771.897..15,771.898 rows=3 loops=1)

  • Sort Key: (count(q_1.cluster_id)) DESC
  • Sort Method: top-N heapsort Memory: 53kB
4. 745.316 15,771.672 ↑ 2.2 93 1

GroupAggregate (cost=90,176.69..90,189.14 rows=200 width=44) (actual time=15,030.864..15,771.672 rows=93 loops=1)

  • Group Key: q_1.cluster_id
5. 0.839 15,026.356 ↑ 1.0 967 1

Sort (cost=90,176.69..90,179.18 rows=995 width=36) (actual time=15,026.048..15,026.356 rows=967 loops=1)

  • Sort Key: q_1.cluster_id
  • Sort Method: quicksort Memory: 1974kB
6. 0.160 15,025.517 ↑ 1.0 967 1

Subquery Scan on q_1 (cost=89,977.97..90,127.15 rows=995 width=36) (actual time=15,024.656..15,025.517 rows=967 loops=1)

  • Filter: (q_1.cluster_id IS NOT NULL)
  • Rows Removed by Filter: 33
7. 1,142.519 15,025.357 ↑ 1.0 1,000 1

WindowAgg (cost=89,977.97..90,117.15 rows=1,000 width=36) (actual time=15,024.653..15,025.357 rows=1,000 loops=1)

8. 0.191 13,882.838 ↑ 1.0 1,000 1

Subquery Scan on q_2 (cost=89,977.97..90,104.65 rows=1,000 width=32) (actual time=13,854.209..13,882.838 rows=1,000 loops=1)

9. 0.165 13,882.647 ↑ 1.0 1,000 1

Limit (cost=89,977.97..90,094.65 rows=1,000 width=40) (actual time=13,854.208..13,882.647 rows=1,000 loops=1)

10. 83.291 13,882.482 ↑ 1.2 1,000 1

Gather Merge (cost=89,977.97..90,115.18 rows=1,176 width=40) (actual time=13,854.207..13,882.482 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
11. 81.222 13,799.191 ↑ 1.6 366 3 / 3

Sort (cost=88,977.95..88,979.42 rows=588 width=40) (actual time=13,799.111..13,799.191 rows=366 loops=3)

  • Sort Key: _hyper_38_257_chunk.timestamp_stop DESC
  • Sort Method: top-N heapsort Memory: 4082kB
  • Worker 0: Sort Method: top-N heapsort Memory: 4082kB
  • Worker 1: Sort Method: top-N heapsort Memory: 4082kB
12. 2,756.786 13,717.969 ↓ 41.5 24,416 3 / 3

Result (cost=84.01..88,950.90 rows=588 width=40) (actual time=13.264..13,717.969 rows=24,416 loops=3)

13. 9.707 10,961.183 ↓ 41.5 24,416 3 / 3

Parallel Append (cost=84.01..88,942.08 rows=588 width=54) (actual time=9.497..10,961.183 rows=24,416 loops=3)

14. 951.365 951.933 ↓ 8,213.0 8,213 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_257_chunk (cost=85.55..8,575.12 rows=1 width=1,672) (actual time=2.988..2,855.798 rows=8,213 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
15. 0.567 0.567 ↑ 1.0 8,213 1 / 3

Bitmap Index Scan on _hyper_38_257_chunk_history_place_stops_history_place_id_idx (cost=0.00..85.55 rows=8,301 width=0) (actual time=1.702..1.702 rows=8,213 loops=1)

  • Index Cond: (history_place_id = 168436)
16. 967.004 967.661 ↓ 8,041.0 8,041 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_256_chunk (cost=84.01..8,399.83 rows=1 width=1,672) (actual time=3.333..2,902.984 rows=8,041 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
17. 0.657 0.657 ↑ 1.0 8,041 1 / 3

Bitmap Index Scan on _hyper_38_256_chunk_history_place_stops_history_place_id_idx (cost=0.00..84.01 rows=8,095 width=0) (actual time=1.972..1.972 rows=8,041 loops=1)

  • Index Cond: (history_place_id = 168436)
18. 1,269.380 1,271.500 ↓ 7,881.0 7,881 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_260_chunk (cost=81.60..8,189.66 rows=1 width=1,672) (actual time=7.586..3,814.501 rows=7,881 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
19. 2.120 2.120 ↑ 1.0 7,881 1 / 3

Bitmap Index Scan on _hyper_38_260_chunk_history_place_stops_history_place_id_idx (cost=0.00..81.59 rows=7,907 width=0) (actual time=6.360..6.360 rows=7,881 loops=1)

  • Index Cond: (history_place_id = 168436)
20. 1,151.883 1,154.729 ↓ 7,707.0 7,707 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_261_chunk (cost=78.03..7,900.33 rows=1 width=1,672) (actual time=9.736..3,464.187 rows=7,707 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
21. 2.846 2.846 ↓ 1.0 7,707 1 / 3

Bitmap Index Scan on _hyper_38_261_chunk_history_place_stops_history_place_id_idx (cost=0.00..78.03 rows=7,565 width=0) (actual time=8.538..8.538 rows=7,707 loops=1)

  • Index Cond: (history_place_id = 168436)
22. 1,223.339 1,223.893 ↓ 7,470.0 7,470 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_259_chunk (cost=77.96..7,735.27 rows=1 width=1,672) (actual time=2.862..3,671.680 rows=7,470 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
23. 0.555 0.555 ↑ 1.0 7,470 1 / 3

Bitmap Index Scan on _hyper_38_259_chunk_history_place_stops_history_place_id_idx (cost=0.00..77.96 rows=7,556 width=0) (actual time=1.664..1.664 rows=7,470 loops=1)

  • Index Cond: (history_place_id = 168436)
24. 1,313.695 1,314.209 ↓ 7,452.0 7,452 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_258_chunk (cost=77.26..7,675.19 rows=1 width=1,672) (actual time=9.753..3,942.627 rows=7,452 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
25. 0.514 0.514 ↑ 1.0 7,452 1 / 3

Bitmap Index Scan on _hyper_38_258_chunk_history_place_stops_history_place_id_idx (cost=0.00..77.26 rows=7,462 width=0) (actual time=1.543..1.543 rows=7,452 loops=1)

  • Index Cond: (history_place_id = 168436)
26. 1,136.977 1,137.455 ↓ 2,448.0 2,448 3 / 3

Parallel Bitmap Heap Scan on _hyper_38_254_chunk (cost=76.46..7,545.69 rows=1 width=1,672) (actual time=1.054..1,137.455 rows=2,448 loops=3)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Heap Blocks: exact=2566
27. 0.478 0.478 ↑ 1.0 7,344 1 / 3

Bitmap Index Scan on _hyper_38_254_chunk_history_place_stops_history_place_id_idx (cost=0.00..76.46 rows=7,356 width=0) (actual time=1.432..1.433 rows=7,344 loops=1)

  • Index Cond: (history_place_id = 168436)
28. 1,138.566 1,139.239 ↓ 7,015.0 7,015 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_262_chunk (cost=72.89..7,249.24 rows=1 width=1,672) (actual time=3.082..3,417.717 rows=7,015 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Heap Blocks: exact=3866
29. 0.673 0.673 ↓ 1.0 7,015 1 / 3

Bitmap Index Scan on _hyper_38_262_chunk_history_place_stops_history_place_id_idx (cost=0.00..72.89 rows=7,013 width=0) (actual time=2.018..2.018 rows=7,015 loops=1)

  • Index Cond: (history_place_id = 168436)
30. 941.631 942.000 ↓ 6,034.0 6,034 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_263_chunk (cost=71.84..6,569.88 rows=1 width=1,672) (actual time=2.040..2,826.001 rows=6,034 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Heap Blocks: exact=3302
31. 0.370 0.370 ↑ 1.1 6,034 1 / 3

Bitmap Index Scan on _hyper_38_263_chunk_history_place_stops_history_place_id_idx (cost=0.00..71.84 rows=6,340 width=0) (actual time=1.109..1.109 rows=6,034 loops=1)

  • Index Cond: (history_place_id = 168436)
32. 699.846 700.181 ↓ 5,012.0 5,012 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_275_chunk (cost=57.74..5,333.85 rows=1 width=1,672) (actual time=1.829..2,100.544 rows=5,012 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Heap Blocks: exact=2750
33. 0.335 0.335 ↑ 1.0 5,012 1 / 3

Bitmap Index Scan on _hyper_38_275_chunk_history_place_stops_history_place_id_idx (cost=0.00..57.74 rows=5,127 width=0) (actual time=1.006..1.006 rows=5,012 loops=1)

  • Index Cond: (history_place_id = 168436)
34. 141.926 142.263 ↓ 1,080.0 1,080 1 / 3

Parallel Bitmap Heap Scan on _hyper_38_253_chunk (cost=50.82..4,153.66 rows=1 width=1,672) (actual time=2.922..426.788 rows=1,080 loops=1)

  • Recheck Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Rows Removed by Filter: 3879
  • Heap Blocks: exact=925
35. 0.337 0.337 ↓ 1.0 4,959 1 / 3

Bitmap Index Scan on _hyper_38_253_chunk_history_place_stops_history_place_id_idx (cost=0.00..50.82 rows=4,871 width=0) (actual time=1.011..1.011 rows=4,959 loops=1)

  • Index Cond: (history_place_id = 168436)
36. 3.042 3.042 ↓ 0.0 0 1 / 3

Parallel Index Scan using _hyper_38_267_chunk_history_place_stops_history_place_id_idx on _hyper_38_267_chunk (cost=0.29..1,759.04 rows=160 width=40) (actual time=9.127..9.127 rows=0 loops=1)

  • Index Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Rows Removed by Filter: 4122
37. 0.664 0.664 ↓ 0.0 0 1 / 3

Parallel Index Scan using _hyper_38_268_chunk_history_place_stops_history_place_id_idx on _hyper_38_268_chunk (cost=0.29..1,592.47 rows=152 width=40) (actual time=1.992..1.992 rows=0 loops=1)

  • Index Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Rows Removed by Filter: 3952
38. 0.563 0.563 ↓ 0.0 0 1 / 3

Parallel Index Scan using _hyper_38_266_chunk_history_place_stops_history_place_id_idx on _hyper_38_266_chunk (cost=0.29..1,459.79 rows=124 width=40) (actual time=1.688..1.689 rows=0 loops=1)

  • Index Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Rows Removed by Filter: 3147
39. 0.467 0.467 ↓ 0.0 0 1 / 3

Parallel Index Scan using _hyper_38_264_chunk_history_place_stops_history_place_id_idx on _hyper_38_264_chunk (cost=0.29..1,389.79 rows=102 width=40) (actual time=1.400..1.400 rows=0 loops=1)

  • Index Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Rows Removed by Filter: 2648
40. 1.059 1.059 ↓ 0.0 0 1 / 3

Parallel Index Scan using _hyper_38_269_chunk_history_place_stops_history_place_id_idx on _hyper_38_269_chunk (cost=0.29..1,903.40 rows=274 width=40) (actual time=3.176..3.176 rows=0 loops=1)

  • Index Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Rows Removed by Filter: 6895
41. 0.613 0.613 ↓ 0.0 0 1 / 3

Parallel Index Scan using _hyper_38_255_chunk_history_place_stops_history_place_id_idx on _hyper_38_255_chunk (cost=0.29..1,505.77 rows=1 width=1,672) (actual time=1.840..1.840 rows=0 loops=1)

  • Index Cond: (history_place_id = 168436)
  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Rows Removed by Filter: 3628
42. 0.004 0.004 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _hyper_38_265_chunk (cost=0.00..1.16 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: ((ellipse_95 IS NOT NULL) AND (ellipse_95 && '0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography) AND (history_place_id = 168436) AND _st_covers('0103000020E610000001000000050000000000000000003EC0CDCCCCCCCC4C3C400000000000003EC00000000000805140000000000080564000000000008051400000000000805640CDCCCCCCCC4C3C400000000000003EC0CDCCCCCCCC4C3C40'::geography, ellipse_95))
  • Rows Removed by Filter: 1
Planning time : 2.615 ms
Execution time : 15,774.418 ms