explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JBPc

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

Group (cost=39.86..39.89 rows=3 width=76) (actual rows= loops=)

  • Group Key: b.version_name, a.name, c.deployment_date, b.phase
2. 0.000 0.000 ↓ 0.0

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

  • Sort Key: b.version_name, a.name, c.deployment_date, b.phase
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.45..39.83 rows=3 width=76) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.30..39.12 rows=3 width=56) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..38.41 rows=3 width=80) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

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

  • Filter: ((store_id)::text = '5555555'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using pk_batch on batches c (cost=0.15..6.84 rows=1 width=76) (actual rows= loops=)

  • 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.000 0.000 ↓ 0.0

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

  • Index Cond: (((version_name)::text = (c.version_name)::text) AND (module_id = c.module_id))
9. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (module_id = b.module_id)