explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I77

Settings
# exclusive inclusive rows x rows loops node
1. 0.117 15,645.727 ↑ 1.0 1 1

Sort (cost=973.94..973.95 rows=1 width=625) (actual time=15,645.726..15,645.727 rows=1 loops=1)

  • Sort Key: s.step
  • Sort Method: quicksort Memory: 26kB
2. 0.035 15,645.610 ↑ 1.0 1 1

Nested Loop (cost=343.53..973.93 rows=1 width=625) (actual time=47.441..15,645.610 rows=1 loops=1)

  • Join Filter: (c.id = p.container_settings_id)
  • Rows Removed by Join Filter: 18
3. 0.010 15,645.548 ↑ 1.0 1 1

Nested Loop (cost=343.53..972.51 rows=1 width=637) (actual time=47.423..15,645.548 rows=1 loops=1)

4. 0.012 15,645.520 ↑ 1.0 1 1

Nested Loop (cost=343.26..969.47 rows=1 width=555) (actual time=47.400..15,645.520 rows=1 loops=1)

5. 37.866 15,645.499 ↑ 1.0 1 1

Nested Loop (cost=342.98..969.15 rows=1 width=496) (actual time=47.384..15,645.499 rows=1 loops=1)

  • Join Filter: ((j.app_id)::text = ((a.id)::character varying)::text)
  • Rows Removed by Join Filter: 20261
6. 2.463 10.805 ↓ 614.0 614 1

Nested Loop (cost=0.69..285.91 rows=1 width=301) (actual time=1.946..10.805 rows=614 loops=1)

7. 0.115 0.115 ↑ 1.0 1 1

Index Scan using user_username_unique on users u (cost=0.41..8.43 rows=1 width=49) (actual time=0.113..0.115 rows=1 loops=1)

  • Index Cond: ((username)::text = 'ipctest@iplantcollaborative.org'::text)
8. 8.227 8.227 ↓ 5.0 614 1

Index Scan using jobs_user_id_index on jobs j (cost=0.28..276.26 rows=122 width=268) (actual time=1.815..8.227 rows=614 loops=1)

  • Index Cond: (user_id = u.id)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 958
9. 89.030 15,596.828 ↑ 4.2 33 614

Nested Loop (cost=342.29..680.82 rows=138 width=211) (actual time=24.594..25.402 rows=33 loops=614)

10. 7,861.606 15,406.488 ↑ 4.2 33 614

Hash Join (cost=342.01..624.13 rows=140 width=134) (actual time=24.583..25.092 rows=33 loops=614)

  • Hash Cond: (s.task_id = k.id)
11. 7,526.412 7,526.412 ↑ 1.0 10,871 614

Seq Scan on app_steps s (cost=0.00..239.35 rows=11,035 width=36) (actual time=0.004..12.258 rows=10,871 loops=614)

12. 0.076 18.470 ↑ 2.5 33 1

Hash (cost=340.99..340.99 rows=81 width=130) (actual time=18.470..18.470 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
13. 8.527 18.394 ↑ 2.5 33 1

Hash Join (cost=58.41..340.99 rows=81 width=130) (actual time=1.372..18.394 rows=33 loops=1)

  • Hash Cond: (k.tool_id = l.id)
14. 9.023 9.023 ↓ 1.0 6,319 1

Seq Scan on tasks k (cost=0.00..258.11 rows=6,311 width=32) (actual time=0.012..9.023 rows=6,319 loops=1)

15. 0.053 0.844 ↑ 1.0 19 1

Hash (cost=58.17..58.17 rows=19 width=98) (actual time=0.844..0.844 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
16. 0.791 0.791 ↑ 1.0 19 1

Seq Scan on tools l (cost=0.00..58.17 rows=19 width=98) (actual time=0.748..0.791 rows=19 loops=1)

  • Filter: interactive
  • Rows Removed by Filter: 1399
17. 101.310 101.310 ↑ 1.0 1 20,262

Index Scan using apps_pkey on apps a (cost=0.28..0.39 rows=1 width=93) (actual time=0.003..0.005 rows=1 loops=20,262)

  • Index Cond: (id = s.app_id)
18. 0.009 0.009 ↑ 1.0 1 1

Index Scan using container_settings_tools_id_key on container_settings c (cost=0.28..0.31 rows=1 width=91) (actual time=0.007..0.009 rows=1 loops=1)

  • Index Cond: (tools_id = k.tool_id)
19. 0.018 0.018 ↑ 1.0 1 1

Index Scan using container_images_pkey on container_images i (cost=0.28..3.03 rows=1 width=98) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (id = l.container_images_id)
20. 0.027 0.027 ↑ 1.0 19 1

Seq Scan on container_ports p (cost=0.00..1.19 rows=19 width=20) (actual time=0.007..0.027 rows=19 loops=1)