#	exclusive	inclusive	rows x	rows	loops	node
1.	272.812	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.	454.379	1,100.674	↓ 10.8	87,314	3 / 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: 76,880kB
3.	623.017	646.295	↓ 10.8	87,314	3 / 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: 124,216 Heap Blocks: exact=8,940 lossy=62,877
4.	0.001	23.278	↓ 0.0	0	1 / 3	→ BitmapOr (cost=1,672.67..1,672.67 rows=19,610 width=0) (actual time=69.834..69.834 rows=0 loops=1)
5.	13.902	13.902	↓ 13.6	130,971	1 / 3	→ 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.023	0.023	↓ 0.0	0	1 / 3	→ 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.	9.353	9.353	↓ 13.7	130,971	1 / 3	→ 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

Gather Merge  (cost=82554.94..84437.37 rows=16134 width=1159) (actual time=1148.177..1373.486 rows=261942 loops=1)
  Workers Planned: 2
  Workers Launched: 2
  ->  Sort  (cost=81554.91..81575.08 rows=8067 width=1159) (actual time=1060.065..1100.674 rows=87314 loops=3)
        Sort Key: number
        Sort Method: external merge  Disk: 76880kB
        ->  Parallel Bitmap Heap Scan on events  (cost=1672.67..76950.45 rows=8067 width=1159) (actual time=73.674..646.295 rows=87314 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
              ->  BitmapOr  (cost=1672.67..1672.67 rows=19610 width=0) (actual time=69.834..69.834 rows=0 loops=1)
                    ->  Bitmap Index Scan on events_producer_type_type_index  (cost=0.00..813.00 rows=9632 width=0) (actual time=41.706..41.706 rows=130971 loops=1)
                          Index Cond: (((producer_type)::text = 'Accounting\Application\Saga\SwiftNetworkSaga\Id'::text) AND ((type)::text = 'Streak\Domain\Event\Sourced\Subscription\Event\SubscriptionStarted'::text))
                    ->  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))
                    ->  Bitmap Index Scan on events_producer_type_type_index  (cost=0.00..808.53 rows=9585 width=0) (actual time=28.058..28.058 rows=130971 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: 1397.658 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Index Scan	3	23.277 ms	1.7 %
BitmapOr	1	0.001 ms	0.0 %
Gather Merge	1	272.812 ms	19.9 %
Parallel Bitmap Heap Scan	1	623.017 ms	45.4 %
Sort	1	454.379 ms	33.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
events	1	623.017 ms	45.4 %
Parallel Bitmap Heap Scan	1	623.017 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XAvm

Color mode:

Visible columns:

Per node type stats

Per table stats