explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LNAq

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

Gather (cost=128,109.37..667,894.25 rows=14 width=119) (actual rows= loops=)

  • Workers Planned: 4
2. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=127,109.37..666,892.85 rows=4 width=119) (actual rows= loops=)

  • Hash Cond: (tweet.user_id = "user".id)
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on tweet (cost=0.00..537,093.92 rows=1,024,592 width=127) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=127,109.34..127,109.34 rows=2 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "user" (cost=0.00..127,109.34 rows=2 width=8) (actual rows= loops=)

  • Filter: (name = '\u0000'::text)