explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VQhg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=311,181.19..311,181.21 rows=10 width=9,370) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=311,181.19..311,726.01 rows=217,930 width=9,370) (actual rows= loops=)

  • Sort Key: db_experiment.updated_at DESC
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=975.14..306,471.80 rows=217,930 width=9,370) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=974.72..111,194.47 rows=217,930 width=9,261) (actual rows= loops=)

  • Hash Cond: (t2.user_id = t5.id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=963.59..108,186.81 rows=217,930 width=7,734) (actual rows= loops=)

  • Hash Cond: (t2.project_id = db_project.id)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=954.40..106,270.73 rows=217,930 width=5,759) (actual rows= loops=)

  • Hash Cond: (t2.experiment_group_id = db_experimentgroup.id)
7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=931.69..103,453.46 rows=217,930 width=2,250) (actual rows= loops=)

  • Merge Cond: (db_experiment.original_experiment_id = t2.id)
8. 0.000 0.000 ↓ 0.0

Index Scan using db_experiment_original_experiment_id_66363822 on db_experiment (cost=0.42..69,573.92 rows=217,930 width=1,125) (actual rows= loops=)

  • Filter: (NOT deleted)
9. 0.000 0.000 ↓ 0.0

Index Scan using db_experiment_pkey on db_experiment t2 (cost=0.42..32,765.64 rows=223,679 width=1,125) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=22.10..22.10 rows=49 width=3,509) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=9.19..22.10 rows=49 width=3,509) (actual rows= loops=)

  • Hash Cond: (db_experimentgroup.project_id = t7.id)
12. 0.000 0.000 ↓ 0.0

Seq Scan on db_experimentgroup (cost=0.00..12.49 rows=49 width=1,534) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=9.18..9.18 rows=1 width=1,975) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.14..9.18 rows=1 width=1,975) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on db_project t7 (cost=0.00..1.01 rows=1 width=448) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Scan using db_user_pkey on db_user t8 (cost=0.14..8.16 rows=1 width=1,527) (actual rows= loops=)

  • Index Cond: (t7.user_id = id)
17. 0.000 0.000 ↓ 0.0

Hash (cost=9.18..9.18 rows=1 width=1,975) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.14..9.18 rows=1 width=1,975) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on db_project (cost=0.00..1.01 rows=1 width=448) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using db_user_pkey on db_user (cost=0.14..8.16 rows=1 width=1,527) (actual rows= loops=)

  • Index Cond: (db_project.user_id = id)
21. 0.000 0.000 ↓ 0.0

Hash (cost=10.50..10.50 rows=50 width=1,527) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on db_user t5 (cost=0.00..10.50 rows=50 width=1,527) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using db_experimentstatus_pkey on db_experimentstatus (cost=0.42..0.89 rows=1 width=109) (actual rows= loops=)

  • Index Cond: (db_experiment.status_id = id)