explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i1rW

Settings

Optimization(s) for this plan:

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

Limit (cost=3.32..3.33 rows=2 width=185) (actual time=0.025..0.025 rows=0 loops=1)

2. 0.006 0.025 ↓ 0.0 0 1

Sort (cost=3.32..3.33 rows=2 width=185) (actual time=0.024..0.025 rows=0 loops=1)

  • Sort Key: creation_date DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.019 0.019 ↓ 0.0 0 1

Index Scan using tp_gc_asin_sn_test on third_party_gift_certificates this_ (cost=0.28..3.31 rows=2 width=185) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((asin)::text = 'B00CXZPG0O'::text)
  • Filter: ((status)::text = ANY ('{FailedActivation,Activated}'::text[]))
Planning time : 0.214 ms
Execution time : 0.064 ms