explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Gnx

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 269.467 ↑ 1.0 10 1

Limit (cost=36,794.63..36,795.81 rows=10 width=46) (actual time=247.149..269.467 rows=10 loops=1)

2. 0.000 269.448 ↑ 5.4 10 1

Gather Merge (cost=36,794.63..36,801.02 rows=54 width=46) (actual time=247.147..269.448 rows=10 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 28.580 972.124 ↑ 2.2 8 4

Sort (cost=35,794.59..35,794.63 rows=18 width=46) (actual time=243.030..243.031 rows=8 loops=4)

  • Sort Key: subscribers.email
  • Sort Method: top-N heapsort Memory: 25kB
  • Worker 0: Sort Method: top-N heapsort Memory: 26kB
  • Worker 1: Sort Method: top-N heapsort Memory: 26kB
  • Worker 2: Sort Method: top-N heapsort Memory: 26kB
4. 8.105 943.544 ↓ 1,871.9 33,695 4

Nested Loop (cost=207.87..35,794.21 rows=18 width=46) (actual time=7.324..235.886 rows=33,695 loops=4)

5. 72.254 81.284 ↓ 7.2 42,708 4

Parallel Bitmap Heap Scan on lists_subscribers (cost=207.30..19,890.97 rows=5,904 width=4) (actual time=7.235..20.321 rows=42,708 loops=4)

  • Recheck Cond: (subscriber_list_id = 15339)
  • Heap Blocks: exact=2254
6. 9.030 9.030 ↓ 9.3 170,831 1

Bitmap Index Scan on index_lists_subscribers_on_subscriber_list_id_and_subscriber_id (cost=0.00..202.72 rows=18,301 width=0) (actual time=9.029..9.030 rows=170,831 loops=1)

  • Index Cond: (subscriber_list_id = 15339)
7. 854.155 854.155 ↑ 1.0 1 170,831

Index Scan using index_subscribers_on_id_and_store_id on subscribers (cost=0.56..2.69 rows=1 width=27) (actual time=0.005..0.005 rows=1 loops=170,831)

  • Index Cond: ((id = lists_subscribers.subscriber_id) AND (store_id = 4233))
  • Filter: (((NOT hidden) OR (hidden IS NULL)) AND subscribed AND (deleted_at IS NULL) AND (unsubscribed_at IS NULL) AND (bounced_at IS NULL) AND (complained_at IS NULL) AND (dropped_at IS NULL) AND ((NOT hidden) OR (hidden IS NULL)) AND mg_valid)
  • Rows Removed by Filter: 0
Planning time : 0.440 ms
Execution time : 269.536 ms