explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d0s8

Settings

Optimization(s) for this plan:

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

Limit (cost=1,000.89..698,756.30 rows=10 width=77) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,000.89..115,951,391,626.28 rows=1,661,777 width=77) (actual rows= loops=)

  • Group Key: sds.uuid
3. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,000.89..115,951,297,278.64 rows=3,055,605 width=576) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.86..115,950,943,585.98 rows=1,273,169 width=576) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..115,949,969,102.39 rows=1,273,169 width=576) (actual rows= loops=)

  • Join Filter: ((ar.created < sds.created) AND ((ar.transport)::text = (sds.phone_number)::text))
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..4,481,273,753.68 rows=692,407 width=169) (actual rows= loops=)

  • Join Filter: ((af.created < sds.created) AND ((af.transport)::text = (sds.phone_number)::text))
7. 0.000 0.000 ↓ 0.0

Parallel Index Scan using sms_delivery_stats_pkey on sms_delivery_stats sds (cost=0.43..147,207.01 rows=692,407 width=37) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on auth_factors af (cost=0.00..4,555.53 rows=127,752 width=145) (actual rows= loops=)

  • Filter: verified
9. 0.000 0.000 ↓ 0.0

Seq Scan on access_rights ar (cost=0.00..130,635.57 rows=2,023,445 width=419) (actual rows= loops=)

  • Filter: passed
10. 0.000 0.000 ↓ 0.0

Index Scan using pk_shares on shares s (cost=0.43..0.77 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = ar.share_id)