explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5bVe

Settings
# exclusive inclusive rows x rows loops node
1. 69.427 69.427 ↑ 1.0 1 1

Aggregate (cost=90,626.53..90,626.54 rows=1 width=8) (actual time=69.426..69.427 rows=1 loops=1)

  • -> Index Only Scan using survey_surv_instanc_c10ac7_idx on survey_surveytaker (cost=0.43..90016.94 rows=243,833 width=0) (act
  • Index Cond: ((instance_id = ANY ('{9828,9938,9995,10131,10288}'::integer[])) AND (complete = true))
  • Filter: complete
  • Heap Fetches: 65,722
Planning time : 0.115 ms
Execution time : 69.452 ms