explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GnZB

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.033 ↑ 3.0 1 1

Group (cost=0.28..4.34 rows=3 width=4) (actual time=0.022..0.033 rows=1 loops=1)

  • Group Key: cod_producto
2. 0.024 0.024 ↓ 1.3 4 1

Index Only Scan using pmkp_cpcmpkcsidx on prod_mkp (cost=0.28..4.33 rows=3 width=4) (actual time=0.018..0.024 rows=4 loops=1)

  • Index Cond: (cod_producto = 10000225)
  • Heap Fetches: 4
Planning time : 0.105 ms
Execution time : 0.059 ms