explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b9pD

Settings
# exclusive inclusive rows x rows loops node
1. 27.923 61,500.663 ↑ 1.0 1 1

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

2. 420.553 61,472.740 ↓ 1.2 140,148 1

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

  • Sort Key: error_log.id
  • Sort Method: external merge Disk: 43928kB
3. 60,583.195 61,052.187 ↓ 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=486.837..61,052.187 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. 468.992 468.992 ↓ 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=468.992..468.992 rows=140,901 loops=1)

  • Index Cond: (15658562 = store_id)