explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F7Io

Settings
# exclusive inclusive rows x rows loops node
1. 1.044 7,558.823 ↓ 1.9 739 1

Nested Loop Left Join (cost=6,367,781.58..2,458,422,511.67 rows=386 width=20) (actual time=491.245..7,558.823 rows=739 loops=1)

  • Functions: 99
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 7.497 ms, Inlining 8.387 ms, Optimization 302.870 ms, Emission 169.235 ms, Total 487.989 ms
2. 0.257 484.071 ↓ 1.9 739 1

Hash Join (cost=443.39..469.95 rows=386 width=4) (actual time=483.435..484.071 rows=739 loops=1)

  • Hash Cond: (cl.subproject_id = sp.id)
3. 0.758 2.013 ↑ 1.2 820 1

HashAggregate (cost=412.14..421.71 rows=957 width=595) (actual time=1.625..2.013 rows=820 loops=1)

  • Group Key: cl.id, cl.name, cl.comment, cl.subproject_id, cl.date_add, cl.add_user_id, cl.date_start, cl.date_end, cl.enabled, cl.script_id, cl.script_input_format_id, cl.is_test, cl.disable_result_export
4. 0.049 1.255 ↑ 1.2 820 1

Append (cost=0.00..381.04 rows=957 width=595) (actual time=0.009..1.255 rows=820 loops=1)

5. 0.178 0.178 ↓ 9.1 499 1

Seq Scan on call_list cl (cost=0.00..67.05 rows=55 width=83) (actual time=0.009..0.178 rows=499 loops=1)

  • Filter: (((name)::text !~~ 'incoming_call_list_%'::text) AND ((date_start)::date <= '2020-09-15'::date) AND ((date_end)::date >= '2020-09-01'::date))
  • Rows Removed by Filter: 81
6. 1.028 1.028 ↑ 2.8 321 1

Seq Scan on call_list__archive cla (cost=0.00..299.63 rows=902 width=101) (actual time=0.970..1.028 rows=321 loops=1)

  • Filter: (((name)::text !~~ 'incoming_call_list_%'::text) AND ((date_start)::date <= '2020-09-15'::date) AND ((date_end)::date >= '2020-09-01'::date))
  • Rows Removed by Filter: 7,796
7. 0.022 481.801 ↓ 1.6 156 1

Hash (cost=30.00..30.00 rows=100 width=4) (actual time=481.801..481.801 rows=156 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
8. 0.036 481.779 ↓ 1.6 156 1

Hash Join (cost=21.75..30.00 rows=100 width=4) (actual time=481.722..481.779 rows=156 loops=1)

  • Hash Cond: (sp.project_id = p.id)
9. 481.215 481.215 ↑ 1.0 201 1

Seq Scan on subproject sp (cost=0.00..6.49 rows=201 width=8) (actual time=481.182..481.215 rows=201 loops=1)

  • Filter: (NOT is_test)
  • Rows Removed by Filter: 48
10. 0.007 0.528 ↓ 1.2 37 1

Hash (cost=21.35..21.35 rows=32 width=12) (actual time=0.528..0.528 rows=37 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
11. 0.011 0.521 ↓ 1.2 37 1

Hash Join (cost=17.63..21.35 rows=32 width=12) (actual time=0.505..0.521 rows=37 loops=1)

  • Hash Cond: (p.id = p_1.id)
12. 0.012 0.478 ↓ 1.2 37 1

Hash Join (cost=15.19..18.83 rows=32 width=8) (actual time=0.467..0.478 rows=37 loops=1)

  • Hash Cond: (get_user_projects_allowed.id = p.id)
13. 0.020 0.450 ↑ 5.4 37 1

HashAggregate (cost=12.75..14.75 rows=200 width=4) (actual time=0.445..0.450 rows=37 loops=1)

  • Group Key: get_user_projects_allowed.id
14. 0.430 0.430 ↑ 27.0 37 1

Function Scan on get_user_projects_allowed (cost=0.25..10.25 rows=1,000 width=4) (actual time=0.428..0.430 rows=37 loops=1)

15. 0.009 0.016 ↑ 1.0 64 1

Hash (cost=1.64..1.64 rows=64 width=4) (actual time=0.016..0.016 rows=64 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
16. 0.007 0.007 ↑ 1.0 64 1

Seq Scan on project p (cost=0.00..1.64 rows=64 width=4) (actual time=0.003..0.007 rows=64 loops=1)

17. 0.011 0.032 ↑ 1.0 64 1

Hash (cost=1.64..1.64 rows=64 width=4) (actual time=0.031..0.032 rows=64 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
18. 0.021 0.021 ↑ 1.0 64 1

Seq Scan on project p_1 (cost=0.00..1.64 rows=64 width=4) (actual time=0.015..0.021 rows=64 loops=1)

19. 147.800 6,663.563 ↑ 1.0 1 739

Aggregate (cost=6,367,338.19..6,367,338.20 rows=1 width=8) (actual time=9.017..9.017 rows=1 loops=739)

20. 0.000 6,515.763 ↑ 770,926.8 3,236 739

Nested Loop (cost=0.86..130,540.23 rows=2,494,719,184 width=0) (actual time=0.008..8.817 rows=3,236 loops=739)

21. 133.020 380.585 ↑ 5.3 2,845 739

Append (cost=0.43..1,593.01 rows=15,112 width=8) (actual time=0.004..0.515 rows=2,845 loops=739)

22. 232.785 232.785 ↑ 3.1 2,690 739

Index Only Scan using idx_call_list_item_call_list_id2 on call_list_item cli_inner (cost=0.43..1,271.13 rows=8,383 width=8) (actual time=0.003..0.315 rows=2,690 loops=739)

  • Index Cond: (call_list_id = cl.id)
  • Heap Fetches: 0
23. 14.780 14.780 ↑ 43.4 155 739

Index Only Scan using idx_call_list_item__archive_call_list_id2 on call_list_item__archive cli_inner_archive (cost=0.56..246.32 rows=6,729 width=8) (actual time=0.002..0.020 rows=155 loops=739)

  • Index Cond: (call_list_id = cl.id)
  • Heap Fetches: 0
24. 2,102.305 6,306.915 ↑ 4.0 1 2,102,305

Append (cost=0.43..8.49 rows=4 width=8) (actual time=0.001..0.003 rows=1 loops=2,102,305)

25. 2,102.305 2,102.305 ↑ 1.0 1 2,102,305

Index Only Scan using idx_telecom_call_list_item_id2 on telecom t_inner (cost=0.43..3.99 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=2,102,305)

  • Index Cond: (call_list_item_id = cli_inner.id)
  • Heap Fetches: 0
26. 2,102.305 2,102.305 ↓ 0.0 0 2,102,305

Index Only Scan using idx_telecom__archive_call_list_item_id2 on telecom__archive t_inner_archive (cost=0.56..4.48 rows=3 width=8) (actual time=0.001..0.001 rows=0 loops=2,102,305)

  • Index Cond: (call_list_item_id = cli_inner.id)
  • Heap Fetches: 0
27.          

SubPlan (for Nested Loop Left Join)

28. 73.900 410.145 ↑ 1.0 1 739

Aggregate (cost=1,630.79..1,630.80 rows=1 width=8) (actual time=0.555..0.555 rows=1 loops=739)

29. 115.284 336.245 ↑ 5.3 2,845 739

Append (cost=0.43..1,593.01 rows=15,112 width=0) (actual time=0.003..0.455 rows=2,845 loops=739)

30. 207.659 207.659 ↑ 3.1 2,690 739

Index Only Scan using idx_call_list_item_call_list_id2 on call_list_item cli_inner_1 (cost=0.43..1,271.13 rows=8,383 width=0) (actual time=0.002..0.281 rows=2,690 loops=739)

  • Index Cond: (call_list_id = cl.id)
  • Heap Fetches: 0
31. 13.302 13.302 ↑ 43.4 155 739

Index Only Scan using idx_call_list_item__archive_call_list_id2 on call_list_item__archive cli_inner_archive_1 (cost=0.56..246.32 rows=6,729 width=0) (actual time=0.002..0.018 rows=155 loops=739)

  • Index Cond: (call_list_id = cl.id)
  • Heap Fetches: 0
Execution time : 7,566.660 ms