explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ac7w

Settings
# exclusive inclusive rows x rows loops node
1. 312.272 377.256 ↓ 0.0 0 1

Update on spree_products (cost=331,198.05..394,434.80 rows=8,157 width=1,679) (actual time=377.256..377.256 rows=0 loops=1)

2. 51.442 64.984 ↑ 1.1 7,125 1

Bitmap Heap Scan on spree_products (cost=331,198.05..394,434.80 rows=8,157 width=1,679) (actual time=24.760..64.984 rows=7,125 loops=1)

  • Recheck Cond: (deleted_at IS NULL)
  • Filter: (1 = ANY (case_type_ids))
  • Rows Removed by Filter: 7,060
  • Heap Blocks: exact=48,844
3. 13.542 13.542 ↓ 11.3 185,499 1

Bitmap Index Scan on index_spree_products_on_deleted_at (cost=0.00..331,196.01 rows=16,463 width=0) (actual time=13.542..13.542 rows=185,499 loops=1)

  • Index Cond: (deleted_at IS NULL)
Planning time : 0.554 ms
Execution time : 377.495 ms