explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6f6s

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=198.03..198.04 rows=1 width=148) (actual rows= loops=)

  • Sort Key: pro.pro_nome
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=197.99..198.02 rows=1 width=148) (actual rows= loops=)

  • Group Key: pro.pro_cod, trm.trm_cod
3. 0.000 0.000 ↓ 0.0

Sort (cost=197.99..197.99 rows=1 width=88) (actual rows= loops=)

  • Sort Key: pro.pro_cod
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.73..197.98 rows=1 width=88) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.31..189.53 rows=1 width=98) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.03..181.22 rows=1 width=99) (actual rows= loops=)

  • Join Filter: ((pdt.pdt_dis_cod)::text = (dis.dis_cod)::text)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.75..179.84 rows=1 width=116) (actual rows= loops=)

  • Join Filter: (pdt.pdt_pro_cod = pro.pro_cod)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.48..178.50 rows=1 width=58) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on pdt (cost=4.35..33.16 rows=9 width=23) (actual rows= loops=)

  • Recheck Cond: ((pdt_trm_cod)::text = '2C33ED930B'::text)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pdt_fk_pdt_trm (cost=0.00..4.35 rows=9 width=0) (actual rows= loops=)

  • Index Cond: ((pdt_trm_cod)::text = '2C33ED930B'::text)
11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on rad (cost=12.12..16.14 rows=1 width=35) (actual rows= loops=)

  • Recheck Cond: (((rad_trm_cod)::text = '2C33ED930B'::text) AND (rad_pro_cod = pdt.pdt_pro_cod))
  • Filter: ((pdt.pdt_dis_cod)::text = (rad_dis_cod)::text)
12. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=12.12..12.12 rows=1 width=0) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on rad_fk_rad_trm (cost=0.00..5.40 rows=131 width=0) (actual rows= loops=)

  • Index Cond: ((rad_trm_cod)::text = '2C33ED930B'::text)
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on rad_fk_rad_pro (cost=0.00..6.44 rows=286 width=0) (actual rows= loops=)

  • Index Cond: (rad_pro_cod = pdt.pdt_pro_cod)
15. 0.000 0.000 ↓ 0.0

Index Scan using pro_pkey on pro (cost=0.28..1.33 rows=1 width=66) (actual rows= loops=)

  • Index Cond: (pro_cod = rad.rad_pro_cod)
16. 0.000 0.000 ↓ 0.0

Index Only Scan using dis_pkey on dis (cost=0.28..1.36 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (dis_cod = (rad.rad_dis_cod)::text)
17. 0.000 0.000 ↓ 0.0

Index Only Scan using trm_pkey on trm (cost=0.28..8.30 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (trm_cod = '2C33ED930B'::text)
18. 0.000 0.000 ↓ 0.0

Index Only Scan using mtr_mtr_alu_mat_mtr_trm_cod_mtr_ano_mtr_gcc_cod_mtr_periodo_key on mtr (cost=0.42..8.44 rows=1 width=10) (actual rows= loops=)

  • Index Cond: ((mtr_alu_mat = 30,069) AND (mtr_trm_cod = '2C33ED930B'::text) AND (mtr_ano = '2020'::text) AND (mtr_gcc_cod = 'CSAGEO'::text))