explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NekI

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.041 ↑ 26.0 1 1

Nested Loop (cost=211.69..688.33 rows=26 width=11) (actual time=0.040..0.041 rows=1 loops=1)

2. 0.020 0.020 ↑ 1.0 1 1

Index Scan using contabil_conta_pkey on contabil_conta (cost=0.41..4.43 rows=1 width=23) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((id)::text = '15-CMd77cZC'::text)
  • Filter: (orcamento_id = 15)
3. 0.008 0.017 ↑ 9.0 1 1

Bitmap Heap Scan on contabil_conta t3 (cost=211.29..683.82 rows=9 width=30) (actual time=0.016..0.017 rows=1 loops=1)

  • Recheck Cond: ((rght >= contabil_conta.lft) AND (rght <= contabil_conta.rght))
  • Filter: ((orcamento_id = 15) AND ((nivel)::text = 'A'::text) AND ((contabil_conta.tree_id)::text = (tree_id)::text))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=4
4. 0.009 0.009 ↑ 72.0 4 1

Bitmap Index Scan on contabil_conta_3cfbd988 (cost=0.00..211.29 rows=288 width=0) (actual time=0.009..0.009 rows=4 loops=1)

  • Index Cond: ((rght >= contabil_conta.lft) AND (rght <= contabil_conta.rght))