explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9kXB

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.011 ↑ 1.0 1 1

Aggregate (cost=4,812.79..4,812.80 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

2. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=127.36..4,807.86 rows=1,971 width=0) (actual time=0.007..0.007 rows=0 loops=1)

3. 0.007 0.007 ↓ 0.0 0 1

Index Scan using producto_stock_producto_id_idx on producto_stock ps (cost=0.14..2.36 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (producto_id = 29,984)
4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on producto_stock_detalle psd (cost=127.22..4,782.28 rows=2,322 width=8) (never executed)

  • Recheck Cond: (producto_stock_id = ps.id)
  • Filter: (activo AND (venta_detalle_id IS NULL))
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on producto_stock_detalle_producto_stock_id_idx (cost=0.00..126.63 rows=7,058 width=0) (never executed)

  • Index Cond: (producto_stock_id = ps.id)
Planning time : 0.279 ms
Execution time : 0.061 ms