explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RtjP

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 0.046 ↓ 0.0 0 1

Update on card_instance_cache (cost=0.41..8.44 rows=1 width=447) (actual time=0.046..0.046 rows=0 loops=1)

2. 0.030 0.030 ↑ 1.0 1 1

Index Scan using card_instance_cache_pk on card_instance_cache (cost=0.41..8.44 rows=1 width=447) (actual time=0.029..0.030 rows=1 loops=1)

  • Index Cond: (((environment_id)::text = '0001-czjY'::text) AND ((event_name)::text = 'testEvent:1'::text) AND (event_source = 'live'::private.event_source) AND ((lifecycle_id)::text = '9o1tx320j-1'::text) AND (card_template_id = 182) AND ((end_user_id)::text = 'user1'::text))
Planning time : 0.101 ms
Execution time : 0.165 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
set_user_stream_modified 0.092 ms 1 0.092 ms