explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X79

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

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

  • Output: id, (arr[1:4])
  • Buffers: local hit=1
2. 0.060 0.060 ↑ 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.017..0.060 rows=100 loops=1)

  • Output: id, arr[1:4]
  • Buffers: local hit=1
Planning time : 0.071 ms
Execution time : 0.101 ms