explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bvhw

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

Gather (cost=1,003.79..94,565.65 rows=4,036 width=1,546) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.79..93,162.05 rows=1,682 width=1,546) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.37..89,220.48 rows=1,682 width=1,337) (actual rows= loops=)

  • Hash Cond: (_di.profession_title = ds_extension_285.profession)
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on ds_internal_116 _di (cost=0.00..89,191.88 rows=2,243 width=389) (actual rows= loops=)

  • Filter: ((email_status <> 'INVALID'::text) AND (daily_headlines_unsub ~~* 'n'::text) AND (profession_title ~~* 'Agent'::text) AND (daily_headlines_unsub = 'N'::text))
5. 0.000 0.000 ↓ 0.0

Hash (cost=3.33..3.33 rows=3 width=948) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on ds_extension_285 (cost=0.00..3.33 rows=3 width=948) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using ds_extension_118_pk on ds_extension_118 (cost=0.43..2.34 rows=1 width=209) (actual rows= loops=)

  • Index Cond: (user_id = _di.user_id)