#	exclusive	inclusive	rows x	rows	loops	node
1.	0.059	593.692	↑ 3,031.7	3	1	→ Merge Join (cost=33.34..2,235.48 rows=9,095 width=24) (actual time=317.863..593.692 rows=3 loops=1) Merge Cond: (positive_lex_case_tags.tag_id = tag.id)
2.	593.152	593.152	↑ 3,031.7	3	1	→ Index Scan using ix_positive_lex_case_tags_tag_id on positive_lex_case_tags (cost=0.43..96,852.51 rows=9,095 width=4) (actual time=317.351..593.152 rows=3 loops=1) Filter: ((lex_case_id)::integer = 2003018468) Rows Removed by Filter: 1828060
3.	0.286	0.481	↓ 1.0	462	1	→ Sort (cost=32.90..34.01 rows=443 width=24) (actual time=0.445..0.481 rows=462 loops=1) Sort Key: tag.id Sort Method: quicksort Memory: 58kB
4.	0.195	0.195	↓ 1.0	462	1	→ Seq Scan on tag (cost=0.00..13.43 rows=443 width=24) (actual time=0.013..0.195 rows=462 loops=1)

Planning time	:	2.292 ms
Execution time	:	593.771 ms

                                                                                QUERY PLAN                                                                                
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Merge Join  (cost=33.34..2235.48 rows=9095 width=24) (actual time=317.863..593.692 rows=3 loops=1)
   Merge Cond: (positive_lex_case_tags.tag_id = tag.id)
   ->  Index Scan using ix_positive_lex_case_tags_tag_id on positive_lex_case_tags  (cost=0.43..96852.51 rows=9095 width=4) (actual time=317.351..593.152 rows=3 loops=1)
         Filter: ((lex_case_id)::integer = 2003018468)
         Rows Removed by Filter: 1828060
   ->  Sort  (cost=32.90..34.01 rows=443 width=24) (actual time=0.445..0.481 rows=462 loops=1)
         Sort Key: tag.id
         Sort Method: quicksort  Memory: 58kB
         ->  Seq Scan on tag  (cost=0.00..13.43 rows=443 width=24) (actual time=0.013..0.195 rows=462 loops=1)
 Planning Time: 2.292 ms
 Execution Time: 593.771 ms
(11 rows)

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	593.152 ms	99.9 %
Merge Join	1	0.059 ms	0.0 %
Seq Scan	1	0.195 ms	0.0 %
Sort	1	0.286 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
positive_lex_case_tags	1	593.152 ms	99.9 %
Index Scan	1	593.152 ms	100.0 %
tag	1	0.195 ms	0.0 %
Seq Scan	1	0.195 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K2RA

Color mode:

Visible columns:

Per node type stats

Per table stats