explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Blm

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 31.238 252.388 ↓ 11991.5 23983 1

Nested Loop (cost=64.52..8815.59 rows=2 width=65) (actual time=11.255..252.388 rows=23983 loops=1)

2. 16.504 104.096 ↓ 722.6 39018 1

Nested Loop (cost=64.52..8304.97 rows=54 width=41) (actual time=11.242..104.096 rows=39018 loops=1)

  • Join Filter: (aep.key_fk = aepk.id)
3. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on audit_event_property_key aepk (cost=0.00..1.50 rows=1 width=12) (actual time=0.008..0.014 rows=1 loops=1)

  • Filter: ((key)::text = 'application'::text)
4. 77.938 87.578 ↓ 18.1 39018 1

Bitmap Heap Scan on audit_event_property aep (cost=64.52..8276.60 rows=2150 width=29) (actual time=11.228..87.578 rows=39018 loops=1)

  • Recheck Cond: ((value)::text = 'TransImplRTestsAuditedVisit'::text)
5. 9.640 9.640 ↓ 18.1 39018 1

Bitmap Index Scan on aep_value_ix (cost=0.00..63.98 rows=2150 width=0) (actual time=9.640..9.640 rows=39018 loops=1)

  • Index Cond: ((value)::text = 'TransImplRTestsAuditedVisit'::text)
6. 117.054 117.054 ↑ 1.0 1 39018

Index Scan using audit_event_pkey on audit_event ae (cost=0.00..9.44 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=39018)

  • Index Cond: (id = aep.audit_event_fk)
  • Filter: ((type)::text = 'modifyVisit'::text)