explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BkKR

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 5.302 ↑ 1.0 1 1

Aggregate (cost=595.85..595.86 rows=1 width=32) (actual time=5.302..5.302 rows=1 loops=1)

2. 0.003 5.298 ↓ 0.0 0 1

Bitmap Heap Scan on "tmpFlattened_b787799f48264f8a9593686999e54c9f" f (cost=588.01..595.85 rows=2 width=4) (actual time=5.298..5.298 rows=0 loops=1)

  • Recheck Cond: ("ItemDescription" ~~ 'ASSETS:Non-current Assets:Heritage Assets:Cost Model:Other Heritage Assets:Archives Cost:Opening Balance%'::text)
3. 5.295 5.295 ↓ 0.0 0 1

Bitmap Index Scan on "IX_tmpFlattened_b787799f48264f8a9593686999e54c9f_ItDesc_FinYr2" (cost=0.00..588.01 rows=2 width=0) (actual time=5.295..5.295 rows=0 loops=1)

  • Index Cond: ("ItemDescription" ~~ 'ASSETS:Non-current Assets:Heritage Assets:Cost Model:Other Heritage Assets:Archives Cost:Opening Balance%'::text)