explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z55

Settings
# exclusive inclusive rows x rows loops node
1. 7.400 23.755 ↑ 459.9 749 1

Sort (cost=624,443.04..625,304.13 rows=344,434 width=1,970) (actual time=23.667..23.755 rows=749 loops=1)

  • Sort Key: ((event.json ->> 'serverVersion'::text))
  • Sort Method: quicksort Memory: 1398kB
2.          

CTE em

3. 0.569 1.317 ↓ 1.5 749 1

Bitmap Heap Scan on event_metadata (cost=41.77..1,865.55 rows=509 width=8) (actual time=0.786..1.317 rows=749 loops=1)

  • Recheck Cond: (((provider_id)::text = 'testsk'::text) AND (server_version >= 0))
  • Heap Blocks: exact=70
4. 0.748 0.748 ↓ 1.6 813 1

Bitmap Index Scan on event_metadata_sync_index (cost=0.00..41.64 rows=509 width=0) (actual time=0.748..0.748 rows=813 loops=1)

  • Index Cond: (((provider_id)::text = 'testsk'::text) AND (server_version >= 0))
5. 10.661 16.355 ↑ 459.9 749 1

Nested Loop (cost=11.88..2,263.12 rows=344,434 width=1,970) (actual time=2.454..16.355 rows=749 loops=1)

6. 0.838 2.698 ↓ 3.7 749 1

HashAggregate (cost=11.45..13.45 rows=200 width=8) (actual time=2.386..2.698 rows=749 loops=1)

  • Group Key: em.event_id
7. 1.860 1.860 ↓ 1.5 749 1

CTE Scan on em (cost=0.00..10.18 rows=509 width=8) (actual time=0.791..1.860 rows=749 loops=1)

8. 2.996 2.996 ↑ 1.0 1 749

Index Scan using event_pkey on event (cost=0.42..8.24 rows=1 width=1,938) (actual time=0.004..0.004 rows=1 loops=749)

  • Index Cond: (id = em.event_id)
Planning time : 3.052 ms
Execution time : 28.250 ms