explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7FrN

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

Gather Motion 8:1 (slice2; segments: 8) (cost=934.32..25,816.90 rows=426 width=30) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=934.32..25,816.90 rows=54 width=30) (actual rows= loops=)

  • Join Filter: i.domain ~ tld.pattern::text
3. 0.000 0.000 ↓ 0.0

Seq Scan on firmographic_info i (cost=0.00..23,352.04 rows=1 width=16) (actual rows= loops=)

  • Filter: id >= 1 AND id <= 100
4. 0.000 0.000 ↓ 0.0

Materialize (cost=934.32..1,614.56 rows=8,503 width=46) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Broadcast Motion 8:8 (slice1; segments: 8) (cost=0.00..866.30 rows=8,503 width=46) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on tld (cost=0.00..101.03 rows=1,063 width=46) (actual rows= loops=)