explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DokS

Settings
# exclusive inclusive rows x rows loops node
1. 1.602 7,975.778 ↑ 25.9 7 1

GroupAggregate (cost=1.27..20,563.90 rows=181 width=70) (actual time=865.194..7,975.778 rows=7 loops=1)

  • Group Key: cv.name
2. 10.775 7,974.176 ↓ 21.2 3,842 1

Nested Loop (cost=1.27..20,561.18 rows=181 width=70) (actual time=142.115..7,974.176 rows=3,842 loops=1)

3. 5.415 7,063.328 ↓ 2.2 21,953 1

Nested Loop (cost=0.84..15,805.62 rows=10,009 width=70) (actual time=5.397..7,063.328 rows=21,953 loops=1)

4. 13.136 13.136 ↓ 1.1 531 1

Index Scan using ""unique-custom_field_value-custom_field_id-name"" on custom_field_value cv (cost=0.42..368.20 rows=468 width=70) (actual time=0.043..13.136 rows=531 loops=1)

  • Index Cond: (custom_field_id = 29)
5. 7,044.777 7,044.777 ↑ 3.9 41 531

Index Scan using ""test_case_custom_field-custom_field_value"" on test_case_custom_field tcf (cost=0.43..31.40 rows=159 width=16) (actual time=1.152..13.267 rows=41 loops=531)

  • Index Cond: (custom_field_value_id = cv.id)
6. 900.073 900.073 ↓ 0.0 0 21,953

Index Scan using test_case_pkey on test_case tc (cost=0.42..0.48 rows=1 width=8) (actual time=0.041..0.041 rows=0 loops=21,953)

  • Index Cond: (id = tcf.test_case_id)
  • Filter: (project_id = 21)
  • Rows Removed by Filter: 1
Planning time : 0.415 ms