explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wcZP

Settings
# exclusive inclusive rows x rows loops node
1. 55.778 348.731 ↑ 2.5 80 1

HashAggregate (cost=249,792.43..249,796.93 rows=200 width=50) (actual time=348.666..348.731 rows=80 loops=1)

  • Group Key: p.road_seams
2.          

CTE selected_points

3. 111.280 126.434 ↑ 1.0 167,361 1

Bitmap Heap Scan on points p_1 (cost=76,310.50..240,963.02 rows=168,179 width=385) (actual time=18.477..126.434 rows=167,361 loops=1)

  • Filter: ((is_all_timeslots_latest IS TRUE) AND (is_duplicate IS FALSE) AND (is_preview IS FALSE))
  • Rows Removed by Filter: 3117
  • Heap Blocks: exact=24851
4. 15.154 15.154 ↓ 2.0 339,265 1

Bitmap Index Scan on points_is_all_timeslots_latest_idx (cost=0.00..76,268.46 rows=171,522 width=0) (actual time=15.154..15.154 rows=339,265 loops=1)

  • Index Cond: (is_all_timeslots_latest = true)
5.          

Initplan (for HashAggregate)

6. 15.610 60.202 ↑ 1.0 1 1

Aggregate (cost=3,784.03..3,784.04 rows=1 width=8) (actual time=60.202..60.202 rows=1 loops=1)

7. 44.592 44.592 ↑ 1.0 167,361 1

CTE Scan on selected_points (cost=0.00..3,363.58 rows=168,179 width=0) (actual time=0.012..44.592 rows=167,361 loops=1)

8. 232.751 232.751 ↑ 1.0 167,361 1

CTE Scan on selected_points p (cost=0.00..3,363.58 rows=168,179 width=518) (actual time=18.479..232.751 rows=167,361 loops=1)

Planning time : 0.190 ms
Execution time : 363.112 ms