explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gQhQ

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

Unique (cost=156,268.01..156,312.06 rows=11 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=156,268.01..156,312.06 rows=17,618 width=16) (actual rows= loops=)

  • Sort Key: start_timestamp
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on handle_histories (cost=57,782.70..155,025.53 rows=17,618 width=16) (actual rows= loops=)

  • Recheck Cond: (handle_id = 16)
  • Filter: ((name IS NOT NULL) AND (connections_in IS NOT NULL))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on handle_histories_handle_id_index (cost=0.00..57,778.29 rows=27,983 width=0) (actual rows= loops=)

  • Index Cond: (handle_id = 16)