explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SZIJ

Settings
# exclusive inclusive rows x rows loops node
1. 11.277 19.752 ↓ 2.6 8,351 1

Hash Join (cost=47.69..3,068.87 rows=3,170 width=4) (actual time=0.886..19.752 rows=8,351 loops=1)

  • Hash Cond: (pp.createdbyuserid = u.id)
2. 7.604 7.604 ↑ 1.0 90,471 1

Seq Scan on projectpreparation pp (cost=0.00..2,645.98 rows=91,598 width=8) (actual time=0.005..7.604 rows=90,471 loops=1)

3. 0.098 0.871 ↑ 1.1 915 1

Hash (cost=35.11..35.11 rows=1,006 width=4) (actual time=0.871..0.871 rows=915 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
4. 0.248 0.773 ↑ 1.1 915 1

Nested Loop (cost=5.45..35.11 rows=1,006 width=4) (actual time=0.049..0.773 rows=915 loops=1)

  • Join Filter: (o.id = u.organisationid)
5. 0.003 0.060 ↑ 1.0 5 1

Nested Loop (cost=5.17..31.75 rows=5 width=8) (actual time=0.034..0.060 rows=5 loops=1)

6. 0.006 0.042 ↑ 1.0 5 1

Nested Loop (cost=4.88..30.22 rows=5 width=4) (actual time=0.025..0.042 rows=5 loops=1)

7. 0.003 0.021 ↑ 1.0 5 1

Nested Loop (cost=4.60..24.59 rows=5 width=4) (actual time=0.017..0.021 rows=5 loops=1)

8. 0.005 0.005 ↑ 1.0 1 1

Index Scan using ix_singleusergroupresolving_userunique on singleusergroupresolving sg (cost=0.28..8.30 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (userid = 11729)
9. 0.007 0.013 ↓ 1.2 5 1

Bitmap Heap Scan on singleusergroupresolving m (cost=4.31..16.25 rows=4 width=8) (actual time=0.010..0.013 rows=5 loops=1)

  • Recheck Cond: (groupid = sg.groupid)
  • Heap Blocks: exact=3
10. 0.006 0.006 ↓ 1.2 5 1

Bitmap Index Scan on group_id_user_id_unique (cost=0.00..4.31 rows=4 width=0) (actual time=0.006..0.006 rows=5 loops=1)

  • Index Cond: (groupid = sg.groupid)
11. 0.015 0.015 ↑ 1.0 1 5

Index Scan using pk_user on "user" u_1 (cost=0.29..1.13 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=5)

  • Index Cond: (id = m.userid)
12. 0.015 0.015 ↑ 1.0 1 5

Index Only Scan using ix_organisation_id_emailenabled on organisation o (cost=0.28..0.31 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=5)

  • Index Cond: (id = u_1.organisationid)
  • Heap Fetches: 0
13. 0.465 0.465 ↓ 26.1 183 5

Index Scan using ix_user_organisationid on "user" u (cost=0.29..0.59 rows=7 width=8) (actual time=0.006..0.093 rows=183 loops=5)

  • Index Cond: (organisationid = u_1.organisationid)
Planning time : 1.255 ms