explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WaqK

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 0.034 ↑ 1.0 1 1

Aggregate (cost=8.32..8.33 rows=1 width=32) (actual time=0.034..0.034 rows=1 loops=1)

2. 0.031 0.031 ↓ 0.0 0 1

Index Scan using idx_seriedata on itemseriehistorica nova_tabela (cost=0.29..8.31 rows=1 width=5) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: (((seriehistorica)::text = 'SERIE_EV_POR_DIA'::text) AND (dataocorrencia >= '2018-09-01 00:00:00'::timestamp without time zone) AND (dataocorrencia <= '2018-09-01 00:00:00'::timestamp without time zone))
  • Filter: (((dimensao3)::text ~~ '%Confirmação de Prenhez%'::text) AND ((dimensao1)::text = '54161ea4393ad734f193eceaf5a09b10'::text) AND ((dimensao2)::text = '11'::text))
  • Rows Removed by Filter: 3