explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pwPq : Optimization for: Test; plan #XPFH

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.010 22.903 ↑ 1.0 1 1

Sort (cost=3,079.50..3,079.50 rows=1 width=731) (actual time=22.902..22.903 rows=1 loops=1)

  • Sort Key: t_e20so1_pages.c_pagesid NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
2.          

CTE cte_t_e20so1_pages

3. 0.051 0.051 ↑ 1.0 1 1

Index Scan using t_e20so1_pages_c_documentid_idx on t_e20so1_pages t_e20so1_pages_1 (cost=0.41..2.63 rows=1 width=113) (actual time=0.050..0.051 rows=1 loops=1)

  • Index Cond: (c_documentid = 401)
4. 0.004 22.893 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.87..3,076.85 rows=1 width=731) (actual time=21.346..22.893 rows=1 loops=1)

5. 0.008 22.869 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.45..3,074.22 rows=1 width=727) (actual time=21.323..22.869 rows=1 loops=1)

6. 9.827 22.837 ↑ 1.0 1 1

Hash Join (cost=0.03..3,071.58 rows=1 width=723) (actual time=21.291..22.837 rows=1 loops=1)

  • Hash Cond: (t_e20so1_pages_nvarchar.c_pagesid = t_e20so1_pages.c_pagesid)
7. 12.950 12.950 ↑ 1.0 56,156 1

Seq Scan on t_e20so1_pages_nvarchar (cost=0.00..2,860.95 rows=56,156 width=87) (actual time=0.030..12.950 rows=56,156 loops=1)

  • Filter: (c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid)
8. 0.004 0.060 ↑ 1.0 1 1

Hash (cost=0.02..0.02 rows=1 width=644) (actual time=0.059..0.060 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.056 0.056 ↑ 1.0 1 1

CTE Scan on cte_t_e20so1_pages t_e20so1_pages (cost=0.00..0.02 rows=1 width=644) (actual time=0.054..0.056 rows=1 loops=1)

10. 0.024 0.024 ↑ 1.0 1 1

Index Scan using "UQ_ba75e1ca-3d0c-4de2-a792-28fc05892d1f" on t_e20so1_pages_int (cost=0.42..2.64 rows=1 width=12) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((c_fieldid = 'd318fdbd-8867-4fbb-9cd1-37a146b23366'::uuid) AND (t_e20so1_pages.c_pagesid = c_pagesid))
11. 0.020 0.020 ↑ 1.0 1 1

Index Scan using "UQ_ba75e1ca-3d0c-4de2-a792-28fc05892d1f" on t_e20so1_pages_int "DocPagesInt" (cost=0.42..2.64 rows=1 width=12) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: ((c_fieldid = '587dc81e-4b1d-4a36-b740-af5af73b64af'::uuid) AND (t_e20so1_pages.c_pagesid = c_pagesid))
Planning time : 0.565 ms