HTML
SOURCE
STATS

#	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

Update on card_instance_cache  (cost=0.41..8.44 rows=1 width=447) (actual time=0.046..0.046 rows=0 loops=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
Trigger set_user_stream_modified: time=0.092 calls=1
Execution Time: 0.165 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	0.030 ms	65.2 %
Update	1	0.016 ms	34.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
card_instance_cache	2	0.046 ms	100.0 %
Index Scan	1	0.030 ms	65.2 %
Update	1	0.016 ms	34.8 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RtjP

Color mode:

Visible columns:

Per node type stats

Per table stats