explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S6aU

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

Update (cost=0.00..6.89 rows=1 width=1) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=228) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Split (cost=0.00..6.00 rows=1 width=224) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=260) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using salert_posts_pkey on salert_posts (cost=0.00..6.00 rows=1 width=153) (actual rows= loops=)

  • Index Cond: ((id)::text = '1219966077318418432'::text)Optimizer: Pivotal Optimizer (GPORCA) version 3.80.0