explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 43NB

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.024 ↓ 0.0 0 1

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

2. 0.023 0.023 ↓ 0.0 0 1

Index Scan using card_instance_cache_pk on card_instance_cache (cost=0.41..8.45 rows=1 width=447) (actual time=0.023..0.023 rows=0 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 (stream_id = 1) AND ((end_user_id)::text = 'user1'::text))
Planning time : 0.102 ms
Execution time : 0.053 ms