explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AA8c

Settings
# exclusive inclusive rows x rows loops node
1. 276.095 3,685.549 ↓ 25.2 2,668,065 1

Nested Loop (cost=20,757.06..1,552,335.62 rows=105,692 width=4) (actual time=820.357..3,685.549 rows=2,668,065 loops=1)

2. 0.081 0.081 ↑ 1.0 1 1

Index Scan using uniq_tag_name on tag (cost=0.27..8.29 rows=1 width=4) (actual time=0.077..0.081 rows=1 loops=1)

  • Index Cond: (name = 'Complaint'::text)
3. 2,721.280 3,409.373 ↓ 11.4 2,668,065 1

Bitmap Heap Scan on tag_instance (cost=20,756.79..1,549,986.26 rows=234,107 width=8) (actual time=820.276..3,409.373 rows=2,668,065 loops=1)

  • Recheck Cond: ((tag_id = tag.id) AND (tagger_type = 'annotate'::tag_instance_tagger_type))
  • Filter: (positive AND (target_class = 'docket_entry'::tag_instance_target_class))
  • Rows Removed by Filter: 2856092
  • Heap Blocks: exact=350103
4. 688.093 688.093 ↓ 8.5 5,738,729 1

Bitmap Index Scan on tag_instance_tag_id_tagger_type_idx (cost=0.00..20,698.26 rows=672,169 width=0) (actual time=688.093..688.093 rows=5,738,729 loops=1)

  • Index Cond: ((tag_id = tag.id) AND (tagger_type = 'annotate'::tag_instance_tagger_type))
Planning time : 2.463 ms
Execution time : 3,814.527 ms