explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DGhW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=95,896.76..96,099.33 rows=27,173 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=95,896.76..95,998.04 rows=40,513 width=16) (actual rows= loops=)

  • Sort Key: handle_id, start_timestamp
3. 0.000 0.000 ↓ 0.0

Index Scan using handle_histories_handle_id_index on handle_histories (cost=0.56..92,796.28 rows=40,513 width=16) (actual rows= loops=)

  • Index Cond: (handle_id = ANY ('{315543,1122014,23,33,11458,131284}'::integer[]))
  • Filter: ((name IS NOT NULL) AND (connections_in IS NOT NULL))