explain.depesz.com

PostgreSQL's explain analyze made readable

Result: II1P : Optimization for: Optimization for: plan #KiXS; plan #usNb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.618 168.815 ↓ 5.5 797 1

Subquery Scan on feature_collection (cost=9.77..1,067.91 rows=144 width=24) (actual time=0.978..168.815 rows=797 loops=1)

2. 0.182 168.197 ↓ 5.5 797 1

Limit (cost=9.77..1,066.47 rows=144 width=96) (actual time=0.971..168.197 rows=797 loops=1)

3. 167.485 168.015 ↓ 5.5 797 1

Bitmap Heap Scan on points (cost=9.77..1,066.47 rows=144 width=96) (actual time=0.970..168.015 rows=797 loops=1)

  • Recheck Cond: ('0103000000010000000500000048E17A14AEC72840068195438BAC494048E17A14AEC72840EC51B81E85AB4940C3F5285C8FC22840EC51B81E85AB4940C3F5285C8FC22840068195438BAC494048E17A14AEC72840068195438BAC4940'::geometry ~ offset_geom)
  • Filter: ((is_duplicate IS FALSE) AND (is_preview IS FALSE) AND (is_all_timeslots_latest IS TRUE))
  • Rows Removed by Filter: 987
  • Heap Blocks: exact=1213
4. 0.530 0.530 ↓ 9.2 1,784 1

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

  • Index Cond: ('0103000000010000000500000048E17A14AEC72840068195438BAC494048E17A14AEC72840EC51B81E85AB4940C3F5285C8FC22840EC51B81E85AB4940C3F5285C8FC22840068195438BAC494048E17A14AEC72840068195438BAC4940'::geometry ~ offset_geom)
Planning time : 1.639 ms
Execution time : 169.809 ms