explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HLlm

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 630.598 ↑ 1.0 20 1

Limit (cost=79,912.85..79,915.25 rows=20 width=405) (actual time=598.726..630.598 rows=20 loops=1)

2. 96.707 630.591 ↑ 11,452.0 20 1

Gather Merge (cost=79,912.85..107,336.87 rows=229,040 width=405) (actual time=598.724..630.591 rows=20 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 426.386 533.884 ↑ 245.8 233 5 / 5

Sort (cost=78,912.79..79,055.94 rows=57,260 width=405) (actual time=533.825..533.884 rows=233 loops=5)

  • Sort Key: (((locality_name_lower)::text = 'ЫЫЫ'::text)) DESC, is_owner DESC, area DESC
  • Sort Method: external merge Disk: 25328kB
4. 107.498 107.498 ↑ 1.2 45,951 5 / 5

Parallel Seq Scan on geo (cost=0.00..74,387.75 rows=57,260 width=405) (actual time=0.030..107.498 rows=45,951 loops=5)