explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IcVT

Settings
# exclusive inclusive rows x rows loops node
1. 0.324 599.996 ↑ 1.0 1 1

Gather (cost=1,000.00..14,098.06 rows=1 width=129) (actual time=599.917..599.996 rows=1 loops=1)

  • Output: id, code, created, order_item_id, user_id, first_clicked_at, last_clicked_at, is_valid, delivery_email
  • Workers Planned: 2
  • Workers Launched: 0
  • Buffers: shared hit=9,833
2. 599.672 599.672 ↑ 1.0 1 1

Parallel Seq Scan on public.order_item_token (cost=0.00..13,097.96 rows=1 width=129) (actual time=599.655..599.672 rows=1 loops=1)

  • Output: id, code, created, order_item_id, user_id, first_clicked_at, last_clicked_at, is_valid, delivery_email
  • Filter: (721967 = order_item_token.order_item_id)
  • Rows Removed by Filter: 615,412
  • Buffers: shared hit=9,833