explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9M3b

Settings
# exclusive inclusive rows x rows loops node
1. 22.317 52.134 ↑ 25.7 21,253 1

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

2. 27.238 29.817 ↑ 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=2.936..29.817 rows=21,253 loops=1)

  • Recheck Cond: (((tenant_key)::text = '48a63f3aad918e97028ef9e0b8e828c2403a50a3781500b46e04236e03d755f7'::text) AND ((template_id)::text = '198'::text))
  • Heap Blocks: exact=2665
3. 2.579 2.579 ↓ 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.579..2.579 rows=18,518 loops=1)

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