explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PbbP

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.036 ↑ 1.0 1 1

Sort (cost=9.72..9.73 rows=1 width=40) (actual time=0.036..0.036 rows=1 loops=1)

  • Sort Key: orden
  • Sort Method: quicksort Memory: 25kB
2. 0.027 0.027 ↑ 1.0 1 1

Index Scan using f_prod_idx on fotos (cost=0.29..9.71 rows=1 width=40) (actual time=0.024..0.027 rows=1 loops=1)

  • Index Cond: (cod_producto = 10002808)
  • Filter: (((visibilidad)::text = 'S'::text) AND ((principal)::text = 'S'::text) AND ((size)::text = 'XL'::text))
  • Rows Removed by Filter: 3