explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M3V3

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

Aggregate (cost=595.86..595.87 rows=1 width=32) (actual time=5.115..5.115 rows=1 loops=1)

2. 0.004 5.111 ↓ 0.0 0 1

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

  • Recheck Cond: ("ItemDescription" ~~ 'ASSETS:Non-current Assets:Heritage Assets:Cost Model:Other Heritage Assets:Archives Cost:Opening Balance%'::text)
  • Filter: ("FinancialYear" = 2018)
3. 5.107 5.107 ↓ 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.107..5.107 rows=0 loops=1)

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