explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y0Gb

Settings
# exclusive inclusive rows x rows loops node
1. 45.064 2,538.482 ↑ 1.0 1 1

Hash Right Join (cost=2,302.37..146,665.69 rows=1 width=1,253) (actual time=2,538.482..2,538.482 rows=1 loops=1)

  • Hash Cond: ("Extent4".projectpreparationid = "Extent1".id)
2. 2,007.136 2,493.282 ↑ 1.0 1,579,154 1

Hash Join (cost=2,277.43..140,718.92 rows=1,579,154 width=339) (actual time=17.867..2,493.282 rows=1,579,154 loops=1)

  • Hash Cond: ("Extent4".userid = "Extent5".id)
3. 468.426 468.426 ↑ 1.0 1,579,154 1

Seq Scan on comment "Extent4" (cost=0.00..53,507.54 rows=1,579,154 width=184) (actual time=0.009..468.426 rows=1,579,154 loops=1)

4. 13.606 17.720 ↑ 1.0 26,508 1

Hash (cost=1,350.08..1,350.08 rows=26,508 width=155) (actual time=17.720..17.720 rows=26,508 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 2412kB
5. 4.114 4.114 ↑ 1.0 26,508 1

Seq Scan on "user" "Extent5" (cost=0.00..1,350.08 rows=26,508 width=155) (actual time=0.107..4.114 rows=26,508 loops=1)

6. 0.012 0.136 ↑ 1.0 1 1

Hash (cost=24.93..24.93 rows=1 width=914) (actual time=0.136..0.136 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.000 0.124 ↑ 1.0 1 1

Limit (cost=0.86..24.92 rows=1 width=914) (actual time=0.123..0.124 rows=1 loops=1)

8. 0.002 0.124 ↑ 1.0 1 1

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

9. 0.003 0.101 ↑ 1.0 1 1

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

10. 0.065 0.065 ↑ 1.0 1 1

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

  • Index Cond: (id = 23)
11. 0.033 0.033 ↑ 1.0 1 1

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

  • Index Cond: (id = "Extent1".ownerorganisationid)
12. 0.021 0.021 ↑ 1.0 1 1

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

  • Index Cond: (id = "Extent1".createdbyuserid)
Planning time : 58.888 ms