explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TtPt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=4,810.95..3,866,827.07 rows=2,388 width=65) (actual rows= loops=)

  • Workers Planned: 1
2. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on annotations_taskset (cost=3,810.95..3,865,588.27 rows=1,405 width=65) (actual rows= loops=)

  • Recheck Cond: (definition_id = '8b0b136b-a52e-4025-830d-95167740e582'::uuid)
  • Filter: ((NOT fully_annotated) AND ((NOT (SubPlan 1)) OR (NOT (hashed SubPlan 2))))
3. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=2,105.24..2,105.24 rows=3,184 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on annotations_taskset_definition_id_bb851df5 (cost=0.00..159.14 rows=5,163 width=0) (actual rows= loops=)

  • Index Cond: (definition_id = '8b0b136b-a52e-4025-830d-95167740e582'::uuid)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on annotations_taskset_fully_annotated_037d23f1 (cost=0.00..1,944.65 rows=81,631 width=0) (actual rows= loops=)

  • Index Cond: (fully_annotated = false)
6.          

SubPlan (forParallel Bitmap Heap Scan)

7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..3,842.96 rows=111,590 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on annotations_task u1 (cost=0.00..2,740.01 rows=111,590 width=16) (actual rows= loops=)

  • Filter: ((status)::text = 'done'::text)
9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on annotations_task u1_1 (cost=255.20..1,685.46 rows=8,101 width=16) (actual rows= loops=)

  • Recheck Cond: (annotator_id = 24)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on annotations_task_annotator_id_255473fd (cost=0.00..253.17 rows=8,101 width=0) (actual rows= loops=)

  • Index Cond: (annotator_id = 24)