explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kqvu

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

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

2. 0.001 0.024 ↑ 1.0 1 1

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

3. 0.023 0.023 ↓ 0.0 0 1

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

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

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

5. 0.014 0.014 ↓ 0.0 0 1

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

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