explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fHny

Settings
# exclusive inclusive rows x rows loops node
1. 7.014 36.473 ↑ 4,453.8 4 1

HashAggregate (cost=14,242.77..14,420.92 rows=17,815 width=48) (actual time=36.436..36.473 rows=4 loops=1)

  • Group Key: COALESCE(environment_type, name), project_id
2. 29.459 29.459 ↓ 1.4 24,821 1

Index Scan using index_environments_on_project_id_and_state on environments (cost=0.42..14,061.60 rows=18,117 width=40) (actual time=0.034..29.459 rows=24,821 loops=1)

  • Index Cond: ((project_id = ANY ('{13083,278964}'::integer[])) AND ((state)::text = 'available'::text))
Planning time : 0.131 ms
Execution time : 36.650 ms