explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bFtt

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.096 ↑ 1.0 1 1

Limit (cost=0.82..5.05 rows=1 width=383) (actual time=0.087..0.096 rows=1 loops=1)

2. 0.005 0.086 ↑ 42.0 1 1

Nested Loop Semi Join (cost=0.82..178.21 rows=42 width=383) (actual time=0.084..0.086 rows=1 loops=1)

3. 0.061 0.061 ↑ 42.0 1 1

Index Scan using ix_list_entries_list_entry_object_card_pan_token_list_alias on list_entries le (cost=0.55..173.39 rows=42 width=383) (actual time=0.059..0.061 rows=1 loops=1)

  • Index Cond: (((list_entry_object ->> 'card_pan_token'::text) = '5ikA6NZp4rRETPexEcXx8azHgVswfvoUT8bLZHnB7Mo'::text) AND ((list_alias)::text = 'test_card_token_pan_list2'::text))
4. 0.005 0.020 ↑ 1.0 1 1

Materialize (cost=0.28..4.30 rows=1 width=56) (actual time=0.018..0.020 rows=1 loops=1)

5. 0.015 0.015 ↑ 1.0 1 1

Index Only Scan using list_pkey on list l (cost=0.28..4.29 rows=1 width=56) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: (list_alias = 'test_card_token_pan_list2'::text)
  • Heap Fetches: 0
Planning time : 0.225 ms
Execution time : 0.155 ms