explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rRPQ

Settings
# exclusive inclusive rows x rows loops node
1. 17.027 13,640.798 ↑ 1.0 11 1

Unique (cost=623,885.91..624,623.12 rows=11 width=16) (actual time=13,586.897..13,640.798 rows=11 loops=1)

2. 478.936 13,623.771 ↑ 1.0 142,509 1

Sort (cost=623,885.91..624,254.51 rows=147,442 width=16) (actual time=13,586.894..13,623.771 rows=142,509 loops=1)

  • Sort Key: handle_id, start_timestamp
  • Sort Method: external merge Disk: 3408kB
3. 13,078.262 13,144.835 ↑ 1.0 142,509 1

Bitmap Heap Scan on handle_histories (cost=205,447.31..608,708.17 rows=147,442 width=16) (actual time=75.373..13,144.835 rows=142,509 loops=1)

  • Recheck Cond: (handle_id = ANY ('{16,19,67,271,9425,11458,635,33823,152630,153054,263015}'::integer[]))
  • Heap Blocks: exact=35753 lossy=29173
4. 66.573 66.573 ↑ 1.0 142,509 1

Bitmap Index Scan on handle_histories_handle_id_index (cost=0.00..205,410.45 rows=147,442 width=0) (actual time=66.573..66.573 rows=142,509 loops=1)

  • Index Cond: (handle_id = ANY ('{16,19,67,271,9425,11458,635,33823,152630,153054,263015}'::integer[]))