explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vdya : Post index

Settings

Optimization path:

Optimization(s) for this plan:

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

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

2. 0.465 662.547 ↑ 29.4 11 1

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

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

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

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

HashAggregate (cost=23,264.91..23,322.97 rows=5,806 width=16) (actual time=638.078..651.217 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: 5,219
5. 217.325 217.325 ↑ 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.006..217.325 rows=909,727 loops=1)

6. 0.524 1.411 ↑ 1.0 1,371 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 128kB
7. 0.743 0.887 ↑ 1.0 1,371 1

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

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

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

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