explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dpor

Settings
# exclusive inclusive rows x rows loops node
1. 0.904 531.118 ↓ 3.5 1,116 1

Sort (cost=23,304.45..23,305.26 rows=323 width=47) (actual time=530.860..531.118 rows=1,116 loops=1)

  • Sort Key: smart_tag.last_used DESC, smart_tag.id DESC
  • Sort Method: quicksort Memory: 160kB
2. 5.385 530.214 ↓ 3.5 1,116 1

Hash Join (cost=23,149.87..23,290.99 rows=323 width=47) (actual time=518.460..530.214 rows=1,116 loops=1)

  • Hash Cond: (clip_smart_tag.smart_tag_id = smart_tag.id)
3. 234.033 523.572 ↓ 3.3 19,375 1

HashAggregate (cost=22,719.56..22,777.62 rows=5,806 width=16) (actual time=517.162..523.572 rows=19,375 loops=1)

  • Group Key: clip_smart_tag.smart_tag_id
4. 289.539 289.539 ↑ 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..289.539 rows=689,036 loops=1)

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

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

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

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

  • Recheck Cond: (workspace_id = 'f2be74b6-d027-4fd3-8047-4a2b99cfe6fa'::uuid)
  • Heap Blocks: exact=128
7. 0.139 0.139 ↓ 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.139..0.139 rows=1,374 loops=1)

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