explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CkPW

Settings
# exclusive inclusive rows x rows loops node
1. 19.272 259.446 ↑ 1.0 10 1

Limit (cost=36,799.68..36,799.71 rows=10 width=46) (actual time=240.174..259.446 rows=10 loops=1)

2. 0.000 240.174 ↑ 4.5 10 1

Sort (cost=36,799.68..36,799.80 rows=45 width=46) (actual time=240.173..240.174 rows=10 loops=1)

  • Sort Key: sub2.email
  • Sort Method: top-N heapsort Memory: 26kB
3. 27.906 242.417 ↓ 2,995.1 134,780 1

Gather (cost=1,207.87..36,798.71 rows=45 width=46) (actual time=10.607..242.417 rows=134,780 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
4. 191.350 214.511 ↓ 2,246.3 33,695 4

Nested Loop (cost=207.87..35,794.21 rows=15 width=46) (actual time=6.968..214.511 rows=33,695 loops=4)

5. 14.293 23.157 ↓ 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=6.902..23.157 rows=42,708 loops=4)

  • Recheck Cond: (subscriber_list_id = 15339)
  • Heap Blocks: exact=1962
6. 8.864 8.864 ↓ 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=8.863..8.864 rows=170,831 loops=1)

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

Index Scan using sub2_pkey on sub2 (cost=0.56..2.69 rows=1 width=27) (actual time=0.004..0.004 rows=1 loops=170,831)

  • Index Cond: (id = lists_subscribers.subscriber_id)
  • 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 AND (store_id = 4233))
  • Rows Removed by Filter: 0
Planning time : 0.337 ms
Execution time : 259.511 ms