explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UAwR

Settings
# exclusive inclusive rows x rows loops node
1. 1,672.230 2,459.490 ↓ 1.5 1,973,986 1

HashAggregate (cost=193,103.23..206,651.85 rows=1,354,862 width=4) (actual time=1,763.963..2,459.490 rows=1,973,986 loops=1)

  • Group Key: positive_case_tags.case_id
2. 161.432 787.260 ↑ 1.1 2,041,973 1

Append (cost=0.00..187,688.52 rows=2,165,885 width=4) (actual time=117.538..787.260 rows=2,041,973 loops=1)

3. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on positive_case_tags (cost=0.00..0.00 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: ((tag_id <> 359) AND (tag_id = ANY ('{27,24,23,89,263,36,286,287,22,386,370,432,451,450,452,449}'::integer[])))
4. 521.115 625.819 ↑ 1.1 2,041,973 1

Bitmap Heap Scan on positve_case_tags (cost=39,776.79..176,859.09 rows=2,165,884 width=4) (actual time=117.527..625.819 rows=2,041,973 loops=1)

  • Recheck Cond: (tag_id = ANY ('{27,24,23,89,263,36,286,287,22,386,370,432,451,450,452,449}'::integer[]))
  • Heap Blocks: exact=58264
5. 104.704 104.704 ↑ 1.0 2,136,889 1

Bitmap Index Scan on ix_positve_case_tags_tag_id (cost=0.00..39,235.32 rows=2,216,040 width=0) (actual time=104.704..104.704 rows=2,136,889 loops=1)

  • Index Cond: (tag_id = ANY ('{27,24,23,89,263,36,286,287,22,386,370,432,451,450,452,449}'::integer[]))
Planning time : 0.357 ms
Execution time : 2,585.885 ms