explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T1DX

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 0.113 ↑ 1.0 1 1

Limit (cost=0.25..2.48 rows=1 width=209) (actual time=0.055..0.113 rows=1 loops=1)

  • Output: transaction_id, platform, user_id, (CASE WHEN (lock_ts >= '2019-05-13 18:11:43.600934'::timestamp without time zone) THEN 'locked'::text ELSE (status)::text END), item, quantity, pending_ts, pending_ts, transaction_id, platform, NULL::timestamp without time zone, NULL::text, NULL::platform
  • Buffers: shared hit=7
2. 0.055 0.055 ↑ 1.0 1 1

Index Scan using unfulfilled_transaction on public.transaction (cost=0.25..2.48 rows=1 width=209) (actual time=0.053..0.055 rows=1 loops=1)

  • Output: transaction_id, platform, user_id, CASE WHEN (lock_ts >= '2019-05-13 18:11:43.600934'::timestamp without time zone) THEN 'locked'::text ELSE (status)::text END, item, quantity, pending_ts, pending_ts, transaction_id, platform, NULL::timestamp without time zone, NULL::text, NULL::platform
  • Index Cond: ((transaction.pending_ts > '-infinity'::timestamp without time zone) AND (transaction.user_id = 'f9d4be9a154e56f658cc7fbcce7399e0'::text))
  • Filter: ((transaction.status = 'pending'::rv_status) AND (transaction.game = 'test'::text))
  • Buffers: shared hit=7