explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BUKe

Settings
# exclusive inclusive rows x rows loops node
1. 3,811.105 151,320.667 ↓ 659.3 131,865 1

Bitmap Heap Scan on conversation_items ci (cost=2,136,373.67..2,427,677.52 rows=200 width=766) (actual time=147,516.428..151,320.667 rows=131,865 loops=1)

  • Recheck Cond: (((fields -> 'content'::text) ->> 'type'::text) = 'SESSION_ENDED'::text)
  • Rows Removed by Index Recheck: 840958
  • 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: 18345
  • Heap Blocks: exact=25916 lossy=106457
  • Wrap
2. 147,509.562 147,509.562 ↓ 1.9 151,192 1

Bitmap Index Scan on conversation_items_liveboard_calls_over_sla_idx (cost=0.00..2,136,373.62 rows=80,212 width=0) (actual time=147,509.561..147,509.562 rows=151,192 loops=1)

  • Index Cond: (((fields -> 'content'::text) ->> 'type'::text) = 'SESSION_ENDED'::text)
Planning time : 0.780 ms
Execution time : 151,327.149 ms