explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jbUp : Optimization for: Optimization for: plan #2h8m; plan #9uA3

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 18.574 ↑ 1.0 1 1

Limit (cost=2,869.84..2,869.85 rows=1 width=723) (actual time=18.572..18.574 rows=1 loops=1)

2. 4.204 18.570 ↑ 1.0 1 1

Sort (cost=2,869.84..2,869.85 rows=1 width=723) (actual time=18.570..18.570 rows=1 loops=1)

  • Sort Key: created_at DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 14.366 14.366 ↓ 7,605.0 7,605 1

Index Scan using index_interactions_on_security_principal_and_provider_contact_i on interactions (cost=0.56..2,869.83 rows=1 width=723) (actual time=0.031..14.366 rows=7,605 loops=1)

  • Index Cond: (((security_principal)::text = 'd0cbfc8b5ab02a0bf7b3e91314d0d851'::text) AND ((provider_type)::text = 'aswat_call'::text))
  • Filter: ((provider_agent_id)::text = '111'::text)
  • Rows Removed by Filter: 3768
Planning time : 0.153 ms
Execution time : 18.612 ms