explain.depesz.com

PostgreSQL's explain analyze made readable

Result: siqIH

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

Nested Loop Left Join (cost=4.54..31.99 rows=1 width=1,315) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.26..31.65 rows=1 width=1,274) (actual rows= loops=)

  • Join Filter: NULL::boolean
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.26..31.65 rows=1 width=758) (actual rows= loops=)

  • Join Filter: (at.breaktypeid = breaktype5.id)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.26..30.61 rows=1 width=522) (actual rows= loops=)

  • Join Filter: (at.billingrateid = billingrate4.id)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.26..29.56 rows=1 width=404) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.98..21.25 rows=1 width=371) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.69..12.94 rows=1 width=345) (actual rows= loops=)

  • Join Filter: (at.activityid = activities1.id)
8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.69..11.87 rows=1 width=109) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Merge Join (cost=3.41..3.56 rows=1 width=105) (actual rows= loops=)

  • Merge Cond: (ui.id = at.userid)
10. 0.000 0.000 ↓ 0.0

Index Scan using userinfo_pkey on userinfo ui (cost=0.28..1,038.24 rows=7,772 width=20) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Sort (cost=2.99..2.99 rows=1 width=89) (actual rows= loops=)

  • Sort Key: at.userid
12. 0.000 0.000 ↓ 0.0

Seq Scan on allocatedtime at (cost=0.00..2.98 rows=1 width=89) (actual rows= loops=)

  • Filter: (totimestamputc IS NULL)
13. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project pj (cost=0.29..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (at.projectid = id)
14. 0.000 0.000 ↓ 0.0

Seq Scan on activities activities1 (cost=0.00..1.03 rows=3 width=240) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project project2 (cost=0.29..8.30 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (at.projectid = id)
16. 0.000 0.000 ↓ 0.0

Index Scan using task_pkey on task task3 (cost=0.28..8.30 rows=1 width=37) (actual rows= loops=)

  • Index Cond: (at.taskid = id)
17. 0.000 0.000 ↓ 0.0

Seq Scan on billingrate billingrate4 (cost=0.00..1.02 rows=2 width=134) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on breaktype breaktype5 (cost=0.00..1.02 rows=2 width=252) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=0) (actual rows= loops=)

  • One-Time Filter: false
20. 0.000 0.000 ↓ 0.0

Index Scan using clients_pkey on clients clients7 (cost=0.28..0.32 rows=1 width=45) (actual rows= loops=)

  • Index Cond: (pj.clientid = id)