#	exclusive	inclusive	rows x	rows	loops	node
1.	0.019	14.674	↑ 501.6	44	1	→ Unique (cost=27,602.73..32,237.85 rows=22,072 width=2,133) (actual time=14.628..14.674 rows=44 loops=1)
2.						Initplan (for Unique)
3.	0.024	0.024	↑ 1.0	1	1	→ Seq Scan on task_mgt_tag taskmanage13_ (cost=0.00..1.79 rows=1 width=8) (actual time=0.010..0.024 rows=1 loops=1) Filter: ((label)::text = 'ARCHIVED'::text) Rows Removed by Filter: 62
4.	0.306	14.631	↑ 501.6	44	1	→ Sort (cost=27,600.95..27,656.13 rows=22,072 width=2,133) (actual time=14.627..14.631 rows=44 loops=1) Sort Key: taskentity0_.id, actions1_.business_id, comments8_.creation_date, comments2_.creation_date, actions1_.id, comments8_.id, taskmanage10_.id, taskmanage11_.id, children12_.id, comments2_.id, checklisti3_.id, taskmanage5_.id, taskmanage6_.id, (...) Sort Method: quicksort Memory: 48kB
5.	0.071	14.325	↑ 501.6	44	1	→ Hash Left Join (cost=4,375.72..5,638.46 rows=22,072 width=2,133) (actual time=14.203..14.325 rows=44 loops=1) Hash Cond: (taskentity0_.id = tags4_.task_id)
6.	0.044	11.880	↑ 567.9	26	1	→ Hash Left Join (cost=4,307.09..5,146.09 rows=14,765 width=1,884) (actual time=11.810..11.880 rows=26 loops=1) Hash Cond: (taskentity0_.id = checklisti3_.task_id)
7.	0.048	11.814	↑ 567.9	26	1	→ Hash Join (cost=4,305.66..5,086.42 rows=14,765 width=828) (actual time=11.764..11.814 rows=26 loops=1) Hash Cond: (taskentity0_.project_business_id = project16_.business_id)
8.	3.060	11.594	↑ 527.3	28	1	→ Hash Right Join (cost=4,299.94..5,025.33 rows=14,765 width=828) (actual time=11.566..11.594 rows=28 loops=1) Hash Cond: (comments8_.action_id = actions1_.id)
9.	2.696	2.696	↑ 1.0	16,490	1	→ Seq Scan on task_mgt_action_comment comments8_ (cost=0.00..515.90 rows=16,490 width=136) (actual time=0.006..2.696 rows=16,490 loops=1)
10.	0.048	5.838	↑ 17.4	28	1	→ Hash (cost=4,293.84..4,293.84 rows=488 width=692) (actual time=5.838..5.838 rows=28 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 17kB
11.	0.049	5.790	↑ 17.4	28	1	→ Hash Left Join (cost=4,262.81..4,293.84 rows=488 width=692) (actual time=5.166..5.790 rows=28 loops=1) Hash Cond: (tags9_.tag_id = taskmanage10_.id)
12.	0.161	5.493	↑ 17.4	28	1	→ Hash Right Join (cost=4,255.07..4,279.38 rows=488 width=539) (actual time=4.901..5.493 rows=28 loops=1) Hash Cond: (actions1_.task_id = taskentity0_.id)
13.	0.446	0.579	↓ 1.0	546	1	→ Hash Left Join (cost=1.14..20.69 rows=545 width=165) (actual time=0.039..0.579 rows=546 loops=1) Hash Cond: (actions1_.id = tags9_.action_id)
14.	0.122	0.122	↑ 1.0	545	1	→ Seq Scan on task_mgt_action actions1_ (cost=0.00..17.45 rows=545 width=149) (actual time=0.007..0.122 rows=545 loops=1)
15.	0.006	0.011	↑ 1.0	6	1	→ Hash (cost=1.06..1.06 rows=6 width=16) (actual time=0.011..0.011 rows=6 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
16.	0.005	0.005	↑ 1.0	6	1	→ Seq Scan on task_mgt_tag_to_action tags9_ (cost=0.00..1.06 rows=6 width=16) (actual time=0.004..0.005 rows=6 loops=1)
17.	0.033	4.753	↑ 27.1	18	1	→ Hash (cost=4,247.83..4,247.83 rows=488 width=374) (actual time=4.753..4.753 rows=18 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 13kB
18.	0.057	4.720	↑ 27.1	18	1	→ Hash Left Join (cost=10.13..4,247.83 rows=488 width=374) (actual time=0.810..4.720 rows=18 loops=1) Hash Cond: (taskentity0_.id = comments2_.task_id)
19.	1.378	4.306	↑ 27.1	18	1	→ Seq Scan on task_mgt_task taskentity0_ (cost=0.00..4,226.80 rows=488 width=249) (actual time=0.424..4.306 rows=18 loops=1) Filter: (NOT (SubPlan 2)) Rows Removed by Filter: 958
20.						SubPlan (for Seq Scan)
21.	2.928	2.928	↑ 1.0	1	976	→ Index Only Scan using task_mgt_tag_to_task_idx on task_mgt_tag_to_task tags14_ (cost=0.28..8.29 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=976) Index Cond: (task_id = taskentity0_.id) Heap Fetches: 1204
22.	0.212	0.357	↑ 1.0	228	1	→ Hash (cost=7.28..7.28 rows=228 width=125) (actual time=0.357..0.357 rows=228 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 45kB
23.	0.145	0.145	↑ 1.0	228	1	→ Seq Scan on task_mgt_task_comment comments2_ (cost=0.00..7.28 rows=228 width=125) (actual time=0.009..0.145 rows=228 loops=1)
24.	0.046	0.248	↑ 1.0	63	1	→ Hash (cost=6.96..6.96 rows=63 width=153) (actual time=0.248..0.248 rows=63 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 14kB
25.	0.059	0.202	↑ 1.0	63	1	→ Hash Left Join (cost=4.83..6.96 rows=63 width=153) (actual time=0.126..0.202 rows=63 loops=1) Hash Cond: (taskmanage10_.id = children12_.parent_id)
26.	0.068	0.123	↑ 1.0	63	1	→ Hash Right Join (cost=2.42..4.29 rows=63 width=102) (actual time=0.090..0.123 rows=63 loops=1) Hash Cond: (taskmanage11_.id = taskmanage10_.parent_id)
27.	0.012	0.012	↑ 1.0	63	1	→ Seq Scan on task_mgt_tag taskmanage11_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.012 rows=63 loops=1)
28.	0.028	0.043	↑ 1.0	63	1	→ Hash (cost=1.63..1.63 rows=63 width=51) (actual time=0.043..0.043 rows=63 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 13kB
29.	0.015	0.015	↑ 1.0	63	1	→ Seq Scan on task_mgt_tag taskmanage10_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.005..0.015 rows=63 loops=1)
30.	0.008	0.020	↓ 0.0	0	1	→ Hash (cost=1.63..1.63 rows=63 width=51) (actual time=0.020..0.020 rows=0 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 8kB
31.	0.012	0.012	↑ 1.0	63	1	→ Seq Scan on task_mgt_tag children12_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.012 rows=63 loops=1)
32.	0.009	0.172	↑ 1.0	8	1	→ Hash (cost=5.63..5.63 rows=8 width=8) (actual time=0.172..0.172 rows=8 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
33.	0.015	0.163	↑ 1.0	8	1	→ HashAggregate (cost=5.55..5.63 rows=8 width=8) (actual time=0.159..0.163 rows=8 loops=1) Group Key: project16_.business_id
34.	0.030	0.148	↑ 1.0	8	1	→ Hash Join (cost=2.12..5.53 rows=8 width=8) (actual time=0.113..0.148 rows=8 loops=1) Hash Cond: (projectmem15_.project_id = project16_.id)
35.	0.055	0.055	↑ 1.0	8	1	→ Seq Scan on task_mgt_project_member projectmem15_ (cost=0.00..3.30 rows=8 width=8) (actual time=0.026..0.055 rows=8 loops=1) Filter: ((user_id)::text = 'b976d6f8-a036-4898-84ef-b6e33ac4dd98'::text) Rows Removed by Filter: 96
36.	0.036	0.063	↑ 1.0	50	1	→ Hash (cost=1.50..1.50 rows=50 width=16) (actual time=0.063..0.063 rows=50 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 11kB
37.	0.027	0.027	↑ 1.0	50	1	→ Seq Scan on task_mgt_project project16_ (cost=0.00..1.50 rows=50 width=16) (actual time=0.007..0.027 rows=50 loops=1)
38.	0.012	0.022	↑ 1.0	19	1	→ Hash (cost=1.19..1.19 rows=19 width=1,056) (actual time=0.022..0.022 rows=19 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 10kB
39.	0.010	0.010	↑ 1.0	19	1	→ Seq Scan on task_mgt_checklist_item checklisti3_ (cost=0.00..1.19 rows=19 width=1,056) (actual time=0.004..0.010 rows=19 loops=1)
40.	0.785	2.374	↑ 1.0	1,459	1	→ Hash (cost=50.40..50.40 rows=1,459 width=169) (actual time=2.374..2.374 rows=1,459 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 153kB
41.	1.164	1.589	↑ 1.0	1,459	1	→ Hash Left Join (cost=7.74..50.40 rows=1,459 width=169) (actual time=0.226..1.589 rows=1,459 loops=1) Hash Cond: (tags4_.tag_id = taskmanage5_.id)
42.	0.223	0.223	↑ 1.0	1,459	1	→ Seq Scan on task_mgt_tag_to_task tags4_ (cost=0.00..22.59 rows=1,459 width=16) (actual time=0.007..0.223 rows=1,459 loops=1)
43.	0.033	0.202	↑ 1.0	63	1	→ Hash (cost=6.96..6.96 rows=63 width=153) (actual time=0.202..0.202 rows=63 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 14kB
44.	0.049	0.169	↑ 1.0	63	1	→ Hash Left Join (cost=4.83..6.96 rows=63 width=153) (actual time=0.110..0.169 rows=63 loops=1) Hash Cond: (taskmanage5_.id = children7_.parent_id)
45.	0.052	0.105	↑ 1.0	63	1	→ Hash Right Join (cost=2.42..4.29 rows=63 width=102) (actual time=0.080..0.105 rows=63 loops=1) Hash Cond: (taskmanage6_.id = taskmanage5_.parent_id)
46.	0.010	0.010	↑ 1.0	63	1	→ Seq Scan on task_mgt_tag taskmanage6_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.003..0.010 rows=63 loops=1)
47.	0.030	0.043	↑ 1.0	63	1	→ Hash (cost=1.63..1.63 rows=63 width=51) (actual time=0.043..0.043 rows=63 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 13kB
48.	0.013	0.013	↑ 1.0	63	1	→ Seq Scan on task_mgt_tag taskmanage5_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.013 rows=63 loops=1)
49.	0.006	0.015	↓ 0.0	0	1	→ Hash (cost=1.63..1.63 rows=63 width=51) (actual time=0.015..0.015 rows=0 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 8kB
50.	0.009	0.009	↑ 1.0	63	1	→ Seq Scan on task_mgt_tag children7_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.003..0.009 rows=63 loops=1)

"Unique  (cost=27602.73..32237.85 rows=22072 width=2133) (actual time=14.628..14.674 rows=44 loops=1)"
"  InitPlan 1 (returns $0)"
"    ->  Seq Scan on task_mgt_tag taskmanage13_  (cost=0.00..1.79 rows=1 width=8) (actual time=0.010..0.024 rows=1 loops=1)"
"          Filter: ((label)::text = 'ARCHIVED'::text)"
"          Rows Removed by Filter: 62"
"  ->  Sort  (cost=27600.95..27656.13 rows=22072 width=2133) (actual time=14.627..14.631 rows=44 loops=1)"
"        Sort Key: taskentity0_.id, actions1_.business_id, comments8_.creation_date, comments2_.creation_date, actions1_.id, comments8_.id, taskmanage10_.id, taskmanage11_.id, children12_.id, comments2_.id, checklisti3_.id, taskmanage5_.id, taskmanage6_.id, (...)"
"        Sort Method: quicksort  Memory: 48kB"
"        ->  Hash Left Join  (cost=4375.72..5638.46 rows=22072 width=2133) (actual time=14.203..14.325 rows=44 loops=1)"
"              Hash Cond: (taskentity0_.id = tags4_.task_id)"
"              ->  Hash Left Join  (cost=4307.09..5146.09 rows=14765 width=1884) (actual time=11.810..11.880 rows=26 loops=1)"
"                    Hash Cond: (taskentity0_.id = checklisti3_.task_id)"
"                    ->  Hash Join  (cost=4305.66..5086.42 rows=14765 width=828) (actual time=11.764..11.814 rows=26 loops=1)"
"                          Hash Cond: (taskentity0_.project_business_id = project16_.business_id)"
"                          ->  Hash Right Join  (cost=4299.94..5025.33 rows=14765 width=828) (actual time=11.566..11.594 rows=28 loops=1)"
"                                Hash Cond: (comments8_.action_id = actions1_.id)"
"                                ->  Seq Scan on task_mgt_action_comment comments8_  (cost=0.00..515.90 rows=16490 width=136) (actual time=0.006..2.696 rows=16490 loops=1)"
"                                ->  Hash  (cost=4293.84..4293.84 rows=488 width=692) (actual time=5.838..5.838 rows=28 loops=1)"
"                                      Buckets: 1024  Batches: 1  Memory Usage: 17kB"
"                                      ->  Hash Left Join  (cost=4262.81..4293.84 rows=488 width=692) (actual time=5.166..5.790 rows=28 loops=1)"
"                                            Hash Cond: (tags9_.tag_id = taskmanage10_.id)"
"                                            ->  Hash Right Join  (cost=4255.07..4279.38 rows=488 width=539) (actual time=4.901..5.493 rows=28 loops=1)"
"                                                  Hash Cond: (actions1_.task_id = taskentity0_.id)"
"                                                  ->  Hash Left Join  (cost=1.14..20.69 rows=545 width=165) (actual time=0.039..0.579 rows=546 loops=1)"
"                                                        Hash Cond: (actions1_.id = tags9_.action_id)"
"                                                        ->  Seq Scan on task_mgt_action actions1_  (cost=0.00..17.45 rows=545 width=149) (actual time=0.007..0.122 rows=545 loops=1)"
"                                                        ->  Hash  (cost=1.06..1.06 rows=6 width=16) (actual time=0.011..0.011 rows=6 loops=1)"
"                                                              Buckets: 1024  Batches: 1  Memory Usage: 9kB"
"                                                              ->  Seq Scan on task_mgt_tag_to_action tags9_  (cost=0.00..1.06 rows=6 width=16) (actual time=0.004..0.005 rows=6 loops=1)"
"                                                  ->  Hash  (cost=4247.83..4247.83 rows=488 width=374) (actual time=4.753..4.753 rows=18 loops=1)"
"                                                        Buckets: 1024  Batches: 1  Memory Usage: 13kB"
"                                                        ->  Hash Left Join  (cost=10.13..4247.83 rows=488 width=374) (actual time=0.810..4.720 rows=18 loops=1)"
"                                                              Hash Cond: (taskentity0_.id = comments2_.task_id)"
"                                                              ->  Seq Scan on task_mgt_task taskentity0_  (cost=0.00..4226.80 rows=488 width=249) (actual time=0.424..4.306 rows=18 loops=1)"
"                                                                    Filter: (NOT (SubPlan 2))"
"                                                                    Rows Removed by Filter: 958"
"                                                                    SubPlan 2"
"                                                                      ->  Index Only Scan using task_mgt_tag_to_task_idx on task_mgt_tag_to_task tags14_  (cost=0.28..8.29 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=976)"
"                                                                            Index Cond: (task_id = taskentity0_.id)"
"                                                                            Heap Fetches: 1204"
"                                                              ->  Hash  (cost=7.28..7.28 rows=228 width=125) (actual time=0.357..0.357 rows=228 loops=1)"
"                                                                    Buckets: 1024  Batches: 1  Memory Usage: 45kB"
"                                                                    ->  Seq Scan on task_mgt_task_comment comments2_  (cost=0.00..7.28 rows=228 width=125) (actual time=0.009..0.145 rows=228 loops=1)"
"                                            ->  Hash  (cost=6.96..6.96 rows=63 width=153) (actual time=0.248..0.248 rows=63 loops=1)"
"                                                  Buckets: 1024  Batches: 1  Memory Usage: 14kB"
"                                                  ->  Hash Left Join  (cost=4.83..6.96 rows=63 width=153) (actual time=0.126..0.202 rows=63 loops=1)"
"                                                        Hash Cond: (taskmanage10_.id = children12_.parent_id)"
"                                                        ->  Hash Right Join  (cost=2.42..4.29 rows=63 width=102) (actual time=0.090..0.123 rows=63 loops=1)"
"                                                              Hash Cond: (taskmanage11_.id = taskmanage10_.parent_id)"
"                                                              ->  Seq Scan on task_mgt_tag taskmanage11_  (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.012 rows=63 loops=1)"
"                                                              ->  Hash  (cost=1.63..1.63 rows=63 width=51) (actual time=0.043..0.043 rows=63 loops=1)"
"                                                                    Buckets: 1024  Batches: 1  Memory Usage: 13kB"
"                                                                    ->  Seq Scan on task_mgt_tag taskmanage10_  (cost=0.00..1.63 rows=63 width=51) (actual time=0.005..0.015 rows=63 loops=1)"
"                                                        ->  Hash  (cost=1.63..1.63 rows=63 width=51) (actual time=0.020..0.020 rows=0 loops=1)"
"                                                              Buckets: 1024  Batches: 1  Memory Usage: 8kB"
"                                                              ->  Seq Scan on task_mgt_tag children12_  (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.012 rows=63 loops=1)"
"                          ->  Hash  (cost=5.63..5.63 rows=8 width=8) (actual time=0.172..0.172 rows=8 loops=1)"
"                                Buckets: 1024  Batches: 1  Memory Usage: 9kB"
"                                ->  HashAggregate  (cost=5.55..5.63 rows=8 width=8) (actual time=0.159..0.163 rows=8 loops=1)"
"                                      Group Key: project16_.business_id"
"                                      ->  Hash Join  (cost=2.12..5.53 rows=8 width=8) (actual time=0.113..0.148 rows=8 loops=1)"
"                                            Hash Cond: (projectmem15_.project_id = project16_.id)"
"                                            ->  Seq Scan on task_mgt_project_member projectmem15_  (cost=0.00..3.30 rows=8 width=8) (actual time=0.026..0.055 rows=8 loops=1)"
"                                                  Filter: ((user_id)::text = 'b976d6f8-a036-4898-84ef-b6e33ac4dd98'::text)"
"                                                  Rows Removed by Filter: 96"
"                                            ->  Hash  (cost=1.50..1.50 rows=50 width=16) (actual time=0.063..0.063 rows=50 loops=1)"
"                                                  Buckets: 1024  Batches: 1  Memory Usage: 11kB"
"                                                  ->  Seq Scan on task_mgt_project project16_  (cost=0.00..1.50 rows=50 width=16) (actual time=0.007..0.027 rows=50 loops=1)"
"                    ->  Hash  (cost=1.19..1.19 rows=19 width=1056) (actual time=0.022..0.022 rows=19 loops=1)"
"                          Buckets: 1024  Batches: 1  Memory Usage: 10kB"
"                          ->  Seq Scan on task_mgt_checklist_item checklisti3_  (cost=0.00..1.19 rows=19 width=1056) (actual time=0.004..0.010 rows=19 loops=1)"
"              ->  Hash  (cost=50.40..50.40 rows=1459 width=169) (actual time=2.374..2.374 rows=1459 loops=1)"
"                    Buckets: 2048  Batches: 1  Memory Usage: 153kB"
"                    ->  Hash Left Join  (cost=7.74..50.40 rows=1459 width=169) (actual time=0.226..1.589 rows=1459 loops=1)"
"                          Hash Cond: (tags4_.tag_id = taskmanage5_.id)"
"                          ->  Seq Scan on task_mgt_tag_to_task tags4_  (cost=0.00..22.59 rows=1459 width=16) (actual time=0.007..0.223 rows=1459 loops=1)"
"                          ->  Hash  (cost=6.96..6.96 rows=63 width=153) (actual time=0.202..0.202 rows=63 loops=1)"
"                                Buckets: 1024  Batches: 1  Memory Usage: 14kB"
"                                ->  Hash Left Join  (cost=4.83..6.96 rows=63 width=153) (actual time=0.110..0.169 rows=63 loops=1)"
"                                      Hash Cond: (taskmanage5_.id = children7_.parent_id)"
"                                      ->  Hash Right Join  (cost=2.42..4.29 rows=63 width=102) (actual time=0.080..0.105 rows=63 loops=1)"
"                                            Hash Cond: (taskmanage6_.id = taskmanage5_.parent_id)"
"                                            ->  Seq Scan on task_mgt_tag taskmanage6_  (cost=0.00..1.63 rows=63 width=51) (actual time=0.003..0.010 rows=63 loops=1)"
"                                            ->  Hash  (cost=1.63..1.63 rows=63 width=51) (actual time=0.043..0.043 rows=63 loops=1)"
"                                                  Buckets: 1024  Batches: 1  Memory Usage: 13kB"
"                                                  ->  Seq Scan on task_mgt_tag taskmanage5_  (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.013 rows=63 loops=1)"
"                                      ->  Hash  (cost=1.63..1.63 rows=63 width=51) (actual time=0.015..0.015 rows=0 loops=1)"
"                                            Buckets: 1024  Batches: 1  Memory Usage: 8kB"
"                                            ->  Seq Scan on task_mgt_tag children7_  (cost=0.00..1.63 rows=63 width=51) (actual time=0.003..0.009 rows=63 loops=1)"

Per node type stats

node type	count	sum of times	% of query
Hash	14	1.292 ms	8.8 %
Hash Join	2	0.078 ms	0.5 %
Hash Left Join	8	1.939 ms	13.2 %
Hash Right Join	4	3.341 ms	22.8 %
HashAggregate	1	0.015 ms	0.1 %
Index Only Scan	1	2.928 ms	20.0 %
Seq Scan	16	4.756 ms	32.4 %
Sort	1	0.306 ms	2.1 %
Unique	1	0.019 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
task_mgt_action	1	0.122 ms	0.8 %
Seq Scan	1	0.122 ms	100.0 %
task_mgt_action_comment	1	2.696 ms	18.4 %
Seq Scan	1	2.696 ms	100.0 %
task_mgt_checklist_item	1	0.010 ms	0.1 %
Seq Scan	1	0.010 ms	100.0 %
task_mgt_project	1	0.027 ms	0.2 %
Seq Scan	1	0.027 ms	100.0 %
task_mgt_project_member	1	0.055 ms	0.4 %
Seq Scan	1	0.055 ms	100.0 %
task_mgt_tag	7	0.095 ms	0.6 %
Seq Scan	7	0.095 ms	100.0 %
task_mgt_tag_to_action	1	0.005 ms	0.0 %
Seq Scan	1	0.005 ms	100.0 %
task_mgt_tag_to_task	2	3.151 ms	21.5 %
Index Only Scan	1	2.928 ms	92.9 %
Seq Scan	1	0.223 ms	7.1 %
task_mgt_task	1	1.378 ms	9.4 %
Seq Scan	1	1.378 ms	100.0 %
task_mgt_task_comment	1	0.145 ms	1.0 %
Seq Scan	1	0.145 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6107

Color mode:

Visible columns:

Per node type stats

Per table stats