explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KSrV

Settings
# exclusive inclusive rows x rows loops node
1. 5.235 24.019 ↑ 1.0 15,109 1

Sort (cost=1,971.89..2,009.90 rows=15,206 width=12) (actual time=22.514..24.019 rows=15,109 loops=1)

  • Sort Key: ("position"(array_to_string('{2,1}'::integer[], ','::text), textin(int4out(cod_almacen))))
  • Sort Method: quicksort Memory: 1093kB
2. 18.784 18.784 ↑ 1.0 15,109 1

Seq Scan on productos_almacen (cost=0.00..915.65 rows=15,206 width=12) (actual time=0.026..18.784 rows=15,109 loops=1)

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