explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KYWy

Settings
# exclusive inclusive rows x rows loops node
1. 0.125 5,167.362 ↑ 670.0 3 1

Unique (cost=4,899.86..4,910.13 rows=2,010 width=16) (actual time=5,167.073..5,167.362 rows=3 loops=1)

2. 1.933 5,167.237 ↓ 1.1 2,252 1

Sort (cost=4,899.86..4,904.99 rows=2,054 width=16) (actual time=5,167.073..5,167.237 rows=2,252 loops=1)

  • Sort Key: handle_id, start_timestamp
  • Sort Method: quicksort Memory: 202kB
3. 5,165.304 5,165.304 ↓ 1.1 2,252 1

Index Scan using handle_histories_handle_id_index on handle_histories (cost=0.56..4,786.84 rows=2,054 width=16) (actual time=19.264..5,165.304 rows=2,252 loops=1)

  • Index Cond: (handle_id = ANY ('{337026,428044,428049}'::integer[]))
  • Filter: ((name IS NOT NULL) AND (connections_in IS NOT NULL))
  • Rows Removed by Filter: 69