explain.depesz.com

PostgreSQL's explain analyze made readable

Result: usNb : Optimization for: plan #KiXS

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 183.987 183.987 ↓ 33.2 797 1

CTE Scan on filtered_points points (cost=706.04..767.24 rows=24 width=32) (actual time=2.006..183.987 rows=797 loops=1)

2.          

CTE selected_points

3. 14.836 15.574 ↓ 9.2 1,784 1

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

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

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

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

CTE filtered_points

6. 0.173 18.320 ↓ 33.2 797 1

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

7. 18.147 18.147 ↓ 33.2 797 1

CTE Scan on selected_points (cost=0.00..3.88 rows=24 width=959) (actual time=0.957..18.147 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
Planning time : 0.475 ms
Execution time : 185.145 ms