explain.depesz.com

PostgreSQL's explain analyze made readable

Result: enfU : select runs

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.145 ↑ 1.0 1 1

Aggregate (cost=51.39..51.40 rows=1 width=8) (actual time=0.145..0.145 rows=1 loops=1)

2. 0.005 0.123 ↑ 8.0 5 1

HashAggregate (cost=50.39..50.79 rows=40 width=12) (actual time=0.122..0.123 rows=5 loops=1)

  • Group Key: "user".user_id
3. 0.023 0.118 ↑ 18.6 7 1

Hash Right Join (cost=36.75..49.74 rows=130 width=8) (actual time=0.101..0.118 rows=7 loops=1)

  • Hash Cond: (project.owner_id = "user".user_id)
4. 0.025 0.077 ↑ 18.6 7 1

Hash Right Join (cost=25.85..38.49 rows=130 width=8) (actual time=0.067..0.077 rows=7 loops=1)

  • Hash Cond: (target.project_id = project.project_id)
5. 0.021 0.038 ↑ 18.6 7 1

Hash Right Join (cost=12.93..25.21 rows=130 width=8) (actual time=0.032..0.038 rows=7 loops=1)

  • Hash Cond: (run.target_id = target.target_id)
6. 0.006 0.006 ↑ 45.0 4 1

Seq Scan on run (cost=0.00..11.80 rows=180 width=8) (actual time=0.005..0.006 rows=4 loops=1)

7. 0.001 0.011 ↑ 26.0 5 1

Hash (cost=11.30..11.30 rows=130 width=8) (actual time=0.011..0.011 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.010 0.010 ↑ 26.0 5 1

Seq Scan on target (cost=0.00..11.30 rows=130 width=8) (actual time=0.008..0.010 rows=5 loops=1)

9. 0.001 0.014 ↑ 26.0 5 1

Hash (cost=11.30..11.30 rows=130 width=8) (actual time=0.014..0.014 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.013 0.013 ↑ 26.0 5 1

Seq Scan on project (cost=0.00..11.30 rows=130 width=8) (actual time=0.011..0.013 rows=5 loops=1)

11. 0.003 0.018 ↑ 8.0 5 1

Hash (cost=10.40..10.40 rows=40 width=4) (actual time=0.018..0.018 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.015 0.015 ↑ 8.0 5 1

Seq Scan on "user" (cost=0.00..10.40 rows=40 width=4) (actual time=0.013..0.015 rows=5 loops=1)

Planning time : 0.506 ms
Execution time : 0.260 ms