explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DqNa

Settings
# exclusive inclusive rows x rows loops node
1. 13.466 12,875.637 ↑ 1.0 11 1

Unique (cost=624,389.91..625,127.12 rows=11 width=20) (actual time=12,836.647..12,875.637 rows=11 loops=1)

2. 455.239 12,862.171 ↑ 1.0 142,509 1

Sort (cost=624,389.91..624,758.51 rows=147,442 width=20) (actual time=12,836.646..12,862.171 rows=142,509 loops=1)

  • Sort Key: handle_id, start_timestamp
  • Sort Method: external merge Disk: 3424kB
3. 12,330.108 12,406.932 ↑ 1.0 142,509 1

Bitmap Heap Scan on handle_histories (cost=205,447.31..608,708.17 rows=147,442 width=20) (actual time=84.507..12,406.932 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. 76.824 76.824 ↑ 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=76.824..76.824 rows=142,509 loops=1)

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