explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G0Cv

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.705 ↑ 1.0 10 1

Limit (cost=847.38..847.40 rows=10 width=1,656) (actual time=0.696..0.705 rows=10 loops=1)

2. 0.155 0.696 ↑ 6.8 20 1

Sort (cost=847.35..847.69 rows=135 width=1,656) (actual time=0.689..0.696 rows=20 loops=1)

  • Sort Key: journey_started_at DESC
  • Sort Method: top-N heapsort Memory: 35kB
3. 0.486 0.541 ↓ 1.6 222 1

Bitmap Heap Scan on journey_snapshot (cost=22.46..843.76 rows=135 width=1,656) (actual time=0.087..0.541 rows=222 loops=1)

  • Recheck Cond: ((user_identity_id)::text = '47085757'::text)
  • Filter: (((license_plate)::text <> ''::text) AND ((journey_type)::text = ANY ('{SIXT,SIXT_RENT,SIXTRENT,SIXTSHARE}'::text[])))
  • Rows Removed by Filter: 57
  • Heap Blocks: exact=240
4. 0.055 0.055 ↓ 1.2 326 1

Bitmap Index Scan on journey_snapshot_u_id_is_serv_jrny (cost=0.00..22.42 rows=268 width=0) (actual time=0.055..0.055 rows=326 loops=1)

  • Index Cond: ((user_identity_id)::text = '47085757'::text)
Planning time : 0.260 ms
Execution time : 0.744 ms