explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YXNdc

Settings
# exclusive inclusive rows x rows loops node
1. 216.028 6,622.533 ↓ 2.7 264,499 1

Sort (cost=79,622.37..79,869.18 rows=98,721 width=39) (actual time=6,544.868..6,622.533 rows=264,499 loops=1)

  • Sort Key: (sum(review_count)) DESC NULLS LAST
  • Sort Method: external merge Disk: 13,784kB
2. 491.707 6,406.505 ↓ 2.7 264,499 1

HashAggregate (cost=70,445.73..71,432.94 rows=98,721 width=39) (actual time=6,291.924..6,406.505 rows=264,499 loops=1)

  • Group Key: product
3. 5,914.798 5,914.798 ↓ 1.0 634,204 1

Seq Scan on popular_product_129 (cost=0.00..67,356.93 rows=617,761 width=35) (actual time=2,169.537..5,914.798 rows=634,204 loops=1)

  • Filter: (is_enabled AND (country = 'US'::text))
  • Rows Removed by Filter: 75,522