explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vkBp

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.047 ↑ 1.0 1 1

Limit (cost=4.04..4.04 rows=1 width=2,236) (actual time=0.047..0.047 rows=1 loops=1)

2. 0.007 0.045 ↑ 1.0 1 1

Sort (cost=4.04..4.04 rows=1 width=2,236) (actual time=0.045..0.045 rows=1 loops=1)

  • Sort Key: minor_version DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.038 0.038 ↑ 1.0 1 1

Index Scan using actions_action_package_id_function_name_major_version_index on actions "Action" (cost=0.03..4.03 rows=1 width=2,236) (actual time=0.037..0.038 rows=1 loops=1)

  • Index Cond: (((action_package_id)::text = 'ap_apilookup'::text) AND ((function_name)::text = 'clearbitEmailEnrichment'::text) AND (major_version = 1))
  • Filter: (deleted_at IS NULL)
Planning time : 0.366 ms
Execution time : 0.079 ms