explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WVVl

Settings
# exclusive inclusive rows x rows loops node
1. 0.101 124.623 ↑ 5.0 1 1

GroupAggregate (cost=0.00..11,040.51 rows=5 width=113) (actual time=124.623..124.623 rows=1 loops=1)

  • Group Key: deals.asset_name
  • Buffers: shared hit=6285
2. 124.522 124.522 ↓ 7.8 47 1

Seq Scan on deals (cost=0.00..11,040.22 rows=6 width=17) (actual time=124.466..124.522 rows=47 loops=1)

  • Filter: ((status <> 'CANCELED'::eds.status) AND (revenue <> 0) AND (amount >= 10000) AND ((asset_name)::text = 'EUR / USD'::text) AND (closed_at >= (now() - '01:40:00'::interval)))
  • Rows Removed by Filter: 172499
  • Buffers: shared hit=6285