explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8YPl

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 6.413 ↑ 1.0 1 1

Aggregate (cost=13,139.15..13,139.16 rows=1 width=8) (actual time=5.048..6.413 rows=1 loops=1)

  • Buffers: shared hit=161
2. 6.158 6.373 ↑ 62.2 32 1

Gather (cost=1,004.42..13,138.16 rows=1,990 width=17) (actual time=0.377..6.373 rows=32 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=161
3. 0.015 0.215 ↑ 73.2 16 2 / 2

Nested Loop (cost=4.42..11,939.16 rows=1,171 width=17) (actual time=0.050..0.215 rows=16 loops=2)

  • Buffers: shared hit=161
4. 0.048 0.072 ↑ 154.7 16 2 / 2

Parallel Bitmap Heap Scan on conversation convo (cost=4.33..3,597.80 rows=2,475 width=65) (actual time=0.041..0.072 rows=16 loops=2)

  • Recheck Cond: (("shopId" = 'shopify-23182543'::text) AND (NOT "isArchived") AND ("lastReceivedMessageSentAt" IS NOT NULL))
  • Heap Blocks: exact=32
  • Buffers: shared hit=33
5. 0.024 0.024 ↑ 131.5 32 1 / 2

Bitmap Index Scan on "conversation_shopId_idx" (cost=0.00..4.12 rows=4,207 width=0) (actual time=0.047..0.047 rows=32 loops=1)

  • Index Cond: ("shopId" = 'shopify-23182543'::text)
  • Buffers: shared hit=1
6. 0.128 0.128 ↑ 1.0 1 32 / 2

Index Scan using "PK_ba01f0a3e0123651915008bc578" on message lm (cost=0.08..3.37 rows=1 width=17) (actual time=0.008..0.008 rows=1 loops=32)

  • Index Cond: (id = convo."lastMessageId")
  • Filter: ("shopId" = 'shopify-23182543'::text)
  • Buffers: shared hit=128
Planning time : 0.659 ms
Execution time : 6.463 ms