explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z1db

Settings
# exclusive inclusive rows x rows loops node
1. 10.422 200.211 ↑ 1.0 11 1

Unique (cost=306,275.98..307,013.19 rows=11 width=12) (actual time=173.376..200.211 rows=11 loops=1)

2. 127.710 189.789 ↑ 1.0 142,509 1

Sort (cost=306,275.98..306,644.59 rows=147,442 width=12) (actual time=173.375..189.789 rows=142,509 loops=1)

  • Sort Key: handle_id, start_timestamp
  • Sort Method: external sort Disk: 3064kB
3. 62.079 62.079 ↑ 1.0 142,509 1

Index Only Scan using handle_histories_handle_id_start_timestamp_desc_index on handle_histories (cost=0.55..291,098.24 rows=147,442 width=12) (actual time=1.838..62.079 rows=142,509 loops=1)

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