explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yHjJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 378.854 ↓ 0.0 0 1

Nested Loop Left Join (cost=21.30..54,704.66 rows=1 width=8,382) (actual time=378.854..378.854 rows=0 loops=1)

  • Join Filter: (this_.activity_id = lisaevalua12_.lisa_evaluation_id)
2. 0.002 378.853 ↓ 0.0 0 1

Merge Join (cost=21.01..54,696.09 rows=1 width=8,007) (actual time=378.853..378.853 rows=0 loops=1)

  • Merge Cond: (this_.task_id = alias1_tas2_.task_id)
3. 0.017 0.103 ↑ 1.0 1 1

Sort (cost=20.59..20.60 rows=1 width=7,966) (actual time=0.103..0.103 rows=1 loops=1)

  • Sort Key: this_.task_id
  • Sort Method: quicksort Memory: 29kB
4. 0.005 0.086 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.98..20.58 rows=1 width=7,966) (actual time=0.084..0.086 rows=1 loops=1)

5. 0.003 0.078 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..20.24 rows=1 width=6,236) (actual time=0.077..0.078 rows=1 loops=1)

6. 0.004 0.074 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.28..19.73 rows=1 width=4,573) (actual time=0.073..0.074 rows=1 loops=1)

7. 0.012 0.068 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.13..19.56 rows=1 width=4,156) (actual time=0.068..0.068 rows=1 loops=1)

8. 0.005 0.053 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.99..19.40 rows=1 width=3,739) (actual time=0.052..0.053 rows=1 loops=1)

9. 0.004 0.045 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..19.24 rows=1 width=3,237) (actual time=0.045..0.045 rows=1 loops=1)

  • Join Filter: (this_.payment_conditions_id = paymentcon4_.payment_conditions_id)
  • Rows Removed by Join Filter: 3
10. 0.019 0.034 ↑ 1.0 1 1

Nested Loop (cost=0.85..16.88 rows=1 width=2,006) (actual time=0.033..0.034 rows=1 loops=1)

11. 0.010 0.010 ↑ 1.0 1 1

Index Scan using activity_pkey on activity this_ (cost=0.42..8.44 rows=1 width=1,198) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (activity_id = 1060243)
12. 0.005 0.005 ↑ 1.0 1 1

Index Scan using task_pkey on task alias0_tas1_ (cost=0.42..8.44 rows=1 width=808) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (task_id = this_.task_id)
13. 0.007 0.007 ↑ 4.0 4 1

Seq Scan on payment_conditions paymentcon4_ (cost=0.00..2.16 rows=16 width=1,231) (actual time=0.006..0.007 rows=4 loops=1)

14. 0.003 0.003 ↑ 1.0 1 1

Index Scan using language_specialization_pkey on language_specialization languagesp6_ (cost=0.14..0.16 rows=1 width=502) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (language_specialization_id = alias0_tas1_.language_specialization_id)
15. 0.003 0.003 ↑ 1.0 1 1

Index Scan using xtrf_language_pkey on xtrf_language language7_ (cost=0.14..0.16 rows=1 width=417) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (xtrf_language_id = alias0_tas1_.source_language_id)
16. 0.002 0.002 ↑ 1.0 1 1

Index Scan using xtrf_language_pkey on xtrf_language language8_ (cost=0.14..0.16 rows=1 width=417) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (xtrf_language_id = alias0_tas1_.target_language_id)
17. 0.001 0.001 ↓ 0.0 0 1

Index Scan using project_pkey on project project9_ (cost=0.42..0.51 rows=1 width=1,663) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (project_id = alias0_tas1_.project_id)
18. 0.003 0.003 ↑ 1.0 1 1

Index Scan using quote_pkey on quote quote10_ (cost=0.29..0.35 rows=1 width=1,730) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (quote_id = alias0_tas1_.quote_id)
19. 38.752 378.748 ↓ 0.0 0 1

Subquery Scan on alias1_tas2_ (cost=0.42..54,252.41 rows=169,228 width=41) (actual time=378.748..378.748 rows=0 loops=1)

  • Filter: ((NOT alias1_tas2_.limit_access) OR (327 = ANY (alias1_tas2_.people_responsible)))
  • Rows Removed by Filter: 322680
20. 44.229 339.996 ↑ 1.0 322,680 1

Unique (cost=0.42..46,992.11 rows=322,680 width=41) (actual time=0.011..339.996 rows=322,680 loops=1)

21. 295.767 295.767 ↑ 1.0 322,680 1

Index Only Scan using task_pkey on task (cost=0.42..46,185.41 rows=322,680 width=41) (actual time=0.011..295.767 rows=322,680 loops=1)

  • Heap Fetches: 322680
22. 0.000 0.000 ↓ 0.0 0

Index Scan using lisa_evaluation_pkey on lisa_evaluation lisaevalua12_ (cost=0.28..8.30 rows=1 width=211) (never executed)

  • Index Cond: (lisa_evaluation_id = 1060243)