explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uPde

Settings
# exclusive inclusive rows x rows loops node
1. 0.057 354.465 ↓ 7.0 7 1

GroupAggregate (cost=11,300.19..11,300.22 rows=1 width=32) (actual time=354.402..354.465 rows=7 loops=1)

  • Group Key: a.object_id
2. 0.066 354.408 ↓ 284.0 284 1

Sort (cost=11,300.19..11,300.20 rows=1 width=6) (actual time=354.386..354.408 rows=284 loops=1)

  • Sort Key: a.object_id
  • Sort Method: quicksort Memory: 38kB
3. 42.576 354.342 ↓ 284.0 284 1

Gather (cost=1,000.56..11,300.18 rows=1 width=6) (actual time=6.708..354.342 rows=284 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.101 311.766 ↓ 142.0 142 2 / 2

Nested Loop (cost=0.56..10,300.08 rows=1 width=6) (actual time=3.409..311.766 rows=142 loops=2)

5. 5.347 5.347 ↑ 3.0 6 2 / 2

Parallel Seq Scan on hub_auto_messages b (cost=0.00..1,526.25 rows=18 width=4) (actual time=2.827..5.347 rows=6 loops=2)

  • Filter: ((hub_id = 271) OR is_default)
  • Rows Removed by Filter: 3688
6. 306.318 306.318 ↓ 24.0 24 12 / 2

Index Scan using email_history_object_id_idx on email_history a (cost=0.56..487.43 rows=1 width=6) (actual time=9.579..51.053 rows=24 loops=12)

  • Index Cond: ((object_type = 'HubAutoMessage'::text) AND (object_id = b.id))
  • Filter: (hub_id = 271)
  • Rows Removed by Filter: 19206
Planning time : 1.512 ms
Execution time : 354.779 ms