explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ypjK

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

GroupAggregate (cost=25.35..25.37 rows=1 width=12) (actual time=0.007..0.007 rows=0 loops=1)

  • Group Key: selo.id_cartorio
2. 0.003 0.007 ↓ 0.0 0 1

Sort (cost=25.35..25.36 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: selo.id_cartorio
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.27..25.34 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((selo_analisado.cs_situacao_isento <> 2) OR (selo_analisado.cs_situacao_isento IS NULL))
4. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.85..16.89 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=1)

5. 0.004 0.004 ↓ 0.0 0 1

Index Scan using selo_dt_selo_idx on selo (cost=0.43..8.45 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((dt_selo >= '2020-08-01 00:00:00'::timestamp without time zone) AND (dt_selo <= '2020-08-31 23:59:59'::timestamp without time zone))
  • Filter: (cs_situacao_selo = 0)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using selo_compensado_pkey on selo_compensado (cost=0.42..8.44 rows=1 width=4) (never executed)

  • Index Cond: (id_selo_compensado = selo.id_selo_compensado)
  • Filter: ((cs_situacao_compensado IS NOT NULL) AND (cs_situacao_compensado = 0))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using selo_analisado_pkey on selo_analisado (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Index Cond: (id_selo_analisado = selo.id_selo_analisado)