explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q3Yj

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 5.923 ↑ 1.0 11 1

Limit (cost=0.71..2,468.54 rows=11 width=47) (actual time=0.450..5.923 rows=11 loops=1)

2. 0.056 5.913 ↑ 29.4 11 1

Merge Join (cost=0.71..72,465.15 rows=323 width=47) (actual time=0.449..5.913 rows=11 loops=1)

  • Merge Cond: (clip_smart_tag.smart_tag_id = smart_tag.id)
3. 0.816 5.618 ↑ 28.6 203 1

Unique (cost=0.42..70,330.51 rows=5,806 width=16) (actual time=0.021..5.618 rows=203 loops=1)

4. 4.802 4.802 ↑ 196.7 3,516 1

Index Scan using clip_smart_tag_id_index on clip_smart_tag (cost=0.42..68,601.55 rows=691,587 width=16) (actual time=0.019..4.802 rows=3,516 loops=1)

  • Filter: (confidence > '88'::numeric)
  • Rows Removed by Filter: 1,582
5. 0.239 0.239 ↑ 114.2 12 1

Index Scan using smart_tag_id_index on smart_tag (cost=0.29..2,055.40 rows=1,371 width=47) (actual time=0.044..0.239 rows=12 loops=1)

  • Filter: (workspace_id = 'f2be74b6-d027-4fd3-8047-4a2b99cfe6fa'::uuid)
  • Rows Removed by Filter: 241