explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rdiD

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

Aggregate (cost=23.13..23.14 rows=1 width=32) (actual time=0.092..0.092 rows=1 loops=1)

2. 0.000 0.089 ↓ 0.0 0 1

Nested Loop (cost=0.85..23.13 rows=1 width=5) (actual time=0.089..0.089 rows=0 loops=1)

3. 0.089 0.089 ↓ 0.0 0 1

Index Scan using coupon_playerid_status_idx on coupon c (cost=0.42..16.68 rows=1 width=8) (actual time=0.089..0.089 rows=0 loops=1)

  • Index Cond: ((playerid = '65e98a4a-a2f3-4d6d-9b80-7b923b743ed6'::uuid) AND ((status)::text = ANY ('{played,paid,won,lost}'::text[])) AND ((status)::text = 'active'::text))
4. 0.000 0.000 ↓ 0.0 0

Index Scan using coupontransaction_couponnewid_uidx on coupontransaction ct (cost=0.42..6.44 rows=1 width=13) (never executed)

  • Index Cond: (couponnewid = c.newid)
Planning time : 1.066 ms
Execution time : 0.139 ms