explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K2U1

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 14.515 ↓ 2.5 28 1

Limit (cost=525.81..525.84 rows=11 width=873) (actual time=14.508..14.515 rows=28 loops=1)

2. 0.058 14.508 ↓ 2.5 28 1

Sort (cost=525.81..525.84 rows=11 width=873) (actual time=14.506..14.508 rows=28 loops=1)

  • Sort Key: g.application_project_id
  • Sort Method: quicksort Memory: 40kB
3. 0.058 14.450 ↓ 2.5 28 1

Hash Left Join (cost=334.86..525.62 rows=11 width=873) (actual time=13.822..14.450 rows=28 loops=1)

  • Hash Cond: (g.applications_status_id = ass.applications_status_id)
4. 0.025 14.342 ↓ 2.5 28 1

Hash Left Join (cost=330.72..521.33 rows=11 width=844) (actual time=13.750..14.342 rows=28 loops=1)

  • Hash Cond: (g.application_project_id = form2.application_project_id)
5. 0.033 14.316 ↓ 2.5 28 1

Nested Loop Left Join (cost=317.35..507.90 rows=11 width=812) (actual time=13.735..14.316 rows=28 loops=1)

6. 0.702 14.199 ↓ 2.5 28 1

Hash Right Join (cost=317.06..420.47 rows=11 width=755) (actual time=13.728..14.199 rows=28 loops=1)

  • Hash Cond: (up.user_id = g_1.create_user_id)
7. 0.585 0.585 ↑ 1.0 4,967 1

Seq Scan on tbl_user_personals up (cost=0.00..84.67 rows=4,967 width=21) (actual time=0.005..0.585 rows=4,967 loops=1)

8. 0.055 12.912 ↓ 2.5 28 1

Hash (cost=316.92..316.92 rows=11 width=742) (actual time=12.912..12.912 rows=28 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
9. 0.044 12.857 ↓ 2.5 28 1

Nested Loop Left Join (cost=151.41..316.92 rows=11 width=742) (actual time=0.537..12.857 rows=28 loops=1)

10. 0.083 0.101 ↓ 2.5 28 1

Bitmap Heap Scan on gen_application_project g (cost=4.55..106.59 rows=11 width=389) (actual time=0.034..0.101 rows=28 loops=1)

  • Recheck Cond: (company_id = 4,808)
  • Filter: (status AND (NOT is_tmp) AND (NOT mailed) AND (NOT is_reject))
  • Rows Removed by Filter: 18
  • Heap Blocks: exact=31
11. 0.018 0.018 ↓ 1.6 56 1

Bitmap Index Scan on i_gen_application_project_company_id (cost=0.00..4.55 rows=35 width=0) (actual time=0.018..0.018 rows=56 loops=1)

  • Index Cond: (company_id = 4,808)
12. 0.224 12.712 ↑ 1.0 1 28

Hash Right Join (cost=146.86..152.62 rows=1 width=357) (actual time=0.452..0.454 rows=1 loops=28)

  • Hash Cond: (tpm.choose_project_id = g_2.choose_project_id)
13. 0.028 0.028 ↓ 0.0 0 28

HashAggregate (cost=99.75..102.75 rows=200 width=40) (actual time=0.001..0.001 rows=0 loops=28)

  • Group Key: tpm.choose_project_id
14. 0.000 0.000 ↓ 0.0 0 1

Hash Left Join (cost=29.12..85.20 rows=1,940 width=40) (actual time=0.000..0.000 rows=0 loops=1)

  • Hash Cond: (tpm.specialization_id = u.specialization_id)
15. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on gen_choose_project_specialization tpm (cost=0.00..29.40 rows=1,940 width=8) (actual time=0.000..0.000 rows=0 loops=1)

16. 0.000 0.000 ↓ 0.0 0

Hash (cost=18.50..18.50 rows=850 width=36) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on specialization u (cost=0.00..18.50 rows=850 width=36) (never executed)

18. 0.028 12.460 ↑ 1.0 1 28

Hash (cost=47.10..47.10 rows=1 width=361) (actual time=0.445..0.445 rows=1 loops=28)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
19. 0.056 12.432 ↑ 1.0 1 28

Nested Loop Left Join (cost=2.08..47.10 rows=1 width=361) (actual time=0.337..0.444 rows=1 loops=28)

20. 0.112 12.292 ↑ 1.0 1 28

Nested Loop Left Join (cost=1.94..46.88 rows=1 width=344) (actual time=0.334..0.439 rows=1 loops=28)

21. 0.112 0.112 ↑ 1.0 1 28

Index Scan using i_gen_choose_project2_application_project_id on gen_choose_project2 g_1 (cost=0.29..7.94 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=28)

  • Index Cond: (g.application_project_id = application_project_id)
  • Filter: (status AND (NOT is_tmp))
22. 3.416 12.068 ↑ 2.0 1 28

Hash Right Join (cost=1.65..38.92 rows=2 width=332) (actual time=0.327..0.431 rows=1 loops=28)

  • Hash Cond: (dn.document_type_id = g_2.document_type_id)
23. 8.092 8.092 ↑ 1.0 1,109 28

Seq Scan on tbl_document_numeration dn (cost=0.00..33.09 rows=1,109 width=8) (actual time=0.002..0.289 rows=1,109 loops=28)

  • Filter: status
24. 0.056 0.560 ↑ 1.0 1 28

Hash (cost=1.64..1.64 rows=1 width=336) (actual time=0.020..0.020 rows=1 loops=28)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
25. 0.000 0.504 ↑ 1.0 1 28

Nested Loop Left Join (cost=1.10..1.64 rows=1 width=336) (actual time=0.016..0.018 rows=1 loops=28)

26. 0.056 0.448 ↑ 1.0 1 28

Nested Loop Left Join (cost=0.97..1.44 rows=1 width=308) (actual time=0.014..0.016 rows=1 loops=28)

27. 0.028 0.392 ↑ 1.0 1 28

Nested Loop Left Join (cost=0.84..1.24 rows=1 width=280) (actual time=0.013..0.014 rows=1 loops=28)

28. 0.028 0.364 ↑ 1.0 1 28

Nested Loop Left Join (cost=0.71..1.03 rows=1 width=252) (actual time=0.012..0.013 rows=1 loops=28)

29. 0.028 0.280 ↑ 1.0 1 28

Nested Loop Left Join (cost=0.56..0.76 rows=1 width=164) (actual time=0.009..0.010 rows=1 loops=28)

30. 0.056 0.196 ↑ 1.0 1 28

Nested Loop Left Join (cost=0.42..0.52 rows=1 width=116) (actual time=0.006..0.007 rows=1 loops=28)

31. 0.084 0.084 ↑ 1.0 1 28

Index Scan using gen_choose_project_pkey on gen_choose_project g_2 (cost=0.28..0.30 rows=1 width=111) (actual time=0.003..0.003 rows=1 loops=28)

  • Index Cond: (g_1.ext_choose_project_id = choose_project_id)
  • Filter: (status AND (NOT is_tmp))
32. 0.056 0.056 ↑ 1.0 1 28

Index Scan using gen_priority_pkey on gen_priority g_3 (cost=0.14..0.21 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=28)

  • Index Cond: (priority_id = g_2.priority_id)
  • Filter: (status AND (NOT is_tmp))
33. 0.056 0.056 ↑ 1.0 1 28

Index Scan using gen_action_pkey on gen_action g_4 (cost=0.14..0.24 rows=1 width=56) (actual time=0.002..0.002 rows=1 loops=28)

  • Index Cond: (action_id = g_2.action_id)
  • Filter: (status AND (NOT is_tmp))
34. 0.056 0.056 ↑ 1.0 1 28

Index Scan using gen_action_component_pkey on gen_action_component g_5 (cost=0.14..0.25 rows=1 width=96) (actual time=0.002..0.002 rows=1 loops=28)

  • Index Cond: (action_component_id = g_2.action_component_id)
  • Filter: (status AND (NOT is_tmp))
35. 0.000 0.000 ↓ 0.0 0 28

Index Scan using gen_action_component2_pkey on gen_action_component2 g_6 (cost=0.14..0.20 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=28)

  • Index Cond: (action_component2_id = g_2.action_component2_id)
  • Filter: (status AND (NOT is_tmp))
36. 0.000 0.000 ↓ 0.0 0 28

Index Scan using gen_status_pkey on gen_status g_7 (cost=0.13..0.19 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=28)

  • Index Cond: (status_id = g_2.status_id)
  • Filter: status
37. 0.056 0.056 ↑ 1.0 1 28

Index Scan using pkey_selection_mode_id on gen_selection_mode sm (cost=0.13..0.19 rows=1 width=36) (actual time=0.001..0.002 rows=1 loops=28)

  • Index Cond: (selection_mode_id = g_2.selection_mode_id)
38. 0.084 0.084 ↑ 1.0 1 28

Index Scan using gen_operational_program_pkey on gen_operational_program a (cost=0.14..0.21 rows=1 width=25) (actual time=0.002..0.003 rows=1 loops=28)

  • Index Cond: (operational_program_id = g_2.operational_program_id)
  • Filter: status
39. 0.084 0.084 ↑ 1.0 1 28

Index Scan using i_form_lrpo_af1_application_project_id on lrpo_af1 form1 (cost=0.29..7.94 rows=1 width=61) (actual time=0.002..0.003 rows=1 loops=28)

  • Index Cond: (application_project_id = g.application_project_id)
40. 0.001 0.001 ↓ 0.0 0 1

Hash (cost=11.50..11.50 rows=150 width=36) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
41. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on poir1_21 form2 (cost=0.00..11.50 rows=150 width=36) (actual time=0.000..0.000 rows=0 loops=1)

42. 0.029 0.050 ↑ 1.0 95 1

Hash (cost=2.95..2.95 rows=95 width=33) (actual time=0.050..0.050 rows=95 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 7kB
43. 0.021 0.021 ↑ 1.0 95 1

Seq Scan on applications_status ass (cost=0.00..2.95 rows=95 width=33) (actual time=0.005..0.021 rows=95 loops=1)

Planning time : 28.135 ms
Execution time : 15.142 ms