explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cFUL

Settings
# exclusive inclusive rows x rows loops node
1. 11.037 22.211 ↓ 71.4 8,351 1

Hash Join (cost=41.17..3,031.81 rows=117 width=4) (actual time=1.858..22.211 rows=8,351 loops=1)

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

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

3. 0.146 1.829 ↓ 24.7 915 1

Hash (cost=40.70..40.70 rows=37 width=4) (actual time=1.829..1.829 rows=915 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
4. 0.113 1.683 ↓ 24.7 915 1

Nested Loop (cost=32.05..40.70 rows=37 width=4) (actual time=0.316..1.683 rows=915 loops=1)

5. 0.006 0.290 ↑ 1.0 5 1

HashAggregate (cost=31.76..31.81 rows=5 width=8) (actual time=0.288..0.290 rows=5 loops=1)

  • Group Key: u_1.organisationid
6. 0.001 0.284 ↑ 1.0 5 1

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

7. 0.002 0.218 ↑ 1.0 5 1

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

8. 0.004 0.111 ↑ 1.0 5 1

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

9. 0.015 0.015 ↑ 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.014..0.015 rows=1 loops=1)

  • Index Cond: (userid = 11729)
10. 0.078 0.092 ↓ 1.2 5 1

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

  • Recheck Cond: (groupid = sg.groupid)
  • Heap Blocks: exact=3
11. 0.014 0.014 ↓ 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.014..0.014 rows=5 loops=1)

  • Index Cond: (groupid = sg.groupid)
12. 0.105 0.105 ↑ 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.021..0.021 rows=1 loops=5)

  • Index Cond: (id = m.userid)
13. 0.065 0.065 ↑ 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.013..0.013 rows=1 loops=5)

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

Index Scan using ix_user_organisationid on "user" u (cost=0.29..1.71 rows=7 width=8) (actual time=0.019..0.256 rows=183 loops=5)

  • Index Cond: (organisationid = o.id)
Planning time : 1.955 ms