explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RTsw

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

Aggregate (cost=26,299.87..26,299.88 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=380.51..26,299.85 rows=7 width=8) (actual rows= loops=)

  • Hash Cond: ((i.ale_iten_item_codigo)::text = ((m.men_codigo)::character varying)::text)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=197.81..26,084.20 rows=25 width=14) (actual rows= loops=)

  • Hash Cond: (i.cod_usu_alerta = al.ale_codigo)
4. 0.000 0.000 ↓ 0.0

Seq Scan on usu_alerta_itens i (cost=0.00..25,878.68 rows=1,993 width=18) (actual rows= loops=)

  • Filter: ((ale_iten_visualizado = 'N'::bpchar) AND ((NULLIF((ale_iten_json ->> 'codPessoa'::text), ''::text))::integer = 22,856))
5. 0.000 0.000 ↓ 0.0

Hash (cost=192.51..192.51 rows=424 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using usu_alerta_cod_usu_alerta_tipo_idx on usu_alerta al (cost=0.29..192.51 rows=424 width=4) (actual rows= loops=)

  • Index Cond: (cod_usu_alerta_tipo = 5)
7. 0.000 0.000 ↓ 0.0

Hash (cost=138.98..138.98 rows=3,498 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on ate_mensagem m (cost=0.00..138.98 rows=3,498 width=4) (actual rows= loops=)