explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eidu

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 71,808.728 ↑ 1.8 56 1

Sort (cost=1,791,024.02..1,791,024.28 rows=103 width=54) (actual time=71,808.717..71,808.728 rows=56 loops=1)

  • Sort Key: (avg(elapsed)) DESC
  • Sort Method: quicksort Memory: 29kB
2. 20.807 71,808.662 ↑ 1.8 56 1

GroupAggregate (cost=1,790,154.74..1,791,020.58 rows=103 width=54) (actual time=71,779.767..71,808.662 rows=56 loops=1)

  • Group Key: route
3. 50.648 71,787.855 ↑ 1.3 68,888 1

Sort (cost=1,790,154.74..1,790,370.88 rows=86,455 width=18) (actual time=71,773.957..71,787.855 rows=68,888 loops=1)

  • Sort Key: route
  • Sort Method: quicksort Memory: 7297kB
4. 71,737.207 71,737.207 ↑ 1.3 68,888 1

Seq Scan on http_requests (cost=0.00..1,783,065.58 rows=86,455 width=18) (actual time=26,490.453..71,737.207 rows=68,888 loops=1)

  • Filter: ((method = 'GET'::text) AND ((created_at)::date = ((now() - '30 days'::interval))::date))
  • Rows Removed by Filter: 20678663