explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Ur3

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

Aggregate (cost=224.21..224.22 rows=1 width=32) (actual time=0.530..0.530 rows=1 loops=1)

2. 0.527 0.527 ↓ 0.0 0 1

Index Scan using idx_seriedatad1 on itemseriehistorica nova_tabela (cost=0.41..224.21 rows=1 width=5) (actual time=0.527..0.527 rows=0 loops=1)

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