explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YVoy

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

Limit (cost=25,257.44..25,257.46 rows=11 width=47) (actual time=506.510..506.521 rows=11 loops=1)

2. 19.512 506.512 ↑ 3,499.0 11 1

Sort (cost=25,257.44..25,353.66 rows=38,489 width=47) (actual time=506.508..506.512 rows=11 loops=1)

  • Sort Key: smart_tag.last_used DESC, smart_tag.id DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 201.565 487.000 ↓ 1.5 58,049 1

Hash Join (cost=430.31..24,399.24 rows=38,489 width=47) (actual time=1.268..487.000 rows=58,049 loops=1)

  • Hash Cond: (clip_smart_tag.smart_tag_id = smart_tag.id)
4. 284.200 284.200 ↑ 1.0 689,036 1

Seq Scan on clip_smart_tag (cost=0.00..20,990.59 rows=691,587 width=16) (actual time=0.010..284.200 rows=689,036 loops=1)

  • Filter: (confidence > '88'::numeric)
  • Rows Removed by Filter: 220691
5. 0.486 1.235 ↑ 1.0 1,371 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 128kB
6. 0.620 0.749 ↑ 1.0 1,371 1

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

  • Recheck Cond: (workspace_id = 'f2be74b6-d027-4fd3-8047-4a2b99cfe6fa'::uuid)
  • Heap Blocks: exact=128
7. 0.129 0.129 ↓ 1.0 1,374 1

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

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