explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tmJv

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.031 ↓ 2.0 2 1

Sort (cost=1.40..1.40 rows=1 width=96) (actual time=0.031..0.031 rows=2 loops=1)

  • Output: _idrref, _description, _fld3584rref
  • Sort Key: t1._idrref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
2. 0.024 0.024 ↓ 2.0 2 1

Seq Scan on public._reference3492 t1 (cost=0.00..1.40 rows=1 width=96) (actual time=0.017..0.024 rows=2 loops=1)

  • Output: _idrref, _description, _fld3584rref
  • Filter: ((t1._idrref = ANY ('{"\\\\x980c704d7b865dce11e88e3ef41121d9","\\\\x980c704d7b865dce11e88e3ef41121e3"}'::bytea[])) AND (t1._fld188 = '0'::numeric))
  • Rows Removed by Filter: 33
  • Buffers: shared hit=2
Planning time : 0.141 ms
Execution time : 0.047 ms