explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vTub

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 82.555 ↓ 0.0 0 1

Limit (cost=0.67..818.17 rows=10 width=12) (actual time=82.555..82.555 rows=0 loops=1)

2. 82.554 82.554 ↓ 0.0 0 1

Index Only Scan using cc_member_test_json on cc_member m1 (cost=0.67..4,088.19 rows=50 width=12) (actual time=82.554..82.554 rows=0 loops=1)

  • Index Cond: ((queue_id = 1) AND (last_hangup_at < '500108000099'::bigint))
  • Filter: (communications @> '[{""type"": 2, ""state"": 1, ""routing_ids"": [55]}]'::jsonb)
  • Rows Removed by Filter: 50000
  • Heap Fetches: 0
Planning time : 0.219 ms
Execution time : 82.581 ms