explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PK5U

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 171.036 ↑ 1.0 11 1

Limit (cost=0.98..87,830.39 rows=11 width=48) (actual time=31.720..171.036 rows=11 loops=1)

2. 0.115 171.029 ↑ 11.6 11 1

Merge Join (cost=0.98..1,022,015.93 rows=128 width=48) (actual time=31.719..171.029 rows=11 loops=1)

  • Merge Cond: (clip_smart_tag.smart_tag_id = smart_tag.id)
3. 3.326 169.883 ↑ 10.2 720 1

Unique (cost=0.56..1,007,100.20 rows=7,345 width=16) (actual time=7.456..169.883 rows=720 loops=1)

4. 166.557 166.557 ↑ 182.5 57,220 1

Index Scan using clip_smart_tag_id_index on clip_smart_tag (cost=0.56..980,999.30 rows=10,440,361 width=16) (actual time=7.454..166.557 rows=57,220 loops=1)

  • Filter: (confidence > '88'::numeric)
  • Rows Removed by Filter: 16134
5. 1.031 1.031 ↑ 160.0 14 1

Index Scan using smart_tag_pkey on smart_tag (cost=0.42..14,817.04 rows=2,240 width=48) (actual time=0.279..1.031 rows=14 loops=1)

  • Filter: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
  • Rows Removed by Filter: 853
Planning time : 0.668 ms