explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pZuH : geoname

Settings
# exclusive inclusive rows x rows loops node
1. 22.269 404.965 ↑ 3.3 367 1

Gather (cost=1,000.00..367,195.79 rows=1,199 width=198) (actual time=0.705..404.965 rows=367 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=448 read=303082
2. 382.696 382.696 ↑ 4.1 122 3 / 3

Parallel Seq Scan on geoname (cost=0.00..366,075.89 rows=500 width=198) (actual time=0.847..382.696 rows=122 loops=3)

  • Filter: ((name)::text ~~ 'Georgia%'::text)
  • Rows Removed by Filter: 4001857
  • Buffers: shared hit=448 read=303082
Planning time : 0.580 ms
Execution time : 405.029 ms