explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gB6K

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.033 ↑ 1.0 100 1

Limit (cost=0.00..1.93 rows=100 width=48) (actual time=0.012..0.033 rows=100 loops=1)

  • Output: id, arr
  • Buffers: local hit=1
2. 0.020 0.020 ↑ 2,532.7 100 1

Seq Scan on pg_temp_97.t (cost=0.00..4,899.69 rows=253,269 width=48) (actual time=0.012..0.020 rows=100 loops=1)

  • Output: id, arr
  • Buffers: local hit=1
Planning time : 0.076 ms
Execution time : 0.056 ms