explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KoPx

Settings
# exclusive inclusive rows x rows loops node
1. 0.552 12.102 ↓ 502.0 502 1

Nested Loop (cost=566.18..721.99 rows=1 width=76) (actual time=5.901..12.102 rows=502 loops=1)

2. 0.844 6.530 ↓ 502.0 502 1

Hash Join (cost=565.76..719.61 rows=1 width=24) (actual time=5.827..6.530 rows=502 loops=1)

  • Hash Cond: ((temp_opt_09272019102625_72056.pagelabel)::text = (t_e20so1_pages.c_pagealias)::text)
3. 0.509 0.509 ↑ 1.0 2,534 1

Seq Scan on temp_opt_09272019102625_72056 (cost=0.00..144.34 rows=2,534 width=30) (actual time=0.005..0.509 rows=2,534 loops=1)

4. 0.190 5.177 ↓ 516.0 516 1

Hash (cost=565.74..565.74 rows=1 width=17) (actual time=5.177..5.177 rows=516 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
5. 1.266 4.987 ↓ 516.0 516 1

Hash Right Join (cost=240.93..565.74 rows=1 width=17) (actual time=4.732..4.987 rows=516 loops=1)

  • Hash Cond: (t_e20so1_pages_int.c_pagesid = t_e20so1_pages.c_pagesid)
  • Filter: (t_e20so1_pages_int.c_intid IS NULL)
  • Rows Removed by Filter: 4,014
6. 1.799 1.799 ↑ 1.0 4,993 1

Seq Scan on t_e20so1_pages_int (cost=0.00..311.70 rows=4,993 width=16) (actual time=0.008..1.799 rows=4,993 loops=1)

  • Filter: (c_fieldid = 'd318fdbd-8867-4fbb-9cd1-37a146b23366'::uuid)
  • Rows Removed by Filter: 4,174
7. 0.770 1.922 ↑ 1.0 4,530 1

Hash (cost=184.30..184.30 rows=4,530 width=17) (actual time=1.922..1.922 rows=4,530 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 282kB
8. 1.152 1.152 ↑ 1.0 4,530 1

Seq Scan on t_e20so1_pages (cost=0.00..184.30 rows=4,530 width=17) (actual time=0.008..1.152 rows=4,530 loops=1)

9. 5.020 5.020 ↑ 1.0 1 502

Index Scan using temp_dat_09272019102625_72056_begbates_idx on temp_dat_09272019102625_72056 (cost=0.42..2.37 rows=1 width=12) (actual time=0.010..0.010 rows=1 loops=502)

  • Index Cond: ((begbates)::text = (temp_opt_09272019102625_72056.docid_cp)::text)
  • Filter: (importtype_cp <> 1)
Planning time : 0.642 ms
Execution time : 15.704 ms