explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ggtR

Settings
# exclusive inclusive rows x rows loops node
1. 1,728.470 1,728.482 ↑ 1.0 1 1

Insert on public.deal_batches d0 (cost=0.00..0.01 rows=1 width=156) (actual time=1,728.480..1,728.482 rows=1 loops=1)

  • Output: d0.id, d0.updated_at, d0.created_at, d0.balance, d0.bonus_bets_usd, d0.bonus_bets, d0.payouts_usd, d0.payouts, d0.deal_count, d0.closed_count, d0.canceled_count, d0.tie_count, d0.lost_count, d0.won_count, d0.close_rate, d0.close_quote_id, d0.bets_usd, d0.bets, d0.expire_at, d0.user_id, d0.asset_id
  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: index_deal_batches_on_asset_id_and_user_id_and_expire_at
  • Tuples Inserted: 0
  • Conflicting Tuples: 1
  • Buffers: shared hit=126
2. 0.012 0.012 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=156) (actual time=0.010..0.012 rows=1 loops=1)

  • Output: nextval('deal_batches_id_seq'::regclass), 282, 52153371, '2020-07-29 12:48:00'::timestamp without time zone, '1400000'::bigint, '96'::bigint, 1, 0, 0, 0, 0, '0'::bigint, '0'::bigint, NULL::bigint, NULL::numeric, '0'::bigint, '2020-07-29 12:47:10.791086'::timestamp without time zone, '2020-07
  • Buffers: shared hit=1