explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cjha

Settings
# exclusive inclusive rows x rows loops node
1. 1.405 3.760 ↓ 1.6 618 1

Sort (cost=184.07..185.07 rows=398 width=805) (actual time=3.745..3.76 rows=618 loops=1)

  • Sort Key: order0_.start_date, courses1_."position"
  • Sort Method: quicksort Memory: 568kB
2. 0.525 2.355 ↓ 1.6 618 1

Hash Join (cost=146.68..166.89 rows=398 width=805) (actual time=1.79..2.355 rows=618 loops=1)

3. 0.073 0.073 ↑ 1.0 744 1

Seq Scan on studying studyings2_ (cost=0..13.44 rows=744 width=60) (actual time=0.015..0.073 rows=744 loops=1)

4. 0.224 1.757 ↓ 1.3 253 1

Hash (cost=144.15..144.15 rows=202 width=713) (actual time=1.757..1.757 rows=253 loops=1)

5. 0.199 1.533 ↓ 1.3 253 1

Hash Join (cost=132.93..144.15 rows=202 width=713) (actual time=1.304..1.533 rows=253 loops=1)

6. 0.054 0.054 ↑ 1.0 378 1

Seq Scan on order_courses courses1_ (cost=0..7.78 rows=378 width=40) (actual time=0.014..0.054 rows=378 loops=1)

7. 0.036 1.280 ↑ 1.0 30 1

Hash (cost=132.56..132.56 rows=30 width=673) (actual time=1.28..1.28 rows=30 loops=1)

8. 0.030 1.244 ↑ 1.0 30 1

Hash Join (cost=83.01..132.56 rows=30 width=673) (actual time=1.019..1.244 rows=30 loops=1)

9. 0.025 0.564 ↑ 1.0 30 1

Hash Join (cost=26.6..76.07 rows=30 width=586) (actual time=0.353..0.564 rows=30 loops=1)

10. 0.074 0.506 ↑ 1.0 30 1

Hash Join (cost=25.35..74.73 rows=30 width=545) (actual time=0.305..0.506 rows=30 loops=1)

11. 0.121 0.409 ↑ 1.0 30 1

Hash Join (cost=23.77..73.05 rows=30 width=496) (actual time=0.218..0.409 rows=30 loops=1)

12. 0.104 0.104 ↓ 1.0 1,487 1

Seq Scan on users user5_ (cost=0..37.85 rows=1,485 width=87) (actual time=0.018..0.104 rows=1,487 loops=1)

13. 0.015 0.184 ↑ 1.0 30 1

Hash (cost=23.39..23.39 rows=30 width=409) (actual time=0.184..0.184 rows=30 loops=1)

14. 0.029 0.169 ↑ 1.0 30 1

Merge Join (cost=7.1..23.39 rows=30 width=409) (actual time=0.09..0.169 rows=30 loops=1)

15. 0.076 0.076 ↑ 4.6 325 1

Index Scan using users_pkey on users user7_ (cost=0.28..84.79 rows=1,485 width=87) (actual time=0.014..0.076 rows=325 loops=1)

16. 0.040 0.064 ↑ 1.0 30 1

Sort (cost=3.44..3.51 rows=30 width=322) (actual time=0.063..0.064 rows=30 loops=1)

  • Sort Key: order0_.expert_user_id
  • Sort Method: quicksort Memory: 33kB
17. 0.024 0.024 ↑ 1.0 30 1

Seq Scan on orders order0_ (cost=0..2.7 rows=30 width=322) (actual time=0.013..0.024 rows=30 loops=1)

  • Filter: (order0_.order_status_code = ANY ('{1,2}'::integer[]))
18. 0.011 0.023 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=49) (actual time=0.023..0.023 rows=26 loops=1)

19. 0.012 0.012 ↑ 1.0 26 1

Seq Scan on profiles profile3_ (cost=0..1.26 rows=26 width=49) (actual time=0.01..0.012 rows=26 loops=1)

20. 0.010 0.033 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=41) (actual time=0.033..0.033 rows=11 loops=1)

21. 0.023 0.023 ↑ 1.0 11 1

Seq Scan on specializations specializa4_ (cost=0..1.11 rows=11 width=41) (actual time=0.022..0.023 rows=11 loops=1)

22. 0.359 0.650 ↓ 1.0 1,487 1

Hash (cost=37.85..37.85 rows=1,485 width=87) (actual time=0.65..0.65 rows=1,487 loops=1)

23. 0.291 0.291 ↓ 1.0 1,487 1

Seq Scan on users user6_ (cost=0..37.85 rows=1,485 width=87) (actual time=0.009..0.291 rows=1,487 loops=1)