explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7NtF : foo

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 255.998 ↑ 1.0 100 1

Limit (cost=1,000.00..31,540.52 rows=100 width=198) (actual time=0.717..255.998 rows=100 loops=1)

  • Buffers: shared hit=3,918 read=193,329
2. 6.394 255.979 ↑ 12.0 100 1

Gather (cost=1,000.00..367,180.83 rows=1,199 width=198) (actual time=0.715..255.979 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=3,918 read=193,329
3. 249.585 249.585 ↑ 14.3 35 3 / 3

Parallel Seq Scan on geoname (cost=0.00..366,060.93 rows=500 width=198) (actual time=1.001..249.585 rows=35 loops=3)

  • Filter: ((name)::text ~~ 'Georgia%'::text)
  • Rows Removed by Filter: 2,612,804
  • Buffers: shared hit=3,918 read=193,329
Planning time : 0.203 ms
Execution time : 256.058 ms