explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7kQ9

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.046 ↓ 0.0 0 1

Limit (cost=4.31..4.32 rows=1 width=2,121) (actual time=0.046..0.046 rows=0 loops=1)

2. 0.005 0.045 ↓ 0.0 0 1

Sort (cost=4.31..4.32 rows=1 width=2,121) (actual time=0.045..0.045 rows=0 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
3. 0.040 0.040 ↓ 0.0 0 1

Index Scan using users_unconfirmed_email_idx on users (cost=0.29..4.30 rows=1 width=2,121) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: ((unconfirmed_email)::text = 'abrandl@gitlab.com'::text)
Planning time : 0.635 ms
Execution time : 0.113 ms