explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fYaH

Settings
# exclusive inclusive rows x rows loops node
1. 0.142 0.194 ↑ 1.0 10 1

Limit (cost=0.42..11.94 rows=10 width=209) (actual time=0.033..0.194 rows=10 loops=1)

  • Output: transaction_id, platform, user_id, (CASE WHEN (lock_ts >= '2019-05-10 20:10:26.800495'::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=6
2. 0.052 0.052 ↑ 4.9 10 1

Index Scan using unfulfilled on public.transaction (cost=0.42..56.87 rows=49 width=209) (actual time=0.029..0.052 rows=10 loops=1)

  • Output: transaction_id, platform, user_id, CASE WHEN (lock_ts >= '2019-05-10 20:10:26.800495'::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.user_id = 'fc7a353b4b3c88081a8e0913f26d3971'::text) AND (transaction.pending_ts > '-infinity'::timestamp without time zone))
  • Filter: (transaction.game = 'test'::text)
  • Buffers: shared hit=6