explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mHIv

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 18.746 ↑ 2.0 4 1

Nested Loop Left Join (cost=0.57..550.23 rows=8 width=154) (actual time=14.489..18.746 rows=4 loops=1)

2. 0.059 18.663 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.28..549.38 rows=1 width=77) (actual time=14.423..18.663 rows=1 loops=1)

  • Join Filter: (apc.category_id = ac.id)
  • Rows Removed by Join Filter: 72
3. 0.074 18.475 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.28..544.91 rows=1 width=66) (actual time=14.239..18.475 rows=1 loops=1)

4. 18.306 18.306 ↑ 1.0 1 1

Seq Scan on prod_produto pp (cost=0.00..542.61 rows=1 width=58) (actual time=14.073..18.306 rows=1 loops=1)

  • Filter: (ativo AND ((codigoalfa)::text = 'BIORETPR'::text))
  • Rows Removed by Filter: 8288
5. 0.095 0.095 ↑ 1.0 1 1

Index Scan using un_agnd_prod_config_prod on agnd_prod_config apc (cost=0.28..2.30 rows=1 width=24) (actual time=0.094..0.095 rows=1 loops=1)

  • Index Cond: (product_id = pp.id)
6. 0.129 0.129 ↓ 1.1 73 1

Seq Scan on agnd_category ac (cost=0.00..3.65 rows=65 width=27) (actual time=0.038..0.129 rows=73 loops=1)

7. 0.064 0.064 ↑ 3.5 4 1

Index Scan using in_agnd_prod_conf_ofer_conf on agnd_prod_conf_oferecido apco (cost=0.29..0.72 rows=14 width=85) (actual time=0.053..0.064 rows=4 loops=1)

  • Index Cond: (prod_conf_id = apc.id)
Planning time : 18.336 ms
Execution time : 19.281 ms