explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lQcE : q1

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

Nested Loop (cost=4.87..41.6 rows=1 width=136) (actual time=0.026..0.026 rows=0 loops=1)

  • Buffers: shared hit=3
2. 0.002 0.025 ↓ 0.0 0 1

Bitmap Heap Scan on registereddevices d (cost=4.45..16.23 rows=3 width=25) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=3
3. 0.023 0.023 ↓ 0.0 0 1

Bitmap Index Scan on registereddevices_macaddress_lower_idx (cost=0..4.45 rows=3 width=0) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (lower((d.macaddress)::text) = '744aa480a3d7'::text)
  • Buffers: shared hit=3
4. 0.000 0.000 ↓ 0.0 0 0

Index Scan using wifiaccounts_pkey on wifiaccounts a (cost=0.42..8.45 rows=1 width=8) (never executed)

  • Index Cond: (a.id = d.wifiaccount_id)
  • Filter: (a.accountexpirydate > now())
Planning time : 0.699 ms
Execution time : 0.097 ms