explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1t8

Settings
# exclusive inclusive rows x rows loops node
1. 0.450 1.880 ↓ 1.0 728 1

Sort (cost=61.69..63.51 rows=727 width=12) (actual time=1.808..1.880 rows=728 loops=1)

  • Sort Key: ("position"(array_to_string('{2,1}'::integer[], ','::text), textin(int4out(cod_almacen))))
  • Sort Method: quicksort Memory: 59kB
2. 1.430 1.430 ↓ 1.0 728 1

Seq Scan on productos_almacen (cost=0.00..27.14 rows=727 width=12) (actual time=0.038..1.430 rows=728 loops=1)

  • Filter: (cod_almacen = ANY ('{1,2}'::integer[]))
  • Rows Removed by Filter: 13