explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K2RA

Settings
# 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