explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jfcF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 34.702 ↓ 0.0 0 1

Nested Loop (cost=0.86..6,987.14 rows=1 width=104) (actual time=34.702..34.702 rows=0 loops=1)

  • Buffers: shared hit=20,650 read=241
2. 0.289 22.228 ↓ 2,545.0 2,545 1

Nested Loop (cost=0.43..6,986.65 rows=1 width=56) (actual time=0.161..22.228 rows=2,545 loops=1)

  • Buffers: shared hit=10,625 read=79
3. 1.579 1.579 ↑ 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.114..1.579 rows=2,545 loops=1)

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

Index Scan using demo_c_pagealias_idx3 on t_e20so1_pages b (cost=0.43..2.53 rows=1 width=34) (actual time=0.008..0.008 rows=1 loops=2,545)

  • Index Cond: ((b.c_pagealias)::text = (a.imagelabel_cp)::text)
  • Filter: (a.documentid_cp = b.c_documentid)
  • Buffers: shared hit=10,131 read=79
5. 12.725 12.725 ↑ 1.0 1 2,545

Index Scan using demo_c_pagesid_idx1 on t_e20so1_pages_nvarchar c (cost=0.43..0.47 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=2,545)

  • Index Cond: (b.c_pagesid = c.c_pagesid)
  • Filter: (c.c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid)
  • Buffers: shared hit=10,025 read=162
Planning time : 34.591 ms
Execution time : 34.74 ms