explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nlvl

Settings
# exclusive inclusive rows x rows loops node
1. 22.513 24.591 ↓ 2.2 2,587 1

Bitmap Heap Scan on organizations (cost=165.60..4,445.56 rows=1,186 width=122) (actual time=2.369..24.591 rows=2,587 loops=1)

  • Recheck Cond: (path ~ 'root.2db04824152a46c2993905dac5fe3033.*{1,}'::lquery)
  • Heap Blocks: exact=2113
2. 2.078 2.078 ↓ 2.2 2,587 1

Bitmap Index Scan on path_gist_idx (cost=0.00..165.31 rows=1,186 width=0) (actual time=2.072..2.078 rows=2,587 loops=1)

  • Index Cond: (path ~ 'root.2db04824152a46c2993905dac5fe3033.*{1,}'::lquery)
Planning time : 0.099 ms
Execution time : 42.739 ms