explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ufwM

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

Limit (cost=1,000.43..31,169.87 rows=100,000 width=125) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.43..951,617.28 rows=3,150,927 width=125) (actual rows= loops=)

  • Workers Planned: 4
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..635,524.58 rows=787,732 width=125) (actual rows= loops=)

  • Join Filter: a.is_available
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on app a (cost=0.00..63,516.32 rows=787,732 width=17) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using metadata_version_pkey on metadata_version mv (cost=0.43..0.72 rows=1 width=141) (actual rows= loops=)

  • Index Cond: (metadata_version = a.metadata_version)