explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vQk8

Settings
# exclusive inclusive rows x rows loops node
1. 27.873 488.634 ↑ 1.0 1 1

Aggregate (cost=367,489.09..367,489.10 rows=1 width=0) (actual time=488.634..488.634 rows=1 loops=1)

2. 271.305 460.761 ↓ 1.2 140,148 1

Sort (cost=365,668.25..365,971.73 rows=121,389 width=275) (actual time=405.313..460.761 rows=140,148 loops=1)

  • Sort Key: error_log.id
  • Sort Method: external merge Disk: 43928kB
3. 169.014 189.456 ↓ 1.2 140,148 1

Bitmap Heap Scan on error_log (cost=2,997.39..339,649.89 rows=121,389 width=275) (actual time=36.702..189.456 rows=140,148 loops=1)

  • Recheck Cond: (15658562 = store_id)
  • Filter: ((action)::text <> 'template'::text)
  • Rows Removed by Filter: 753
  • Heap Blocks: exact=81846
4. 20.442 20.442 ↓ 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=20.442..20.442 rows=140,901 loops=1)

  • Index Cond: (15658562 = store_id)
Planning time : 0.135 ms
Execution time : 498.443 ms