explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Qyy

Settings
# exclusive inclusive rows x rows loops node
1. 22.579 53.081 ↑ 25.7 21,253 1

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

2. 27.823 30.502 ↑ 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.052..30.502 rows=21,253 loops=1)

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

  • Index Cond: (((tenant_key)::text = '48a63f3aad918e97028ef9e0b8e828c2403a50a3781500b46e04236e03d755f7'::text) AND ((template_id)::text = '198'::text))
Planning time : 0.673 ms
Execution time : 53.815 ms