explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E7Ti

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=860,764.27..860,764.28 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=41,990.50..859,949.56 rows=325,884 width=65) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=40,990.50..826,361.16 rows=135,785 width=65) (actual rows= loops=)

  • Hash Cond: (c1.cart_id = c.id)
4. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on cart_locations c1 (cost=30,510.54..811,756.94 rows=141,051 width=69) (actual rows= loops=)

  • Recheck Cond: ((added_by_user_id = '7af3310e891ab0b28e08c06da7275818112a2a2e301acb043d13072f32df9ae8'::text) AND (added_by_user_source = 'core'::user_source_id) AND (NOT soft_delete))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on cart_locations_by_add_user (cost=0.00..30,425.91 rows=338,522 width=0) (actual rows= loops=)

  • Index Cond: ((added_by_user_id = '7af3310e891ab0b28e08c06da7275818112a2a2e301acb043d13072f32df9ae8'::text) AND (added_by_user_source = 'core'::user_source_id))
6. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=8,601.09..8,601.09 rows=114,470 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on carts c (cost=0.00..8,601.09 rows=114,470 width=4) (actual rows= loops=)

  • Filter: (NOT soft_delete)