explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ncTJ

Settings
# exclusive inclusive rows x rows loops node
1. 33.317 241.373 ↑ 1.0 1 1

Aggregate (cost=339,953.46..339,953.47 rows=1 width=0) (actual time=241.373..241.373 rows=1 loops=1)

2. 186.372 208.056 ↓ 1.2 140,148 1

Bitmap Heap Scan on error_log (cost=2,997.39..339,649.98 rows=121,389 width=0) (actual time=40.625..208.056 rows=140,148 loops=1)

  • Recheck Cond: (15658562 = store_id)
  • Filter: ((action)::text <> 'template'::text)
  • Rows Removed by Filter: 753
  • Heap Blocks: exact=81846
3. 21.684 21.684 ↓ 1.1 140,901 1

Bitmap Index Scan on error_log_store_idx (cost=0.00..2,967.05 rows=128,881 width=0) (actual time=21.684..21.684 rows=140,901 loops=1)

  • Index Cond: (15658562 = store_id)