explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OPSg

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 23.105 ↑ 1.0 1 1

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

2. 23.089 23.089 ↓ 0.0 0 1

Seq Scan on "tmpFlattened_b787799f48264f8a9593686999e54c9f" f (cost=0.00..2,418.64 rows=1 width=4) (actual time=23.089..23.089 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 : 2.197 ms