explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DiI6

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

Update on sbtest9 (cost=0.33..4.34 rows=1 width=38) (actual rows= loops=)

2.          

Initplan (forUpdate)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.29..0.32 rows=1 width=6) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using "sbtest9$_id_" on sbtest9 sbtest9_1 (cost=0.29..8.31 rows=234 width=6) (actual rows= loops=)

  • Index Cond: ((b -> '_id'::text) #= '{ "" : 9324987 }'::pbson)
  • Filter: (b @> '{ "_id" : { "$eq" : 9324987 } }'::pbson_matchexpr)
5. 0.000 0.000 ↓ 0.0

Tid Scan on sbtest9 (cost=0.00..4.02 rows=1 width=38) (actual rows= loops=)

  • TID Cond: (ctid = $0)