explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zr8n

Settings
# exclusive inclusive rows x rows loops node
1. 601.212 7,939.020 ↓ 0.0 0 1

ModifyTable on public.scim_identities (cost=101.92..11,085.22 rows=857,920 width=57) (actual time=7,939.020..7,939.020 rows=0 loops=1)

  • Buffers: shared hit=169170 read=6734 dirtied=368
  • I/O Timings: read=7122.788
2. 96.448 7,337.808 ↑ 90.5 9,476 1

Merge Join (cost=101.92..11,085.22 rows=857,920 width=57) (actual time=118.785..7,337.808 rows=9,476 loops=1)

  • Merge Cond: (saml_providers.id = identities.saml_provider_id)
  • Buffers: shared hit=17692 read=6402 dirtied=37
  • I/O Timings: read=7122.540
3. 0.791 30.023 ↑ 1.2 208 1

Sort (cost=101.63..102.26 rows=253 width=8) (actual time=29.584..30.023 rows=208 loops=1)

  • Sort Key: saml_providers.id
  • Sort Method: quicksort Memory: 34kB
  • Buffers: shared hit=359 read=23 dirtied=3
  • I/O Timings: read=22.527
4. 0.255 29.232 ↑ 1.2 208 1

Merge Semi Join (cost=1.04..91.53 rows=253 width=8) (actual time=5.809..29.232 rows=208 loops=1)

  • Merge Cond: (saml_providers.group_id = scim_oauth_access_tokens.group_id)
  • Buffers: shared hit=354 read=23 dirtied=3
  • I/O Timings: read=22.527
5. 23.748 23.748 ↓ 1.0 601 1

Index Scan using index_saml_providers_on_group_id on public.saml_providers (cost=0.28..72.92 rows=599 width=8) (actual time=2.577..23.748 rows=601 loops=1)

  • Buffers: shared hit=350 read=21 dirtied=1
  • I/O Timings: read=21.281
6. 5.229 5.229 ↑ 1.0 253 1

Index Only Scan using index_scim_oauth_access_tokens_on_group_id_and_token_encrypted on public.scim_oauth_access_tokens (cost=0.27..14.07 rows=253 width=4) (actual time=0.121..5.229 rows=253 loops=1)

  • Heap Fetches: 30
  • Buffers: shared hit=4 read=2 dirtied=2
  • I/O Timings: read=1.246
7. 7,211.337 7,211.337 ↑ 135.3 15,011 1

Index Scan using index_identities_on_saml_provider_id on public.identities (cost=0.29..20,718.76 rows=2,031,203 width=32) (actual time=10.200..7,211.337 rows=15,011 loops=1)

  • Buffers: shared hit=7849 read=6378 dirtied=33
  • I/O Timings: read=7098.928