explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PMoh

Settings
# exclusive inclusive rows x rows loops node
1. 8,769.914 25,924.212 ↓ 0.0 0 1

Nested Loop (cost=0.43..181,895.6 rows=1 width=104) (actual time=25,924.212..25,924.212 rows=0 loops=1)

  • Buffers: shared hit=2,049,372
2. 3.685 49.353 ↓ 2,545.0 2,545 1

Nested Loop (cost=0.43..71,204.32 rows=1 width=56) (actual time=0.23..49.353 rows=2,545 loops=1)

  • Buffers: shared hit=32,959
3. 2.403 2.403 ↑ 1.0 2,545 1

Seq Scan on temp_opt_06172020065842_98 a (cost=0..519.45 rows=2,545 width=80) (actual time=0.206..2.403 rows=2,545 loops=1)

  • Buffers: shared hit=494
4. 43.265 43.265 ↑ 1.0 1 2,545

Index Scan using t_e20so1_pages_c_documentid_idx on t_e20so1_pages b (cost=0.43..27.76 rows=1 width=34) (actual time=0.01..0.017 rows=1 loops=2,545)

  • Index Cond: (b.c_documentid = a.documentid_cp)
  • Filter: ((a.imagelabel_cp)::text = (b.c_pagealias)::text)
  • Buffers: shared hit=32,465
5. 17,104.945 17,104.945 ↑ 57.3 41,231 2,545

Seq Scan on t_e20so1_pages_nvarchar c (cost=0..81,141.64 rows=2,363,971 width=8) (actual time=0.001..6.721 rows=41,231 loops=2,545)

  • Filter: (c.c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid)
  • Buffers: shared hit=2,016,413
Planning time : 1.133 ms
Execution time : 25,924.265 ms