explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5WL1

Settings
# exclusive inclusive rows x rows loops node
1. 0.227 815.741 ↓ 1.9 739 1

Hash Join (cost=443.39..629,958.75 rows=386 width=12) (actual time=396.030..815.741 rows=739 loops=1)

  • Hash Cond: (cl.subproject_id = sp.id)
  • Functions: 73
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 5.723 ms, Inlining 11.244 ms, Optimization 245.608 ms, Emission 135.917 ms, Total 398.492 ms"Execution Time: 821.730 ms
2. 0.610 1.789 ↑ 1.2 820 1

HashAggregate (cost=412.14..421.71 rows=957 width=595) (actual time=1.508..1.789 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
3. 0.064 1.179 ↑ 1.2 820 1

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

4. 0.167 0.167 ↓ 9.1 499 1

Seq Scan on call_list cl (cost=0.00..67.05 rows=55 width=83) (actual time=0.009..0.167 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
5. 0.948 0.948 ↑ 2.8 321 1

Seq Scan on call_list__archive cla (cost=0.00..299.63 rows=902 width=101) (actual time=0.895..0.948 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
6. 0.021 393.973 ↓ 1.6 156 1

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

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

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

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

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

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
10. 0.013 0.504 ↓ 1.2 37 1

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

  • Hash Cond: (p.id = p_1.id)
11. 0.011 0.464 ↓ 1.2 37 1

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

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

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

  • Group Key: get_user_projects_allowed.id
13. 0.418 0.418 ↑ 27.0 37 1

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

14. 0.000 0.015 ↑ 1.0 64 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
15. 0.022 0.022 ↑ 1.0 64 1

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

16. 0.010 0.027 ↑ 1.0 64 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
17. 0.017 0.017 ↑ 1.0 64 1

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

18.          

SubPlan (for Hash Join)

19. 76.856 419.752 ↑ 1.0 1 739

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

20. 117.501 342.896 ↑ 5.3 2,845 739

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

21. 212.093 212.093 ↑ 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=0) (actual time=0.002..0.287 rows=2,690 loops=739)

  • Index Cond: (call_list_id = cl.id)
  • Heap Fetches: 0
22. 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 (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