explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZZBuI

Settings
# exclusive inclusive rows x rows loops node
1. 0.095 0.200 ↑ 1.0 10 1

Limit (cost=0.42..130.92 rows=10 width=209) (actual time=0.070..0.200 rows=10 loops=1)

  • Output: transaction_id, platform, user_id, (CASE WHEN (lock_ts >= '2019-05-10 21:17:50.885686'::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=11 read=2
2. 0.105 0.105 ↑ 51.1 10 1

Index Scan using unfulfilled_transaction on public.transaction (cost=0.42..6,669.06 rows=511 width=209) (actual time=0.065..0.105 rows=10 loops=1)

  • Output: transaction_id, platform, user_id, CASE WHEN (lock_ts >= '2019-05-10 21:17:50.885686'::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 > '2019-05-10 23:45:18.798869'::timestamp without time zone)
  • Filter: ((transaction.user_id = COALESCE(transaction.user_id)) AND (transaction.status = 'pending'::rv_status) AND (transaction.game = 'test'::text))
  • Buffers: shared hit=11 read=2