explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O7vp

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.040 ↑ 1.0 2 1

Append (cost=1.32..2.72 rows=2 width=8) (actual time=0.026..0.040 rows=2 loops=1)

2. 0.002 0.026 ↑ 1.0 1 1

Aggregate (cost=1.32..1.33 rows=1 width=8) (actual time=0.026..0.026 rows=1 loops=1)

3. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on users (cost=0.00..1.32 rows=1 width=0) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: (date(created_at) = ('now'::cstring)::date)
  • Rows Removed by Filter: 16
4. 0.001 0.013 ↑ 1.0 1 1

Aggregate (cost=1.36..1.37 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

5. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on users users_1 (cost=0.00..1.36 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (date(created_at) = (('now'::cstring)::date - 1))
  • Rows Removed by Filter: 16