explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z8GK

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 15,591.103 ↓ 10.0 10 1

Limit (cost=33,267.22..33,267.23 rows=1 width=326) (actual time=15,591.099..15,591.103 rows=10 loops=1)

2. 0.471 15,591.090 ↓ 180.0 180 1

Sort (cost=33,267.22..33,267.22 rows=1 width=326) (actual time=15,591.070..15,591.090 rows=180 loops=1)

  • Sort Key: processodo0_.dt_juntada DESC
  • Sort Method: quicksort Memory: 96kB
3. 11.436 15,590.619 ↓ 206.0 206 1

Nested Loop (cost=0.99..33,267.21 rows=1 width=326) (actual time=3.845..15,590.619 rows=206 loops=1)

4. 33.864 15,375.333 ↓ 33,975.0 33,975 1

Nested Loop Left Join (cost=0.56..33,258.71 rows=1 width=326) (actual time=0.232..15,375.333 rows=33,975 loops=1)

  • Join Filter: ((processodo0_.id_processo_documento)::integer = processodo0_1_.id_documento_voto)
5. 15,341.469 15,341.469 ↓ 33,975.0 33,975 1

Index Scan using idx_prdo_id_documento_principal on tb_processo_documento processodo0_ (cost=0.56..33,197.86 rows=1 width=318) (actual time=0.227..15,341.469 rows=33,975 loops=1)

  • Index Cond: ((id_documento_principal IS NULL) AND (id_documento_principal IS NULL) AND (id_documento_principal IS NULL) AND (id_documento_principal IS NULL) AND (id_documento_principal IS NULL) AND (id_documento_principal IS NULL) AND (id_documento_pri
  • Filter: ((NOT in_lido) AND in_ativo AND (NOT in_lido) AND in_ativo AND in_ativo AND in_ativo AND (NOT in_lido) AND in_ativo AND (NOT in_lido) AND (NOT in_lido) AND in_ativo AND (NOT in_lido) AND (NOT in_lido) AND in_ativo AND (NOT in_lido) AND (NOT in_
  • Rows Removed by Filter: 11800510
6. 0.000 0.000 ↓ 0.0 0 33,975

Seq Scan on tb_documento_voto processodo0_1_ (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.000..0.000 rows=0 loops=33,975)

7. 203.850 203.850 ↓ 0.0 0 33,975

Index Scan using tb_processo_trf_id_processo_trf_cd_processo_status_idx on tb_processo_trf processotr1_ (cost=0.42..8.49 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=33,975)

  • Index Cond: (((id_processo_trf)::integer = (processodo0_.id_processo)::integer) AND (cd_processo_status = 'D'::bpchar))
  • Filter: (((dt_autuacao)::timestamp without time zone <= '2019-04-28 00:00:00.303'::timestamp without time zone) AND ((dt_autuacao)::timestamp without time zone <= '2019-04-28 00:00:00.303'::timestamp without time zone) AND ((dt_autuacao)::timestamp without t
  • Rows Removed by Filter: 1