explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lGtK

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 648.985 ↑ 1.0 11 1

Limit (cost=23,843.54..23,843.57 rows=11 width=47) (actual time=648.973..648.985 rows=11 loops=1)

2. 0.389 648.975 ↑ 29.4 11 1

Sort (cost=23,843.54..23,844.35 rows=323 width=47) (actual time=648.971..648.975 rows=11 loops=1)

  • Sort Key: smart_tag.last_used DESC, smart_tag.id DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 5.657 648.586 ↓ 3.5 1,116 1

Hash Join (cost=23,695.22..23,836.34 rows=323 width=47) (actual time=632.671..648.586 rows=1,116 loops=1)

  • Hash Cond: (clip_smart_tag.smart_tag_id = smart_tag.id)
4. 426.121 641.668 ↓ 3.3 19,375 1

HashAggregate (cost=23,264.91..23,322.97 rows=5,806 width=16) (actual time=631.350..641.668 rows=19,375 loops=1)

  • Group Key: clip_smart_tag.smart_tag_id
  • Filter: (max(clip_smart_tag.confidence) > '88'::numeric)
  • Rows Removed by Filter: 5219
5. 215.547 215.547 ↑ 1.0 909,727 1

Seq Scan on clip_smart_tag (cost=0.00..18,716.27 rows=909,727 width=28) (actual time=0.005..215.547 rows=909,727 loops=1)

6. 0.505 1.261 ↑ 1.0 1,371 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 128kB
7. 0.619 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.155..0.756 rows=1,371 loops=1)

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

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