explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nq6s

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=63,395.28..63,403.51 rows=16,460 width=524) (actual rows= loops=)

  • (actual time=524.134..562.635 rows=65294 loops=1)
  • Sort Key: start_date
  • Sort Method: external merge Disk: 36224kB
  • -> Bitmap Heap Scan on products
  • (cost=4803.40..60389.73 rows=16460 width=524)
  • (actual time=27.390..397.879 rows=65294 loops=1)
  • Recheck Cond: (status > 100)
  • Filter: (above_revenue_average AND (category_id <> 5))
  • Rows Removed by Filter: 25115
  • -> Bitmap Index Scan on index_products_on_status
  • (cost=0.00..4802.58 rows=89662 width=0)
  • (actual time=18.006..18.006 rows=90411 loops=1)
  • Index Cond: (status > 100)