explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3nmZA

Settings
# exclusive inclusive rows x rows loops node
1. 4.695 16.149 ↑ 1.0 15,109 1

Sort (cost=1,857.84..1,895.86 rows=15,206 width=12) (actual time=14.723..16.149 rows=15,109 loops=1)

  • Sort Key: (array_position('{1,2}'::integer[], cod_almacen))
  • Sort Method: quicksort Memory: 1093kB
2. 11.454 11.454 ↑ 1.0 15,109 1

Seq Scan on productos_almacen (cost=0.00..801.61 rows=15,206 width=12) (actual time=0.028..11.454 rows=15,109 loops=1)

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