explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PR1f

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.068 ↑ 1.0 1 1

Limit (cost=0.82..5.05 rows=1 width=383) (actual time=0.059..0.068 rows=1 loops=1)

2. 0.004 0.059 ↑ 42.0 1 1

Nested Loop (cost=0.82..178.21 rows=42 width=383) (actual time=0.057..0.059 rows=1 loops=1)

3. 0.040 0.040 ↑ 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.039..0.040 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.004 0.015 ↑ 1.0 1 1

Materialize (cost=0.28..4.30 rows=1 width=56) (actual time=0.014..0.015 rows=1 loops=1)

5. 0.011 0.011 ↑ 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.010..0.011 rows=1 loops=1)

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