explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 69Q4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 0.021 ↑ 1.0 1 1

Result (cost=1.01..1.02 rows=1 width=1) (actual time=0.021..0.021 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on subscription_purchased (cost=0.00..1.01 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Filter: ((payment_info -> 'transaction_ids'::text) @> '["kutta"]'::jsonb)
  • Rows Removed by Filter: 2
Planning time : 0.081 ms
Execution time : 0.041 ms