explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R6j3 : Optimization for: plan #6Y78

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.088 184.670 ↑ 1.0 500 1

Limit (cost=1,000.45..73,019.80 rows=500 width=187) (actual time=41.930..184.670 rows=500 loops=1)

2. 0.000 184.582 ↑ 519.5 500 1

Unique (cost=1,000.45..37,414,041.87 rows=259,743 width=187) (actual time=41.928..184.582 rows=500 loops=1)

3. 86.695 205.046 ↑ 390.7 703 1

Gather Merge (cost=1,000.45..37,411,982.02 rows=274,646 width=187) (actual time=41.925..205.046 rows=703 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 118.351 118.351 ↑ 482.9 237 3 / 3

Parallel Index Scan using records_pid_county_state_updated_at on records record (cost=0.43..37,379,281.03 rows=114,436 width=187) (actual time=0.355..118.351 rows=237 loops=3)

  • Filter: ((deleted_at IS NULL) AND ((group_id IS NULL) OR (group_id = 36)) AND st_within(location, '0103000020E61000000100000005000000543A58FFE7A557C08350DEC7D1EA454061C43E01147B56C08350DEC7D1EA454061C43E01147B56C01DE5603601EE4640543A58FFE7A557C01DE5603601EE4640543A58FFE7A557C08350DEC7D1EA4540'::geometry))