explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KiXS

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 174.237 186.210 ↑ 1.0 1 1

Aggregate (cost=767.30..767.31 rows=1 width=32) (actual time=186.210..186.210 rows=1 loops=1)

2.          

CTE selected_points

3. 3.459 4.266 ↓ 9.2 1,784 1

Bitmap Heap Scan on points points_1 (cost=9.79..702.16 rows=194 width=361) (actual time=1.023..4.266 rows=1,784 loops=1)

  • Recheck Cond: ('0103000000010000000500000048E17A14AEC72840068195438BAC494048E17A14AEC72840EC51B81E85AB4940C3F5285C8FC22840EC51B81E85AB4940C3F5285C8FC22840068195438BAC494048E17A14AEC72840068195438BAC4940'::geometry ~ offset_geom)
  • Heap Blocks: exact=1213
4. 0.807 0.807 ↓ 9.2 1,784 1

Bitmap Index Scan on point_geom_idx (cost=0.00..9.74 rows=194 width=0) (actual time=0.807..0.807 rows=1,784 loops=1)

  • Index Cond: ('0103000000010000000500000048E17A14AEC72840068195438BAC494048E17A14AEC72840EC51B81E85AB4940C3F5285C8FC22840EC51B81E85AB4940C3F5285C8FC22840068195438BAC494048E17A14AEC72840068195438BAC4940'::geometry ~ offset_geom)
5.          

CTE filtered_points

6. 0.169 10.685 ↓ 33.2 797 1

Limit (cost=0.00..3.88 rows=24 width=959) (actual time=1.033..10.685 rows=797 loops=1)

7. 10.516 10.516 ↓ 33.2 797 1

CTE Scan on selected_points (cost=0.00..3.88 rows=24 width=959) (actual time=1.032..10.516 rows=797 loops=1)

  • Filter: ((is_duplicate IS FALSE) AND (is_preview IS FALSE) AND (is_all_timeslots_latest IS TRUE))
  • Rows Removed by Filter: 987
8. 11.973 11.973 ↓ 33.2 797 1

CTE Scan on filtered_points points (cost=0.00..0.48 rows=24 width=612) (actual time=1.034..11.973 rows=797 loops=1)

Planning time : 1.576 ms
Execution time : 189.004 ms