explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZMio

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 35.308 ↓ 0.0 0 1

Limit (cost=4,219.58..4,219.58 rows=1 width=1,336) (actual time=35.308..35.308 rows=0 loops=1)

2. 0.008 35.306 ↓ 0.0 0 1

Sort (cost=4,219.58..4,219.58 rows=1 width=1,336) (actual time=35.306..35.306 rows=0 loops=1)

  • Sort Method: quicksort Memory: 25kB
  • Sort Key: (str_to_timestamp((event_context ->> ''generatedOn''::text))) DESC
3. 0.005 35.298 ↓ 0.0 0 1

Bitmap Heap Scan on event (cost=4,214.77..4,219.57 rows=1 width=1,336) (actual time=35.298..35.298 rows=0 loops=1)

  • Recheck Cond: (((event_context -> ''context''::text) @> ''{"entityRef": "5000003"}''::jsonb) AND ((event_context -> ''context''::text) @> ''{"entityType": "LOCATION"}''::jsonb) AND ((event_context ->> ''name''::text) = ''DASHBOARD_MEASURES_FULFILMENTS_CHANGE''::text))
  • Filter: (((event_context ->> ''type''::text) = ''ORCHESTRATION''::text) AND (str_to_timestamp((event_context ->> ''generatedOn''::text)) >= ''2019-01-19 02:00:00''::timestamp without time zone) AND (str_to_timestamp((event_context ->> ''generatedOn''::text)) <= ''2019-02-18 02:00:04.88''::timestamp without time zone))
4. 0.001 35.293 ↓ 0.0 0 1

BitmapAnd (cost=4,214.77..4,214.77 rows=1 width=0) (actual time=35.293..35.293 rows=0 loops=1)

5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_on_event_context_name (cost=0.00..3,945.92 rows=118,495 width=0) (never executed)

6. 35.292 35.292 ↓ 0.0 0 1

Bitmap Index Scan on idx_on_context_event_context (cost=0.00..268.61 rows=2,861 width=0) (actual time=35.292..35.292 rows=0 loops=1)

  • Index Cond: ((event_context ->> ''name''::text) = ''DASHBOARD_MEASURES_FULFILMENTS_CHANGE''::text)