explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IN6x

Settings
# exclusive inclusive rows x rows loops node
1. 22.427 53.197 ↑ 27.1 21,253 1

Subquery Scan on foo (cost=467.40..31,203.98 rows=575,400 width=1,479) (actual time=3.429..53.197 rows=21,253 loops=1)

2. 27.715 30.770 ↑ 27.1 21,253 1

Bitmap Heap Scan on survey_responses (cost=467.40..12,503.48 rows=575,400 width=1,447) (actual time=3.418..30.770 rows=21,253 loops=1)

  • Recheck Cond: (((tenant_key)::text = '48a63f3aad918e97028ef9e0b8e828c2403a50a3781500b46e04236e03d755f7'::text) AND ((template_id)::text = '198'::text))
  • Heap Blocks: exact=2665
3. 3.055 3.055 ↓ 3.2 18,518 1

Bitmap Index Scan on ix_survey_responses_tenant_key_template_id_survey_question_id (cost=0.00..465.96 rows=5,754 width=0) (actual time=3.055..3.055 rows=18,518 loops=1)

  • Index Cond: (((tenant_key)::text = '48a63f3aad918e97028ef9e0b8e828c2403a50a3781500b46e04236e03d755f7'::text) AND ((template_id)::text = '198'::text))