explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1gV2 : asdfghjkl

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.025 ↑ 1.0 4 1

Nested Loop (cost=0.00..3.17 rows=4 width=8) (actual time=0.022..0.025 rows=4 loops=1)

2. 0.002 0.018 ↑ 1.0 2 1

Nested Loop (cost=0.00..2.09 rows=2 width=0) (actual time=0.017..0.018 rows=2 loops=1)

  • Join Filter: (team.team_id = teammembers.team_id)
3. 0.006 0.006 ↑ 1.0 2 1

Seq Scan on teammembers (cost=0.00..1.02 rows=2 width=4) (actual time=0.005..0.006 rows=2 loops=1)

4. 0.007 0.010 ↑ 2.0 1 2

Materialize (cost=0.00..1.03 rows=2 width=4) (actual time=0.005..0.005 rows=1 loops=2)

5. 0.003 0.003 ↑ 2.0 1 1

Seq Scan on team (cost=0.00..1.02 rows=2 width=4) (actual time=0.003..0.003 rows=1 loops=1)

6. 0.004 0.006 ↑ 1.0 2 2

Materialize (cost=0.00..1.03 rows=2 width=8) (actual time=0.003..0.003 rows=2 loops=2)

7. 0.002 0.002 ↑ 1.0 2 1

Seq Scan on salary (cost=0.00..1.02 rows=2 width=8) (actual time=0.001..0.002 rows=2 loops=1)