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