explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1mmI

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.355 ↑ 7.5 6 1

Hash Join (cost=259.21..430.81 rows=45 width=68) (actual time=0.344..0.355 rows=6 loops=1)

  • Hash Cond: (o.id = oc.order_id)
2. 0.014 0.044 ↑ 64.2 6 1

Bitmap Heap Scan on t_order o (cost=8.26..175.00 rows=385 width=40) (actual time=0.036..0.044 rows=6 loops=1)

  • Recheck Cond: ((retired_date IS NULL) AND (actionable_date IS NOT NULL) AND ((status)::text <> ALL ('{CLOSED,SENT,SAVED,AM_REVIEW,EDI_PENDING,NEEDS_ATTENTION}'::text[])))
  • Heap Blocks: exact=6
3. 0.030 0.030 ↑ 64.2 6 1

Bitmap Index Scan on idx_priority_report_1 (cost=0.00..8.16 rows=385 width=0) (actual time=0.030..0.030 rows=6 loops=1)

4. 0.007 0.296 ↑ 64.2 6 1

Hash (cost=246.14..246.14 rows=385 width=8) (actual time=0.296..0.296 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.003 0.289 ↑ 64.2 6 1

Subquery Scan on oc (cost=238.44..246.14 rows=385 width=8) (actual time=0.283..0.289 rows=6 loops=1)

6. 0.011 0.286 ↑ 64.2 6 1

HashAggregate (cost=238.44..242.29 rows=385 width=16) (actual time=0.283..0.286 rows=6 loops=1)

  • Group Key: o_1.id
  • Filter: (sum(CASE WHEN (oc_1.id IS NULL) THEN 0 ELSE 1 END) < 1)
7. 0.014 0.275 ↑ 64.2 6 1

Hash Left Join (cost=68.32..236.51 rows=385 width=16) (actual time=0.264..0.275 rows=6 loops=1)

  • Hash Cond: (o_1.id = oc_1.order_id)
8. 0.010 0.016 ↑ 64.2 6 1

Bitmap Heap Scan on t_order o_1 (cost=8.26..175.00 rows=385 width=8) (actual time=0.008..0.016 rows=6 loops=1)

  • Recheck Cond: ((retired_date IS NULL) AND (actionable_date IS NOT NULL) AND ((status)::text <> ALL ('{CLOSED,SENT,SAVED,AM_REVIEW,EDI_PENDING,NEEDS_ATTENTION}'::text[])))
  • Heap Blocks: exact=6
9. 0.006 0.006 ↑ 64.2 6 1

Bitmap Index Scan on idx_priority_report_1 (cost=0.00..8.16 rows=385 width=0) (actual time=0.006..0.006 rows=6 loops=1)

10. 0.001 0.245 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
11. 0.244 0.244 ↓ 0.0 0 1

Seq Scan on t_orderconcern oc_1 (cost=0.00..60.05 rows=1 width=16) (actual time=0.244..0.244 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