explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nWHy : Optimization for: plan #69Q4

Settings

Optimization path:

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

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

2.          

Initplan (forResult)

3. 0.016 0.016 ↓ 0.0 0 1

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

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