explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 08aS

Settings
# exclusive inclusive rows x rows loops node
1. 7.824 9,772.943 ↓ 0.0 0 1

Update on conversations (cost=0.11..1,722,301.67 rows=184 width=93) (actual time=9,772.943..9,772.943 rows=0 loops=1)

  • Functions: 4
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 1.185 ms, Inlining 2.083 ms, Optimization 27.475 ms, Emission 15.944 ms, Total 46.687 ms"Execution Time: 9774.479 ms
2. 9,765.119 9,765.119 ↑ 2.0 94 1

Index Scan using conversations_pk on conversations (cost=0.11..1,722,301.67 rows=184 width=93) (actual time=88.679..9,765.119 rows=94 loops=1)

  • Index Cond: (other_member_guid = 'bcfaf762-30f3-4a08-46ea-a6fe46051a19'::uuid)