explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6To7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.065 ↑ 1.0 3 1

Group (cost=39.86..39.89 rows=3 width=76) (actual time=0.064..0.065 rows=3 loops=1)

  • Group Key: b.version_name, a.name, c.deployment_date, b.phase
2. 0.011 0.063 ↑ 1.0 3 1

Sort (cost=39.86..39.86 rows=3 width=76) (actual time=0.063..0.063 rows=3 loops=1)

  • Sort Key: b.version_name, a.name, c.deployment_date, b.phase
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.052 ↑ 1.0 3 1

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

4. 0.002 0.044 ↑ 1.0 3 1

Nested Loop (cost=0.30..39.12 rows=3 width=56) (actual time=0.031..0.044 rows=3 loops=1)

5. 0.005 0.030 ↑ 1.0 3 1

Nested Loop (cost=0.15..38.41 rows=3 width=80) (actual time=0.021..0.030 rows=3 loops=1)

6. 0.010 0.010 ↑ 1.0 3 1

Seq Scan on batches_customers d (cost=0.00..17.88 rows=3 width=68) (actual time=0.007..0.010 rows=3 loops=1)

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

Index Scan using pk_batch on batches c (cost=0.15..6.84 rows=1 width=76) (actual time=0.005..0.005 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.012 0.012 ↑ 1.0 1 3

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

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

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

  • Index Cond: (module_id = b.module_id)