explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vs3E

Settings
# exclusive inclusive rows x rows loops node
1. 22.721 53.602 ↑ 25.7 21,253 1

Subquery Scan on foo (cost=312.33..29,736.13 rows=545,500 width=1,479) (actual time=3.020..53.602 rows=21,253 loops=1)

2. 28.256 30.881 ↑ 25.7 21,253 1

Bitmap Heap Scan on survey_responses (cost=312.33..12,007.38 rows=545,500 width=1,447) (actual time=3.009..30.881 rows=21,253 loops=1)

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

Bitmap Index Scan on ix_survey_responses_tenant_key_template_id (cost=0.00..310.97 rows=5,455 width=0) (actual time=2.625..2.625 rows=18,518 loops=1)

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