explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XAvm

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,373.486 ↓ 16.2 261,942 1

Gather Merge (cost=82,554.94..84,437.37 rows=16,134 width=1,159) (actual time=1,148.177..1,373.486 rows=261,942 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,363.137 3,302.022 ↓ 10.8 87,314 3

Sort (cost=81,554.91..81,575.08 rows=8,067 width=1,159) (actual time=1,060.065..1,100.674 rows=87,314 loops=3)

  • Sort Key: number
  • Sort Method: external merge Disk: 76880kB
3. 1,869.051 1,938.885 ↓ 10.8 87,314 3

Parallel Bitmap Heap Scan on events (cost=1,672.67..76,950.45 rows=8,067 width=1,159) (actual time=73.674..646.295 rows=87,314 loops=3)

  • Recheck Cond: ((((producer_type)::text = 'Accounting\Application\Saga\SwiftNetworkSaga\Id'::text) AND ((type)::text = 'Streak\Domain\Event\Sourced\Subscription\Event\SubscriptionStarted'::text)) OR (((producer_type)::text = 'Accounting\Application\Saga\SwiftNetworkSaga\Id'::text) AND ((type)::text = 'Streak\Domain\Event\Sourced\Subscription\Event\SubscriptionRestarted'::text)) OR (((producer_type)::text = 'Accounting\Application\Saga\SwiftNetworkSaga\Id'::text) AND ((type)::text = 'Streak\Domain\Event\Sourced\Subscription\Event\SubscriptionCompleted'::text)))
  • Rows Removed by Index Recheck: 124216
  • Heap Blocks: exact=8940 lossy=62877
4. 0.002 69.834 ↓ 0.0 0 1

BitmapOr (cost=1,672.67..1,672.67 rows=19,610 width=0) (actual time=69.834..69.834 rows=0 loops=1)

5. 41.706 41.706 ↓ 13.6 130,971 1

Bitmap Index Scan on events_producer_type_type_index (cost=0.00..813.00 rows=9,632 width=0) (actual time=41.706..41.706 rows=130,971 loops=1)

  • Index Cond: (((producer_type)::text = 'Accounting\Application\Saga\SwiftNetworkSaga\Id'::text) AND ((type)::text = 'Streak\Domain\Event\Sourced\Subscription\Event\SubscriptionStarted'::text))
6. 0.068 0.068 ↓ 0.0 0 1

Bitmap Index Scan on events_producer_type_type_index (cost=0.00..36.61 rows=393 width=0) (actual time=0.068..0.068 rows=0 loops=1)

  • Index Cond: (((producer_type)::text = 'Accounting\Application\Saga\SwiftNetworkSaga\Id'::text) AND ((type)::text = 'Streak\Domain\Event\Sourced\Subscription\Event\SubscriptionRestarted'::text))
7. 28.058 28.058 ↓ 13.7 130,971 1

Bitmap Index Scan on events_producer_type_type_index (cost=0.00..808.53 rows=9,585 width=0) (actual time=28.058..28.058 rows=130,971 loops=1)

  • Index Cond: (((producer_type)::text = 'Accounting\Application\Saga\SwiftNetworkSaga\Id'::text) AND ((type)::text = 'Streak\Domain\Event\Sourced\Subscription\Event\SubscriptionCompleted'::text))
Planning time : 0.164 ms
Execution time : 1,397.658 ms