explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8nQs

Settings
# exclusive inclusive rows x rows loops node
1. 1,020.810 2,945.926 ↓ 659.3 131,865 1

Bitmap Heap Scan on conversation_items ci (cost=2,137,079.68..2,428,442.01 rows=200 width=766) (actual time=1,931.825..2,945.926 rows=131,865 loops=1)

  • Recheck Cond: (((fields -> 'content'::text) ->> 'type'::text) = 'SESSION_ENDED'::text)
  • Rows Removed by Index Recheck: 841269
  • Filter: (((fields ->> 'timestamp'::text) < '2019-07-08T15:30:00Z'::text) AND (((fields -> 'content'::text) ->> 'provider'::text) IS NOT NULL) AND (((fields -> 'content'::text) ->> 'sessionType'::text) = 'CHAT'::text) AND ((((fields -> 'content'::text) ->> 'deletedFromProvider'::text))::boolean IS NOT TRUE))
  • Rows Removed by Filter: 18638
  • Heap Blocks: exact=26159 lossy=106455
2. 1,925.116 1,925.116 ↓ 1.9 151,472 1

Bitmap Index Scan on conversation_items_liveboard_calls_over_sla_idx (cost=0.00..2,137,079.63 rows=80,228 width=0) (actual time=1,925.116..1,925.116 rows=151,472 loops=1)

  • Index Cond: (((fields -> 'content'::text) ->> 'type'::text) = 'SESSION_ENDED'::text)
Planning time : 2.417 ms
Execution time : 2,952.287 ms