explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nuDp : Insert a process execution

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

Nested Loop (cost=0.86..93.34 rows=44 width=87) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using process_execution_id_uindex on process_execution p (cost=0.42..8.44 rows=1 width=63) (actual rows= loops=)

  • Index Cond: (id = 1,000,000)
3. 0.000 0.000 ↓ 0.0

Index Scan using step_execution_pkey on step_execution s (cost=0.43..84.45 rows=44 width=24) (actual rows= loops=)

  • Index Cond: (process_execution_id = 1,000,000)