explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SiN

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

Limit (cost=9,738,346,403,374,892.00..9,738,354,121,012,350.00 rows=100 width=6) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=9,738,346,403,374,892.00..9,938,227,348,150,156.00 rows=2,589,924 width=6) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=9,738,346,403,374,892.00..9,788,316,639,560,614.00 rows=19,988,094,474,289,088 width=6) (actual rows= loops=)

  • Sort Key: newsletter_city_deals_registered.ncdr_status, users_joined_deals.ujd_user_id
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,355,527,821,483.53..227,449,840,749,272.47 rows=19,988,094,474,289,088 width=6) (actual rows= loops=)

  • Hash Cond: (users_joined_deals.ujd_city_deal_id = city_deals.cd_id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on users_joined_deals (cost=0.00..1,988,481.30 rows=56,768,557 width=8) (actual rows= loops=)

  • Filter: (ujd_join_status = ANY ('{1,3}'::integer[]))
6. 0.000 0.000 ↓ 0.0

Hash (cost=1,396,888,245,345.93..1,396,888,245,345.93 rows=58,431,364,640,768 width=6) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=13,072,112.42..1,396,888,245,345.93 rows=58,431,364,640,768 width=6) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on city_deals (cost=3,110.60..323,912.74 rows=165,952 width=4) (actual rows= loops=)

  • Recheck Cond: (cd_appdomain_id = 0)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_cd_appdomain_id (cost=0.00..3,069.11 rows=165,952 width=0) (actual rows= loops=)

  • Index Cond: (cd_appdomain_id = 0)
10. 0.000 0.000 ↓ 0.0

Materialize (cost=13,069,001.82..17,965,364.66 rows=352,097,984 width=2) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on newsletter_city_deals_registered (cost=0.00..11,341,520.84 rows=352,097,984 width=2) (actual rows= loops=)