explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lqcb

Settings
# exclusive inclusive rows x rows loops node
1. 0.358 1,390.161 ↑ 1.0 1 1

Nested Loop Left Join (cost=96,281.17..111,233.15 rows=1 width=8,382) (actual time=1,390.160..1,390.161 rows=1 loops=1)

  • Join Filter: (this_.activity_id = lisaevalua12_.lisa_evaluation_id)
  • Functions: 92
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 13.611 ms, Inlining 0.000 ms, Optimization 14.038 ms, Emission 190.777 ms, Total 218.426 ms"Execution Time: 1406.873 ms
2. 16.285 1,389.786 ↑ 1.0 1 1

Merge Join (cost=96,280.88..111,224.57 rows=1 width=8,007) (actual time=1,389.785..1,389.786 rows=1 loops=1)

  • Merge Cond: (this_.task_id = alias1_tas2_.task_id)
3. 0.018 205.736 ↑ 1.0 1 1

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

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

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

5. 0.005 205.705 ↑ 1.0 1 1

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

6. 0.006 205.699 ↑ 1.0 1 1

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

7. 0.005 205.692 ↑ 1.0 1 1

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

8. 0.004 205.684 ↑ 1.0 1 1

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

9. 0.006 205.675 ↑ 1.0 1 1

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

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

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

11. 0.023 0.023 ↑ 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.022..0.023 rows=1 loops=1)

  • Index Cond: (activity_id = 1060243)
12. 0.022 0.022 ↑ 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.022..0.022 rows=1 loops=1)

  • Index Cond: (task_id = this_.task_id)
13. 0.006 0.006 ↑ 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.006 rows=4 loops=1)

14. 0.005 0.005 ↑ 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.005..0.005 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.001 0.001 ↑ 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.001..0.001 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.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

  • Index Cond: (quote_id = alias0_tas1_.quote_id)
19. 30.155 1,167.765 ↓ 1.9 320,752 1

Subquery Scan on alias1_tas2_ (cost=96,260.29..110,780.89 rows=169,228 width=41) (actual time=740.005..1,167.765 rows=320,752 loops=1)

  • Filter: ((NOT alias1_tas2_.limit_access) OR (327 = ANY (alias1_tas2_.people_responsible)))
20. 45.611 1,137.610 ↑ 1.0 320,752 1

Unique (cost=96,260.29..103,520.59 rows=322,680 width=41) (actual time=740.003..1,137.610 rows=320,752 loops=1)

21. 304.037 1,091.999 ↓ 1.1 347,316 1

WindowAgg (cost=96,260.29..102,713.89 rows=322,680 width=41) (actual time=740.002..1,091.999 rows=347,316 loops=1)

22. 164.232 787.962 ↓ 1.1 347,317 1

Sort (cost=96,260.29..97,066.99 rows=322,680 width=49) (actual time=739.978..787.962 rows=347,317 loops=1)

  • Sort Key: task.task_id
  • Sort Method: external merge Disk: 14992kB
23. 43.575 623.730 ↓ 1.1 349,339 1

Hash Left Join (cost=15,064.71..55,703.48 rows=322,680 width=49) (actual time=112.502..623.730 rows=349,339 loops=1)

  • Hash Cond: (customer.customer_id = customer_add.customer_id)
24. 64.823 580.064 ↑ 1.0 322,680 1

Hash Left Join (cost=15,057.76..53,637.94 rows=322,680 width=49) (actual time=112.401..580.064 rows=322,680 loops=1)

  • Hash Cond: (COALESCE(project.customer_id, quote.customer_id) = customer.customer_id)
25. 58.944 494.465 ↑ 1.0 322,680 1

Hash Left Join (cost=12,854.05..50,586.98 rows=322,680 width=24) (actual time=91.586..494.465 rows=322,680 loops=1)

  • Hash Cond: (task.quote_id = quote.quote_id)
26. 113.129 406.973 ↑ 1.0 322,680 1

Hash Left Join (cost=8,696.21..45,582.08 rows=322,680 width=24) (actual time=62.994..406.973 rows=322,680 loops=1)

  • Hash Cond: (task.project_id = project.project_id)
27. 230.921 230.921 ↑ 1.0 322,680 1

Seq Scan on task (cost=0.00..31,740.80 rows=322,680 width=24) (actual time=0.007..230.921 rows=322,680 loops=1)

28. 19.217 62.923 ↑ 1.0 105,565 1

Hash (cost=6,860.65..6,860.65 rows=105,565 width=16) (actual time=62.923..62.923 rows=105,565 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 3505kB
29. 43.706 43.706 ↑ 1.0 105,565 1

Seq Scan on project (cost=0.00..6,860.65 rows=105,565 width=16) (actual time=0.029..43.706 rows=105,565 loops=1)

30. 8.845 28.548 ↑ 1.0 55,726 1

Hash (cost=3,461.26..3,461.26 rows=55,726 width=16) (actual time=28.548..28.548 rows=55,726 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3125kB
31. 19.703 19.703 ↑ 1.0 55,726 1

Seq Scan on quote (cost=0.00..3,461.26 rows=55,726 width=16) (actual time=0.009..19.703 rows=55,726 loops=1)

32. 3.295 20.776 ↑ 1.0 16,965 1

Hash (cost=1,991.65..1,991.65 rows=16,965 width=41) (actual time=20.776..20.776 rows=16,965 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1317kB
33. 17.481 17.481 ↑ 1.0 16,965 1

Seq Scan on customer (cost=0.00..1,991.65 rows=16,965 width=41) (actual time=0.017..17.481 rows=16,965 loops=1)

34. 0.067 0.091 ↑ 1.0 220 1

Hash (cost=4.20..4.20 rows=220 width=16) (actual time=0.091..0.091 rows=220 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
35. 0.024 0.024 ↑ 1.0 220 1

Seq Scan on customer_additional_persons_responsible customer_add (cost=0.00..4.20 rows=220 width=16) (actual time=0.009..0.024 rows=220 loops=1)

36. 0.017 0.017 ↓ 0.0 0 1

Index Scan using lisa_evaluation_pkey on lisa_evaluation lisaevalua12_ (cost=0.28..8.30 rows=1 width=211) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (lisa_evaluation_id = 1060243)