explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q95d

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 3.269 ↑ 8.5 6 1

Hash Join (cost=293.64..515.53 rows=51 width=68) (actual time=2.816..3.269 rows=6 loops=1)

  • Hash Cond: (o.id = oc.order_id)
2. 1.537 1.537 ↑ 68.0 6 1

Seq Scan on t_order o (cost=0.00..216.74 rows=408 width=40) (actual time=1.087..1.537 rows=6 loops=1)

  • Filter: ((retired_date IS NULL) AND (actionable_date IS NOT NULL) AND ((status)::text <> ALL ('{CLOSED,SENT,SAVED,AM_REVIEW,EDI_PENDING,NEEDS_ATTENTION}'::text[])))
  • Rows Removed by Filter: 3256
3. 0.006 1.717 ↑ 68.0 6 1

Hash (cost=288.54..288.54 rows=408 width=8) (actual time=1.717..1.717 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.004 1.711 ↑ 68.0 6 1

Subquery Scan on oc (cost=280.38..288.54 rows=408 width=8) (actual time=1.705..1.711 rows=6 loops=1)

5. 0.010 1.707 ↑ 68.0 6 1

HashAggregate (cost=280.38..284.46 rows=408 width=16) (actual time=1.704..1.707 rows=6 loops=1)

  • Group Key: o_1.id
  • Filter: (sum(CASE WHEN (oc_1.id IS NULL) THEN 0 ELSE 1 END) < 1)
6. 0.017 1.697 ↑ 68.0 6 1

Hash Left Join (cost=60.07..278.34 rows=408 width=16) (actual time=1.165..1.697 rows=6 loops=1)

  • Hash Cond: (o_1.id = oc_1.order_id)
7. 1.440 1.440 ↑ 68.0 6 1

Seq Scan on t_order o_1 (cost=0.00..216.74 rows=408 width=8) (actual time=0.911..1.440 rows=6 loops=1)

  • Filter: ((retired_date IS NULL) AND (actionable_date IS NOT NULL) AND ((status)::text <> ALL ('{CLOSED,SENT,SAVED,AM_REVIEW,EDI_PENDING,NEEDS_ATTENTION}'::text[])))
  • Rows Removed by Filter: 3256
8. 0.000 0.240 ↓ 0.0 0 1

Hash (cost=60.05..60.05 rows=1 width=16) (actual time=0.240..0.240 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.240 0.240 ↓ 0.0 0 1

Seq Scan on t_orderconcern oc_1 (cost=0.00..60.05 rows=1 width=16) (actual time=0.240..0.240 rows=0 loops=1)

  • Filter: (active AND ((assigned_role)::text = 'ROLE_ACCOUNT_MANAGER'::text) AND ((concern_type)::text = ANY ('{STRING,UNCLEAR_IMAGE,MISSING_INVOICE_PAGE}'::text[])))
  • Rows Removed by Filter: 1242