explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0VBw

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 10,831.332 ↓ 0.0 0 1

Limit (cost=0.43..618,082.61 rows=1 width=2,121) (actual time=10,831.332..10,831.332 rows=0 loops=1)

2. 10,831.331 10,831.331 ↓ 0.0 0 1

Index Scan using users_pkey on users (cost=0.43..618,082.61 rows=1 width=2,121) (actual time=10,831.331..10,831.331 rows=0 loops=1)

  • Filter: ((unconfirmed_email)::text = 'abrandl@gitlab.com'::text)
  • Rows Removed by Filter: 4345138
Planning time : 0.368 ms
Execution time : 10,831.384 ms