explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JujN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on public.stats (cost=0.00..0.03 rows=1 width=36) (actual rows= loops=)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: stats_token_id_date_unique
  • Conflict Filter: ((stats.token_id = 113) AND (stats.date = '2019-04-09'::date))
2. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.03 rows=1 width=36) (actual rows= loops=)

  • Output: nextval('stats_id_seq'::regclass), 113, 1, now(), CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 10