explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lMDe

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 3 1

Merge Join (cost=0..0 rows=0 width=0) (actual rows=3 loops=1)

2. 0.000 0.000 ↓ 0.0 3 1

Index Scan using ix_positive_lex_case_tags_tag_id on positive_lex_case_tags positive_lex_case_tags (cost=0..0 rows=0 width=0) (actual rows=3 loops=1)

  • Filter: ((lex_case_id)::integer = 2003018468)
3. 0.000 0.000 ↓ 0.0 462 1

Sort (cost=0..0 rows=0 width=0) (actual rows=462 loops=1)

  • Sort Key: tag.id
  • Sort Method: quicksort Memory: 58kB
4. 0.000 0.000 ↓ 0.0 462 1

Seq Scan on tag tag (cost=0..0 rows=0 width=0) (actual rows=462 loops=1)