explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TDt

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

Nested Loop (cost=6.04..358.88 rows=1 width=4) (actual time=0.769..1.500 rows=1 loops=1)

2. 0.006 0.083 ↑ 1.0 1 1

Nested Loop (cost=0.00..6.81 rows=1 width=4) (actual time=0.077..0.083 rows=1 loops=1)

  • Join Filter: (co.origem_id = o.id)
  • Rows Removed by Join Filter: 1
3. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on tb_origem o (cost=0.00..1.07 rows=1 width=4) (actual time=0.007..0.009 rows=1 loops=1)

  • Filter: ((codigo)::integer = 701)
  • Rows Removed by Filter: 3
4. 0.068 0.068 ↑ 1.0 2 1

Seq Scan on tb_classificacao_orcamentaria co (cost=0.00..5.71 rows=2 width=8) (actual time=0.064..0.068 rows=2 loops=1)

  • Filter: ((ano = '2018'::bpchar) AND (sequencial = 6))
  • Rows Removed by Filter: 179
5. 1.197 1.414 ↑ 1.0 1 1

Bitmap Heap Scan on tb_processo_empenho pc (cost=6.04..352.06 rows=1 width=8) (actual time=0.690..1.414 rows=1 loops=1)

  • Recheck Cond: (classificacao_orcamentaria_id = co.id)
  • Filter: ((nr_empenho)::integer = 649)
  • Rows Removed by Filter: 1553
  • Heap Blocks: exact=179
6. 0.217 0.217 ↓ 6.6 1,554 1

Bitmap Index Scan on tb_processo_empenho_classificacao_orcamentaria_idx (cost=0.00..6.04 rows=234 width=0) (actual time=0.217..0.217 rows=1,554 loops=1)

  • Index Cond: (classificacao_orcamentaria_id = co.id)
Planning time : 1.008 ms
Execution time : 1.572 ms