#	exclusive	inclusive	rows x	rows	loops	node
1.	0.678	516.856	↑ 1.0	753	1	→ Sort (cost=8,667.12..8,669.01 rows=757 width=99) (actual time=516.763..516.856 rows=753 loops=1) Sort Key: (count(post.id)) DESC Sort Method: quicksort Memory: 161kB
2.	241.230	516.178	↑ 1.0	753	1	→ HashAggregate (cost=8,623.35..8,630.92 rows=757 width=99) (actual time=515.895..516.178 rows=753 loops=1) Group Key: card.id
3.	224.151	274.948	↓ 4.6	890,723	1	→ Hash Join (cost=4,496.83..7,663.30 rows=192,010 width=95) (actual time=26.920..274.948 rows=890,723 loops=1) Hash Cond: (post_to_tag_link_1.tag_id = tag.id)
4.	19.062	47.061	↑ 1.0	32,633	1	→ Hash Join (cost=4,385.07..5,305.10 rows=32,633 width=8) (actual time=23.136..47.061 rows=32,633 loops=1) Hash Cond: (post_to_tag_link_1.post_id = post.id)
5.	5.177	5.177	↑ 1.0	32,633	1	→ Seq Scan on post_to_tag_link post_to_tag_link_1 (cost=0.00..471.33 rows=32,633 width=8) (actual time=0.022..5.177 rows=32,633 loops=1)
6.	9.217	22.822	↑ 1.0	24,492	1	→ Hash (cost=4,078.92..4,078.92 rows=24,492 width=4) (actual time=22.822..22.822 rows=24,492 loops=1) Buckets: 32768 Batches: 1 Memory Usage: 1118kB
7.	13.605	13.605	↑ 1.0	24,492	1	→ Seq Scan on post (cost=0.00..4,078.92 rows=24,492 width=4) (actual time=0.011..13.605 rows=24,492 loops=1)
8.	0.848	3.736	↑ 1.0	1,318	1	→ Hash (cost=95.29..95.29 rows=1,318 width=99) (actual time=3.735..3.736 rows=1,318 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 196kB
9.	0.748	2.888	↑ 1.0	1,318	1	→ Hash Join (cost=40.07..95.29 rows=1,318 width=99) (actual time=1.041..2.888 rows=1,318 loops=1) Hash Cond: (card_to_tag_link_1.tag_id = tag.id)
10.	0.875	1.962	↑ 1.0	1,318	1	→ Hash Join (cost=30.03..67.12 rows=1,318 width=95) (actual time=0.840..1.962 rows=1,318 loops=1) Hash Cond: (card_to_tag_link_1.card_id = card.id)
11.	0.294	0.294	↑ 1.0	1,318	1	→ Seq Scan on card_to_tag_link card_to_tag_link_1 (cost=0.00..19.18 rows=1,318 width=8) (actual time=0.015..0.294 rows=1,318 loops=1)
12.	0.480	0.793	↑ 1.0	757	1	→ Hash (cost=20.57..20.57 rows=757 width=91) (actual time=0.793..0.793 rows=757 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 104kB
13.	0.313	0.313	↑ 1.0	757	1	→ Seq Scan on card (cost=0.00..20.57 rows=757 width=91) (actual time=0.012..0.313 rows=757 loops=1)
14.	0.098	0.178	↑ 1.0	224	1	→ Hash (cost=7.24..7.24 rows=224 width=4) (actual time=0.178..0.178 rows=224 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 16kB
15.	0.080	0.080	↑ 1.0	224	1	→ Seq Scan on tag (cost=0.00..7.24 rows=224 width=4) (actual time=0.015..0.080 rows=224 loops=1)

"Sort  (cost=8667.12..8669.01 rows=757 width=99) (actual time=516.763..516.856 rows=753 loops=1)"
"  Sort Key: (count(post.id)) DESC"
"  Sort Method: quicksort  Memory: 161kB"
"  ->  HashAggregate  (cost=8623.35..8630.92 rows=757 width=99) (actual time=515.895..516.178 rows=753 loops=1)"
"        Group Key: card.id"
"        ->  Hash Join  (cost=4496.83..7663.30 rows=192010 width=95) (actual time=26.920..274.948 rows=890723 loops=1)"
"              Hash Cond: (post_to_tag_link_1.tag_id = tag.id)"
"              ->  Hash Join  (cost=4385.07..5305.10 rows=32633 width=8) (actual time=23.136..47.061 rows=32633 loops=1)"
"                    Hash Cond: (post_to_tag_link_1.post_id = post.id)"
"                    ->  Seq Scan on post_to_tag_link post_to_tag_link_1  (cost=0.00..471.33 rows=32633 width=8) (actual time=0.022..5.177 rows=32633 loops=1)"
"                    ->  Hash  (cost=4078.92..4078.92 rows=24492 width=4) (actual time=22.822..22.822 rows=24492 loops=1)"
"                          Buckets: 32768  Batches: 1  Memory Usage: 1118kB"
"                          ->  Seq Scan on post  (cost=0.00..4078.92 rows=24492 width=4) (actual time=0.011..13.605 rows=24492 loops=1)"
"              ->  Hash  (cost=95.29..95.29 rows=1318 width=99) (actual time=3.735..3.736 rows=1318 loops=1)"
"                    Buckets: 2048  Batches: 1  Memory Usage: 196kB"
"                    ->  Hash Join  (cost=40.07..95.29 rows=1318 width=99) (actual time=1.041..2.888 rows=1318 loops=1)"
"                          Hash Cond: (card_to_tag_link_1.tag_id = tag.id)"
"                          ->  Hash Join  (cost=30.03..67.12 rows=1318 width=95) (actual time=0.840..1.962 rows=1318 loops=1)"
"                                Hash Cond: (card_to_tag_link_1.card_id = card.id)"
"                                ->  Seq Scan on card_to_tag_link card_to_tag_link_1  (cost=0.00..19.18 rows=1318 width=8) (actual time=0.015..0.294 rows=1318 loops=1)"
"                                ->  Hash  (cost=20.57..20.57 rows=757 width=91) (actual time=0.793..0.793 rows=757 loops=1)"
"                                      Buckets: 1024  Batches: 1  Memory Usage: 104kB"
"                                      ->  Seq Scan on card  (cost=0.00..20.57 rows=757 width=91) (actual time=0.012..0.313 rows=757 loops=1)"
"                          ->  Hash  (cost=7.24..7.24 rows=224 width=4) (actual time=0.178..0.178 rows=224 loops=1)"
"                                Buckets: 1024  Batches: 1  Memory Usage: 16kB"
"                                ->  Seq Scan on tag  (cost=0.00..7.24 rows=224 width=4) (actual time=0.015..0.080 rows=224 loops=1)"
"Planning time: 2.145 ms"
"Execution time: 517.102 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	4	10.643 ms	2.1 %
Hash Join	4	244.836 ms	47.4 %
HashAggregate	1	241.230 ms	46.7 %
Seq Scan	5	19.469 ms	3.8 %
Sort	1	0.678 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
card	1	0.313 ms	0.1 %
Seq Scan	1	0.313 ms	100.0 %
card_to_tag_link	1	0.294 ms	0.1 %
Seq Scan	1	0.294 ms	100.0 %
post	1	13.605 ms	2.6 %
Seq Scan	1	13.605 ms	100.0 %
post_to_tag_link	1	5.177 ms	1.0 %
Seq Scan	1	5.177 ms	100.0 %
tag	1	0.080 ms	0.0 %
Seq Scan	1	0.080 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 91rs

Color mode:

Visible columns:

Per node type stats

Per table stats