explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E68Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 18.503 ↑ 1.0 1 1

Aggregate (cost=2,418.64..2,418.65 rows=1 width=32) (actual time=18.502..18.503 rows=1 loops=1)

2. 18.497 18.497 ↓ 0.0 0 1

Seq Scan on "tmpFlattened_b787799f48264f8a9593686999e54c9f" f (cost=0.00..2,418.64 rows=1 width=4) (actual time=18.497..18.497 rows=0 loops=1)

  • Filter: (("ItemDescription" ~~ 'assets:non-current assets:heritage assets:cost model:other heritage assets:archives cost:opening balance%'::text) AND ("FinancialYear" = 2018))
  • Rows Removed by Filter: 30309
Planning time : 1.522 ms