explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jSGZ

Settings
# exclusive inclusive rows x rows loops node
1. 1,132.130 1,335.527 ↓ 0.0 0 1

Update on notes (cost=0.70..1,127.82 rows=1 width=2,448) (actual time=1,335.527..1,335.527 rows=0 loops=1)

2. 203.397 203.397 ↓ 98.0 98 1

Index Scan using index_notes_on_discussion_id on notes (cost=0.70..1,127.82 rows=1 width=2,448) (actual time=12.120..203.397 rows=98 loops=1)

  • Index Cond: ((discussion_id)::text = ANY ('{000397d8f79166fb194b32c29d9aa22b9b5c14f7,0012b92631f5289eca21e8eae00f54aeed3ff918,00381b0d46d8f61f265e8c4cecd1f72e72d57e4f,0040625c9be3ac77b16095c25310293f5ead52a9,0043da8493a2098b9fcda2e03e3a68e2fb3a3d50,"0045340946df3167be5ecbc
  • Filter: ((noteable_type)::text = 'Epic'::text)
  • Rows Removed by Filter: 36
Planning time : 3.336 ms
Execution time : 1,335.647 ms