explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zTo4

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.074 ↑ 1.0 10 1

Limit (cost=39.18..77.94 rows=10 width=1,648) (actual time=0.052..0.074 rows=10 loops=1)

2. 0.068 0.068 ↑ 401.4 20 1

Index Scan Backward using new_journey_snapshot_u_id_is_serv_jrny on new_journey_snapshot_big (cost=0.43..31,116.93 rows=8,029 width=1,648) (actual time=0.030..0.068 rows=20 loops=1)

  • Index Cond: ((user_identity_id)::text = '47085757'::text)
Planning time : 0.398 ms
Execution time : 0.117 ms