explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Kqo

Settings
# exclusive inclusive rows x rows loops node
1. 8.996 12.410 ↑ 1.0 3,491 1

Sort (cost=1,854.59..1,863.53 rows=3,574 width=117) (actual time=11.967..12.410 rows=3,491 loops=1)

  • Sort Key: serial, updated_at DESC
  • Sort Method: quicksort Memory: 860kB
2. 3.012 3.414 ↑ 1.0 3,491 1

Bitmap Heap Scan on devices (cost=120.12..1,643.67 rows=3,574 width=117) (actual time=0.544..3.414 rows=3,491 loops=1)

  • Recheck Cond: (cid = ("current_user"())::text)
  • Heap Blocks: exact=1084
3. 0.402 0.402 ↓ 1.0 3,743 1

Bitmap Index Scan on devices_cid (cost=0.00..119.23 rows=3,574 width=0) (actual time=0.402..0.402 rows=3,743 loops=1)

  • Index Cond: (cid = ("current_user"())::text)
Planning time : 0.091 ms
Execution time : 12.612 ms