explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rE5p

Settings
# exclusive inclusive rows x rows loops node
1. 2.028 51.410 ↓ 1.0 6,131 1

Hash Left Join (cost=2,296.10..34,364.61 rows=6,012 width=1,459) (actual time=5.986..51.410 rows=6,131 loops=1)

  • Hash Cond: (test_case_version.last_updated_by_id = x18.id)
2. 2.490 48.845 ↓ 1.0 6,131 1

Hash Left Join (cost=2,210.86..34,263.57 rows=6,012 width=1,396) (actual time=5.425..48.845 rows=6,131 loops=1)

  • Hash Cond: (test_case_version.created_by_id = x19.id)
3. 8.614 45.588 ↓ 1.0 6,131 1

Nested Loop (cost=2,125.62..34,162.52 rows=6,012 width=1,349) (actual time=4.629..45.588 rows=6,131 loops=1)

4. 3.228 6.319 ↓ 1.1 6,131 1

HashAggregate (cost=2,125.20..2,183.38 rows=5,818 width=8) (actual time=4.589..6.319 rows=6,131 loops=1)

  • Group Key: test_case_version_ordered.test_case_version_id
5. 3.091 3.091 ↓ 1.0 6,131 1

Index Scan using test_case_version_ordered_test_plan_id_idx on test_case_version_ordered (cost=0.43..2,110.17 rows=6,012 width=8) (actual time=0.079..3.091 rows=6,131 loops=1)

  • Index Cond: (test_plan_id = 7,718,513)
6. 30.655 30.655 ↑ 1.0 1 6,131

Index Scan using test_case_version_pkey on test_case_version (cost=0.42..5.54 rows=1 width=1,349) (actual time=0.005..0.005 rows=1 loops=6,131)

  • Index Cond: (id = test_case_version_ordered.test_case_version_id)
7. 0.385 0.767 ↑ 1.0 2,544 1

Hash (cost=53.44..53.44 rows=2,544 width=47) (actual time=0.767..0.767 rows=2,544 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 210kB
8. 0.382 0.382 ↑ 1.0 2,544 1

Seq Scan on tcmt_user x19 (cost=0.00..53.44 rows=2,544 width=47) (actual time=0.019..0.382 rows=2,544 loops=1)

9. 0.362 0.537 ↑ 1.0 2,544 1

Hash (cost=53.44..53.44 rows=2,544 width=47) (actual time=0.537..0.537 rows=2,544 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 210kB
10. 0.175 0.175 ↑ 1.0 2,544 1

Seq Scan on tcmt_user x18 (cost=0.00..53.44 rows=2,544 width=47) (actual time=0.010..0.175 rows=2,544 loops=1)

Planning time : 2.279 ms
Execution time : 52.157 ms