explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z3hY

Settings
# exclusive inclusive rows x rows loops node
1. 7.056 12,054.091 ↑ 1.0 11 1

Unique (cost=616,353.79..616,817.93 rows=11 width=12) (actual time=12,035.122..12,054.091 rows=11 loops=1)

2. 245.275 12,047.035 ↑ 1.0 90,029 1

Sort (cost=616,353.79..616,585.86 rows=92,827 width=12) (actual time=12,035.121..12,047.035 rows=90,029 loops=1)

  • Sort Key: handle_id, start_timestamp
  • Sort Method: external merge Disk: 1928kB
3. 11,748.664 11,801.760 ↑ 1.0 90,029 1

Bitmap Heap Scan on handle_histories (cost=205,433.66..608,694.52 rows=92,827 width=12) (actual time=62.983..11,801.760 rows=90,029 loops=1)

  • Recheck Cond: (handle_id = ANY ('{16,19,67,271,9425,11458,635,33823,152630,153054,263015}'::integer[]))
  • Filter: ((name IS NOT NULL) AND (connections_in IS NOT NULL))
  • Rows Removed by Filter: 52480
  • Heap Blocks: exact=35753 lossy=29173
4. 53.096 53.096 ↑ 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=53.096..53.096 rows=142,509 loops=1)

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