explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qhq : Optimization for: Optimization for: plan #dJg1; plan #zqW

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.007 0.043 ↓ 7.0 7 1

GroupAggregate (cost=1.66..1.69 rows=1 width=24) (actual time=0.039..0.043 rows=7 loops=1)

  • Output: (date_part('month'::text, ((inserted_at)::date)::timestamp without time zone)), (date_part('day'::text, ((inserted_at)::date)::timestamp without time zone)), count(inserted_at)
  • Group Key: (date_part('month'::text, ((up.inserted_at)::date)::timestamp without time zone)), (date_part('day'::text, ((up.inserted_at)::date)::timestamp without time zone))
2. 0.010 0.036 ↓ 28.0 28 1

Sort (cost=1.66..1.66 rows=1 width=24) (actual time=0.035..0.036 rows=28 loops=1)

  • Output: (date_part('month'::text, ((inserted_at)::date)::timestamp without time zone)), (date_part('day'::text, ((inserted_at)::date)::timestamp without time zone)), inserted_at
  • Sort Key: (date_part('month'::text, ((up.inserted_at)::date)::timestamp without time zone)), (date_part('day'::text, ((up.inserted_at)::date)::timestamp without time zone))
  • Sort Method: quicksort Memory: 27kB
3. 0.026 0.026 ↓ 28.0 28 1

Seq Scan on public.user_passphrases up (cost=0.00..1.65 rows=1 width=24) (actual time=0.010..0.026 rows=28 loops=1)

  • Output: date_part('month'::text, ((inserted_at)::date)::timestamp without time zone), date_part('day'::text, ((inserted_at)::date)::timestamp without time zone), inserted_at
  • Filter: (((up.inserted_at)::date <= now()) AND ((up.inserted_at)::date >= (now() - '7 days'::interval)))
  • Rows Removed by Filter: 2
Planning time : 0.107 ms
Execution time : 0.062 ms