explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Y78

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 81.352 2,506.923 ↑ 1.0 500 1

Limit (cost=124,395.13..124,400.42 rows=500 width=187) (actual time=2,506.245..2,506.923 rows=500 loops=1)

  • JIT:
  • Functions: 14
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 21.073 ms, Inlining 0.000 ms, Optimization 20.055 ms, Emission 234.311 ms, Total 275.440 ms
2. 0.180 2,425.571 ↑ 519.5 500 1

Unique (cost=124,395.13..127,141.59 rows=259,743 width=187) (actual time=2,424.925..2,425.571 rows=500 loops=1)

3. 1,442.594 2,425.391 ↑ 390.7 703 1

Sort (cost=124,395.13..125,081.74 rows=274,646 width=187) (actual time=2,424.922..2,425.391 rows=703 loops=1)

  • Sort Key: pid, county, state, updated_at DESC
  • Sort Method: external merge Disk: 37704kB
4. 11.309 982.797 ↓ 1.0 280,370 1

Gather (cost=1,185.33..74,237.69 rows=274,646 width=187) (actual time=130.278..982.797 rows=280,370 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 936.732 971.488 ↑ 1.2 93,457 3 / 3

Parallel Bitmap Heap Scan on records record (cost=185.33..45,773.09 rows=114,436 width=187) (actual time=157.159..971.488 rows=93,457 loops=3)

  • Filter: ((deleted_at IS NULL) AND ((group_id IS NULL) OR (group_id = 36)) AND st_within(location, '0103000020E61000000100000005000000543A58FFE7A557C08350DEC7D1EA454061C43E01147B56C08350DEC7D1EA454061C43E01147B56C01DE5603601EE4640543A58FFE7A557C01DE5603601EE4640543A58FFE7A557C08350DEC7D1EA4540'::geometry))
  • Rows Removed by Filter: 3867
  • Heap Blocks: exact=26932
6. 34.756 34.756 ↓ 92.9 300,525 1 / 3

Bitmap Index Scan on records_location (cost=0.00..116.67 rows=3,234 width=0) (actual time=104.268..104.268 rows=300,525 loops=1)

  • Index Cond: (location @ '0103000020E61000000100000005000000543A58FFE7A557C08350DEC7D1EA454061C43E01147B56C08350DEC7D1EA454061C43E01147B56C01DE5603601EE4640543A58FFE7A557C01DE5603601EE4640543A58FFE7A557C08350DEC7D1EA4540'::geometry)
Planning time : 62.458 ms
Execution time : 2,548.184 ms