explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Utad

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

Limit (cost=1.44..1,056.22 rows=45 width=680) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.44..17,530,366.08 rows=747,890 width=680) (actual rows= loops=)

  • Join Filter: (teaser.id = teaser_network_relation.teaser_id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..16,479,539.91 rows=373,945 width=684) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan Backward using "idx-teaser-created_at" on teaser (cost=0.43..12,864,727.91 rows=40,000 width=680) (actual rows= loops=)

  • Filter: (to_tsvector((title)::text) @@ plainto_tsquery('P84wE'::text))
5. 0.000 0.000 ↓ 0.0

Index Only Scan using "idx-teaser_country_relation-teaser_id" on teaser_country_relation (cost=0.57..73.12 rows=1,725 width=4) (actual rows= loops=)

  • Index Cond: (teaser_id = teaser.id)
6. 0.000 0.000 ↓ 0.0

Index Only Scan using "idx-teaser_network_relation-teaser_id" on teaser_network_relation (cost=0.43..2.76 rows=4 width=4) (actual rows= loops=)

  • Index Cond: (teaser_id = teaser_country_relation.teaser_id)