explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XSnn

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 362.826 ↓ 1.7 50 1

Limit (cost=118.87..118.95 rows=29 width=1,496) (actual time=362.780..362.826 rows=50 loops=1)

2. 1.133 362.802 ↓ 1.7 50 1

Sort (cost=118.87..118.95 rows=29 width=1,496) (actual time=362.778..362.802 rows=50 loops=1)

  • Sort Key: ((payload #>> '{created_at}'::text[])) DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 125kB
3. 344.664 361.669 ↓ 5.4 156 1

Bitmap Heap Scan on projections (cost=4.64..118.17 rows=29 width=1,496) (actual time=17.073..361.669 rows=156 loops=1)

  • Recheck Cond: ((payload #>> '{account}'::text[]) = 'https://account-service-tennessine.production-plutonium.b-anti-social.io/accounts/6aff35ec-b2ae-4eb7-a93c-d11a96470197'::text)
  • Heap Blocks: exact=161
4. 17.005 17.005 ↓ 6.9 199 1

Bitmap Index Scan on projections_expr_idx1 (cost=0.00..4.64 rows=29 width=0) (actual time=17.005..17.005 rows=199 loops=1)

  • Index Cond: ((payload #>> '{account}'::text[]) = 'https://account-service-tennessine.production-plutonium.b-anti-social.io/accounts/6aff35ec-b2ae-4eb7-a93c-d11a96470197'::text)
Planning time : 0.878 ms
Execution time : 362.919 ms