explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aubp

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

Limit (cost=14,339.53..14,339.55 rows=11 width=47) (actual time=0.568..0.579 rows=11 loops=1)

2. 0.055 0.570 ↑ 76.5 11 1

Sort (cost=14,339.53..14,341.63 rows=842 width=47) (actual time=0.567..0.570 rows=11 loops=1)

  • Sort Key: smart_tag.last_used DESC, smart_tag.id DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.093 0.515 ↑ 8.3 102 1

Nested Loop (cost=6.04..14,320.75 rows=842 width=47) (actual time=0.036..0.515 rows=102 loops=1)

4. 0.058 0.058 ↓ 1.7 52 1

Index Scan using smart_tag_workspace_id_label_key on smart_tag (cost=0.41..118.79 rows=30 width=47) (actual time=0.013..0.058 rows=52 loops=1)

  • Index Cond: (workspace_id = 'c24ac576-3ddd-4c72-9511-2f6dc946abf5'::uuid)
5. 0.156 0.364 ↑ 59.5 2 52

Bitmap Heap Scan on clip_smart_tag (cost=5.63..472.21 rows=119 width=16) (actual time=0.006..0.007 rows=2 loops=52)

  • Recheck Cond: (smart_tag_id = smart_tag.id)
  • Filter: (confidence > '88'::numeric)
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=91
6. 0.208 0.208 ↑ 78.5 2 52

Bitmap Index Scan on clip_smart_tag_id_index (cost=0.00..5.60 rows=157 width=0) (actual time=0.004..0.004 rows=2 loops=52)

  • Index Cond: (smart_tag_id = smart_tag.id)