explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XVUy

Settings
# exclusive inclusive rows x rows loops node
1. 0.428 131,144.401 ↑ 338.0 1 1

GroupAggregate (cost=10,509,041.14..10,509,062.27 rows=338 width=36) (actual time=131,144.401..131,144.401 rows=1 loops=1)

  • Group Key: ((receive_ts)::date)
2. 0.223 131,143.973 ↓ 1.1 385 1

Sort (cost=10,509,041.14..10,509,041.99 rows=338 width=20) (actual time=131,143.947..131,143.973 rows=385 loops=1)

  • Sort Key: ((receive_ts)::date)
  • Sort Method: quicksort Memory: 55kB
3. 131,143.750 131,143.750 ↓ 1.1 385 1

Seq Scan on sma_messages (cost=0.00..10,509,026.95 rows=338 width=20) (actual time=17,153.560..131,143.750 rows=385 loops=1)

  • Filter: (((service_request_name)::text = 'ESIAFindAccountRequest'::text) AND (receive_ts >= (now() - '00:10:00'::interval)))
  • Rows Removed by Filter: 75970644