explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hnO6

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 358.338 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.58..36,201.34 rows=1 width=1,253) (actual time=358.334..358.338 rows=1 loops=1)

2. 0.001 0.036 ↑ 1.0 1 1

Limit (cost=0.86..24.92 rows=1 width=914) (actual time=0.033..0.036 rows=1 loops=1)

3. 0.002 0.035 ↑ 1.0 1 1

Nested Loop (cost=0.86..24.92 rows=1 width=914) (actual time=0.032..0.035 rows=1 loops=1)

4. 0.004 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.57..16.61 rows=1 width=759) (actual time=0.023..0.025 rows=1 loops=1)

5. 0.010 0.010 ↑ 1.0 1 1

Index Scan using pk_projectpreparation on projectpreparation "Extent1" (cost=0.29..8.31 rows=1 width=122) (actual time=0.008..0.010 rows=1 loops=1)

  • Index Cond: (id = 23)
6. 0.011 0.011 ↑ 1.0 1 1

Index Scan using pk_organisation on organisation "Extent2" (cost=0.28..8.30 rows=1 width=637) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = "Extent1".ownerorganisationid)
7. 0.008 0.008 ↑ 1.0 1 1

Index Scan using pk_user on "user" "Extent3" (cost=0.29..8.30 rows=1 width=155) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = "Extent1".createdbyuserid)
8. 0.001 358.298 ↓ 0.0 0 1

Nested Loop (cost=0.71..36,176.40 rows=1 width=339) (actual time=358.298..358.298 rows=0 loops=1)

9. 358.297 358.297 ↓ 0.0 0 1

Index Scan using ix_comment_userid on comment "Extent4" (cost=0.43..36,176.09 rows=1 width=184) (actual time=358.297..358.297 rows=0 loops=1)

  • Index Cond: ("Extent1".id = projectpreparationid)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_user on "user" "Extent5" (cost=0.29..0.31 rows=1 width=155) (never executed)

  • Index Cond: (id = "Extent4".userid)
Planning time : 6.353 ms