explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FchO

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 5.355 ↓ 0.0 0 1

Sort (cost=945.73..948.48 rows=1,102 width=12) (actual time=5.355..5.355 rows=0 loops=1)

  • Sort Key: lft
  • Sort Method: quicksort Memory: 25kB
2. 4.979 5.325 ↓ 0.0 0 1

Bitmap Heap Scan on enterprise (cost=63.38..890.04 rows=1,102 width=12) (actual time=5.325..5.325 rows=0 loops=1)

  • Recheck Cond: (rght >= 9122)
  • Filter: ((lft <= 9121) AND (tree_id = 5) AND (node_type = ANY ('{2,3,4}'::integer[])))
  • Rows Removed by Filter: 3040
  • Heap Blocks: exact=634
3. 0.346 0.346 ↑ 1.0 3,041 1

Bitmap Index Scan on enterprise_rght (cost=0.00..63.10 rows=3,043 width=0) (actual time=0.346..0.346 rows=3,041 loops=1)

  • Index Cond: (rght >= 9122)