explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cugU

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 529.269 ↑ 1.0 11 1

Limit (cost=23,298.19..23,298.22 rows=11 width=47) (actual time=529.257..529.269 rows=11 loops=1)

2. 0.414 529.260 ↑ 29.4 11 1

Sort (cost=23,298.19..23,299.00 rows=323 width=47) (actual time=529.255..529.260 rows=11 loops=1)

  • Sort Key: smart_tag.last_used DESC, smart_tag.id DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 6.095 528.846 ↓ 3.5 1,119 1

Hash Join (cost=23,149.87..23,290.99 rows=323 width=47) (actual time=516.061..528.846 rows=1,119 loops=1)

  • Hash Cond: (clip_smart_tag.smart_tag_id = smart_tag.id)
4. 231.503 521.432 ↓ 3.3 19,380 1

HashAggregate (cost=22,719.56..22,777.62 rows=5,806 width=16) (actual time=514.677..521.432 rows=19,380 loops=1)

  • Group Key: clip_smart_tag.smart_tag_id
5. 289.929 289.929 ↑ 1.0 689,051 1

Seq Scan on clip_smart_tag (cost=0.00..20,990.59 rows=691,587 width=16) (actual time=0.012..289.929 rows=689,051 loops=1)

  • Filter: (confidence > '88'::numeric)
  • Rows Removed by Filter: 220691
6. 0.532 1.319 ↓ 1.0 1,374 1

Hash (cost=413.18..413.18 rows=1,371 width=47) (actual time=1.319..1.319 rows=1,374 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 128kB
7. 0.636 0.787 ↓ 1.0 1,374 1

Bitmap Heap Scan on smart_tag (cost=87.04..413.18 rows=1,371 width=47) (actual time=0.168..0.787 rows=1,374 loops=1)

  • Recheck Cond: (workspace_id = 'f2be74b6-d027-4fd3-8047-4a2b99cfe6fa'::uuid)
  • Heap Blocks: exact=129
8. 0.151 0.151 ↓ 1.0 1,389 1

Bitmap Index Scan on smart_tag_workspace_id_label_key (cost=0.00..86.69 rows=1,371 width=0) (actual time=0.150..0.151 rows=1,389 loops=1)

  • Index Cond: (workspace_id = 'f2be74b6-d027-4fd3-8047-4a2b99cfe6fa'::uuid)
Planning time : 0.257 ms