explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iEev

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

Limit (cost=0.57..15.75 rows=1 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=0.57..872,505,615.49 rows=57,498,891 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on adwords_ad_group_ad a (cost=0.00..40,379,527.68 rows=340,667,968 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Only Scan using adwords_ad_test on adwords_ad_group_ad_relation r (cost=0.57..2.43 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((id = a.id) AND (parent_id = a.ad_group_id))