explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gSOn : Optimization for: plan #6To7

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 0.117 ↓ 3.0 3 1

Group (cost=9.97..9.98 rows=1 width=76) (actual time=0.114..0.117 rows=3 loops=1)

  • Group Key: b.version_name, a.name, c.deployment_date, b.phase
2. 0.021 0.113 ↓ 3.0 3 1

Sort (cost=9.97..9.97 rows=1 width=76) (actual time=0.112..0.113 rows=3 loops=1)

  • Sort Key: b.version_name, a.name, c.deployment_date, b.phase
  • Sort Method: quicksort Memory: 25kB
3. 0.004 0.092 ↓ 3.0 3 1

Nested Loop (cost=0.45..9.96 rows=1 width=76) (actual time=0.052..0.092 rows=3 loops=1)

4. 0.006 0.079 ↓ 3.0 3 1

Nested Loop (cost=0.30..9.72 rows=1 width=56) (actual time=0.046..0.079 rows=3 loops=1)

5. 0.010 0.058 ↓ 3.0 3 1

Nested Loop (cost=0.15..9.48 rows=1 width=80) (actual time=0.037..0.058 rows=3 loops=1)

6. 0.021 0.021 ↓ 3.0 3 1

Seq Scan on batches_customers d (cost=0.00..1.29 rows=1 width=68) (actual time=0.016..0.021 rows=3 loops=1)

  • Filter: ((store_id)::text = '5555555'::text)
  • Rows Removed by Filter: 20
7. 0.027 0.027 ↑ 1.0 1 3

Index Scan using pk_batch on batches c (cost=0.15..8.17 rows=1 width=76) (actual time=0.009..0.009 rows=1 loops=3)

  • Index Cond: (((batch_name)::text = (d.batch_name)::text) AND ((version_name)::text = (d.version_name)::text) AND (module_id = d.module_id))
8. 0.015 0.015 ↑ 1.0 1 3

Index Scan using pk_versions on versions b (cost=0.15..0.24 rows=1 width=40) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (((version_name)::text = (c.version_name)::text) AND (module_id = c.module_id))
9. 0.009 0.009 ↑ 1.0 1 3

Index Scan using pk_modules on modules a (cost=0.15..0.24 rows=1 width=36) (actual time=0.003..0.003 rows=1 loops=3)

  • Index Cond: (module_id = b.module_id)
Planning time : 2.168 ms
Execution time : 0.230 ms