explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HEZR

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

Sort (cost=3,016.30..3,016.31 rows=1 width=123) (actual time=19.121..19.121 rows=1 loops=1)

  • Sort Key: t_e20so1_pages.c_pagesid NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
2. 0.003 19.111 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.48..3,016.29 rows=1 width=123) (actual time=17.532..19.111 rows=1 loops=1)

3. 0.008 19.098 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.06..3,013.65 rows=1 width=119) (actual time=17.520..19.098 rows=1 loops=1)

4. 7.895 19.065 ↑ 1.0 1 1

Hash Join (cost=2.65..3,011.02 rows=1 width=115) (actual time=17.486..19.065 rows=1 loops=1)

  • Hash Cond: (t_e20so1_pages_nvarchar.c_pagesid = t_e20so1_pages.c_pagesid)
5. 11.154 11.154 ↑ 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.011..11.154 rows=56,156 loops=1)

  • Filter: (c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid)
6. 0.003 0.016 ↑ 1.0 1 1

Hash (cost=2.63..2.63 rows=1 width=36) (actual time=0.016..0.016 rows=1 loops=1)

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

Index Scan using t_e20so1_pages_c_documentid_idx on t_e20so1_pages (cost=0.41..2.63 rows=1 width=36) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (c_documentid = 401)
8. 0.025 0.025 ↑ 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.025..0.025 rows=1 loops=1)

  • Index Cond: ((c_fieldid = 'd318fdbd-8867-4fbb-9cd1-37a146b23366'::uuid) AND (t_e20so1_pages.c_pagesid = c_pagesid))
9. 0.010 0.010 ↑ 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.009..0.010 rows=1 loops=1)

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