explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LhBX3

Settings
# exclusive inclusive rows x rows loops node
1. 2.818 50.716 ↑ 1.0 1 1

Aggregate (cost=8,678,521.95..8,678,521.96 rows=1 width=32) (actual time=50.716..50.716 rows=1 loops=1)

2. 0.058 47.898 ↑ 12.8 10 1

Subquery Scan on r (cost=41.59..8,678,520.99 rows=128 width=515) (actual time=0.952..47.898 rows=10 loops=1)

3. 0.163 47.840 ↑ 12.8 10 1

Hash Semi Join (cost=41.59..8,678,519.71 rows=128 width=683) (actual time=0.946..47.840 rows=10 loops=1)

  • Hash Cond: (objects_part.object_type_id = c.object_type_id)
4.          

CTE au

5. 0.005 0.016 ↑ 1.8 5 1

HashAggregate (cost=4.55..4.64 rows=9 width=4) (actual time=0.015..0.016 rows=5 loops=1)

  • Group Key: user_roles.role_id
6. 0.001 0.011 ↑ 1.8 5 1

Append (cost=0.29..4.53 rows=9 width=4) (actual time=0.009..0.011 rows=5 loops=1)

7. 0.010 0.010 ↑ 2.0 4 1

Index Only Scan using user_roles_pkey on user_roles (cost=0.29..4.43 rows=8 width=4) (actual time=0.009..0.010 rows=4 loops=1)

  • Index Cond: (user_id = 10003)
  • Heap Fetches: 0
8. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

9. 0.007 0.849 ↑ 13.0 31 1

Append (cost=0.00..2,943.22 rows=404 width=531) (actual time=0.026..0.849 rows=31 loops=1)

10. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on objects_part (cost=0.00..0.00 rows=1 width=95) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
11. 0.147 0.147 ↑ 1.7 18 1

Index Scan using objects_part00_pkey on objects_part00 (cost=0.43..233.90 rows=31 width=95) (actual time=0.024..0.147 rows=18 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
12. 0.067 0.067 ↓ 0.0 0 1

Index Scan using objects_part01_pkey on objects_part01 (cost=0.42..243.36 rows=31 width=652) (actual time=0.067..0.067 rows=0 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
13. 0.043 0.043 ↑ 31.0 1 1

Index Scan using objects_part02_pkey on objects_part02 (cost=0.43..141.80 rows=31 width=652) (actual time=0.017..0.043 rows=1 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
14. 0.001 0.048 ↓ 0.0 0 1

Bitmap Heap Scan on objects_part03 (cost=137.34..255.39 rows=31 width=652) (actual time=0.048..0.048 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
15. 0.047 0.047 ↓ 0.0 0 1

Bitmap Index Scan on objects_part03_pkey (cost=0.00..137.33 rows=31 width=0) (actual time=0.046..0.047 rows=0 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
16. 0.000 0.043 ↓ 0.0 0 1

Bitmap Heap Scan on objects_part04 (cost=137.26..254.29 rows=31 width=153) (actual time=0.043..0.043 rows=0 loops=1)

  • Recheck Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
17. 0.043 0.043 ↓ 0.0 0 1

Bitmap Index Scan on objects_part04_pkey (cost=0.00..137.25 rows=31 width=0) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
18. 0.081 0.081 ↑ 10.3 3 1

Index Scan using objects_part05_pkey on objects_part05 (cost=0.43..261.03 rows=31 width=652) (actual time=0.011..0.081 rows=3 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
19. 0.053 0.053 ↑ 10.3 3 1

Index Scan using objects_part06_pkey on objects_part06 (cost=0.43..261.86 rows=31 width=652) (actual time=0.021..0.053 rows=3 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
20. 0.067 0.067 ↑ 7.8 4 1

Index Scan using objects_part07_pkey on objects_part07 (cost=0.43..213.27 rows=31 width=652) (actual time=0.042..0.067 rows=4 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
21. 0.073 0.073 ↑ 31.0 1 1

Index Scan using objects_part10_pkey on objects_part10 (cost=0.42..224.21 rows=31 width=153) (actual time=0.050..0.073 rows=1 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
22. 0.003 0.051 ↑ 31.0 1 1

Bitmap Heap Scan on objects_part09 (cost=137.42..257.17 rows=31 width=652) (actual time=0.051..0.051 rows=1 loops=1)

  • Recheck Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
  • Heap Blocks: exact=1
23. 0.048 0.048 ↑ 31.0 1 1

Bitmap Index Scan on objects_part09_pkey (cost=0.00..137.41 rows=31 width=0) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
24. 0.051 0.051 ↓ 0.0 0 1

Index Scan using objects_part08_pkey on objects_part08 (cost=0.42..254.34 rows=31 width=652) (actual time=0.051..0.051 rows=0 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
25. 0.057 0.057 ↓ 0.0 0 1

Index Scan using objects_part11_pkey on objects_part11 (cost=0.42..197.43 rows=31 width=652) (actual time=0.057..0.057 rows=0 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
26. 0.060 0.060 ↓ 0.0 0 1

Index Scan using objects_part12_pkey on objects_part12 (cost=0.43..145.17 rows=31 width=652) (actual time=0.060..0.060 rows=0 loops=1)

  • Index Cond: (id = ANY ('{485636381,485636453,485636527,485636595,485636732,485636759,485636941,499303100,485637170,485637211,13745612,418242518,444784994,142766749,602142839,643053110,147472630,147694533,634819806,85876358,11732186,569959619,650901281,604908375,13739999,148463538,358925609,489821401,680479054,671686642,518412887}'::integer[]))
27. 0.010 0.078 ↓ 2.4 100 1

Hash (cost=36.43..36.43 rows=41 width=8) (actual time=0.078..0.078 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
28. 0.010 0.068 ↓ 2.4 100 1

Nested Loop (cost=0.28..36.43 rows=41 width=8) (actual time=0.026..0.068 rows=100 loops=1)

29. 0.018 0.018 ↑ 1.8 5 1

CTE Scan on au (cost=0.00..0.18 rows=9 width=4) (actual time=0.017..0.018 rows=5 loops=1)

30. 0.040 0.040 ↓ 4.0 20 5

Index Only Scan using c_role_objtype_roleid_object_type_id_action_key on c_role_objtype c (cost=0.28..3.98 rows=5 width=10) (actual time=0.004..0.008 rows=20 loops=5)

  • Index Cond: ((roleid = au.authid) AND (action = 'show'::text))
  • Heap Fetches: 0
31.          

SubPlan (for Hash Semi Join)

32. 5.210 44.080 ↑ 1.0 1 10

Aggregate (cost=3,172.31..3,172.32 rows=1 width=32) (actual time=4.408..4.408 rows=1 loops=10)

33. 0.145 38.870 ↓ 22.0 88 10

Nested Loop (cost=0.85..3,172.08 rows=4 width=498) (actual time=0.082..3.887 rows=88 loops=10)

34. 1.040 37.850 ↓ 22.0 88 10

Nested Loop (cost=0.57..3,161.75 rows=4 width=500) (actual time=0.079..3.785 rows=88 loops=10)

35. 0.000 21.650 ↓ 11.7 152 10

Nested Loop (cost=0.57..281.95 rows=13 width=12) (actual time=0.065..2.165 rows=152 loops=10)

36. 0.230 0.230 ↓ 4.0 153 10

Index Only Scan using c_objtype_tep_object_type_id_tep_id_key on c_objtype_tep c_1 (cost=0.29..4.95 rows=38 width=4) (actual time=0.005..0.023 rows=153 loops=10)

  • Index Cond: (object_type_id = objects_part.object_type_id)
  • Heap Fetches: 0
37. 21.476 21.476 ↑ 1.0 1 1,534

Index Scan using obj_teps_pkey on obj_teps t (cost=0.29..7.29 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1,534)

  • Index Cond: (id = c_1.tep_id)
  • Filter: vvp.acl_object_types(10003, objects_part.object_type_id, id)
38. 4.548 15.160 ↑ 93.0 1 1,516

Append (cost=0.00..220.59 rows=93 width=496) (actual time=0.006..0.010 rows=1 loops=1,516)

39. 0.000 0.000 ↓ 0.0 0 1,516

Seq Scan on objtep_part (cost=0.00..0.00 rows=1 width=880) (actual time=0.000..0.000 rows=0 loops=1,516)

  • Filter: ((object_id = objects_part.id) AND (t.id = tep_id))
40. 3.032 3.032 ↑ 1.0 1 1,516

Index Scan using objtep_part00_object_id_tep_id_key on objtep_part00 (cost=0.57..8.56 rows=1 width=472) (actual time=0.002..0.002 rows=1 loops=1,516)

  • Index Cond: ((object_id = objects_part.id) AND (tep_id = t.id))
41. 1.516 1.516 ↓ 0.0 0 1,516

Index Scan using objtep_part01_object_id_tep_id_key on objtep_part01 (cost=0.56..12.88 rows=3 width=852) (actual time=0.001..0.001 rows=0 loops=1,516)

  • Index Cond: ((object_id = objects_part.id) AND (tep_id = t.id))
42. 1.516 1.516 ↓ 0.0 0 1,516

Index Scan using objtep_part02_object_id_tep_id_key on objtep_part02 (cost=0.57..53.42 rows=24 width=161) (actual time=0.001..0.001 rows=0 loops=1,516)

  • Index Cond: ((object_id = objects_part.id) AND (tep_id = t.id))
43. 1.516 1.516 ↓ 0.0 0 1,516

Index Scan using objtep_part03_object_id_tep_id_key on objtep_part03 (cost=0.56..44.60 rows=12 width=131) (actual time=0.001..0.001 rows=0 loops=1,516)

  • Index Cond: ((object_id = objects_part.id) AND (tep_id = t.id))
44. 1.516 1.516 ↓ 0.0 0 1,516

Index Scan using objtep_part04_object_id_tep_id_key on objtep_part04 (cost=0.57..86.67 rows=48 width=830) (actual time=0.001..0.001 rows=0 loops=1,516)

  • Index Cond: ((object_id = objects_part.id) AND (tep_id = t.id))
45. 1.516 1.516 ↓ 0.0 0 1,516

Index Scan using objtep_part05_object_id_tep_id_key on objtep_part05 (cost=0.56..14.47 rows=4 width=128) (actual time=0.001..0.001 rows=0 loops=1,516)

  • Index Cond: ((object_id = objects_part.id) AND (tep_id = t.id))
46. 0.875 0.875 ↑ 1.0 1 875

Index Only Scan using obj_tep_category_pkey on obj_tep_category ct (cost=0.28..2.58 rows=1 width=2) (actual time=0.001..0.001 rows=1 loops=875)

  • Index Cond: (id = t.category_id)
  • Heap Fetches: 0
47. 0.316 1.890 ↑ 1.0 1 10

Aggregate (cost=2,683.72..2,683.73 rows=1 width=32) (actual time=0.189..0.189 rows=1 loops=10)

48. 0.089 0.500 ↓ 3.0 9 10

Hash Semi Join (cost=110.08..159.62 rows=3 width=51) (actual time=0.044..0.050 rows=9 loops=10)

  • Hash Cond: ((t_1.name)::text = (cd.text)::text)
49. 0.081 0.081 ↑ 16.4 11 9

Index Scan using files_tree_parent_id_idx on files_tree t_1 (cost=0.56..49.60 rows=180 width=51) (actual time=0.006..0.009 rows=11 loops=9)

  • Index Cond: (parent_id = objects_part.id_folder)
50. 0.040 0.330 ↓ 10.0 10 10

Hash (cost=109.50..109.50 rows=1 width=75) (actual time=0.032..0.033 rows=10 loops=10)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
51. 0.042 0.290 ↓ 10.0 10 10

Hash Semi Join (cost=51.57..109.50 rows=1 width=75) (actual time=0.020..0.029 rows=10 loops=10)

  • Hash Cond: (cd.id = c_2.classval_id)
52. 0.040 0.160 ↓ 1.2 11 10

Nested Loop (cost=0.56..58.47 rows=9 width=79) (actual time=0.009..0.016 rows=11 loops=10)

53. 0.040 0.040 ↑ 1.0 1 10

Index Scan using object_types_pkey on object_types ot (cost=0.28..8.29 rows=1 width=2) (actual time=0.004..0.004 rows=1 loops=10)

  • Index Cond: (id = objects_part.object_type_id)
54. 0.080 0.080 ↑ 1.8 11 10

Index Scan using classifier_data_class_id_idx on classifier_data cd (cost=0.29..49.98 rows=20 width=81) (actual time=0.003..0.008 rows=11 loops=10)

  • Index Cond: (class_id = ot.file_tree_class_id)
55. 0.023 0.088 ↑ 1.5 166 1

Hash (cost=47.95..47.95 rows=245 width=4) (actual time=0.088..0.088 rows=166 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
56. 0.014 0.065 ↑ 1.5 166 1

Nested Loop (cost=0.29..47.95 rows=245 width=4) (actual time=0.020..0.065 rows=166 loops=1)

57. 0.001 0.001 ↑ 1.8 5 1

CTE Scan on au au_1 (cost=0.00..0.18 rows=9 width=4) (actual time=0.000..0.001 rows=5 loops=1)

58. 0.050 0.050 ↓ 1.2 33 5

Index Only Scan using c_role_folders_roleid_classval_id_action_key on c_role_folders c_2 (cost=0.29..5.04 rows=27 width=6) (actual time=0.006..0.010 rows=33 loops=5)

  • Index Cond: ((roleid = au_1.authid) AND (action = 'show'::text))
  • Heap Fetches: 0
59.          

SubPlan (for Aggregate)

60. 0.216 0.378 ↑ 1.0 1 27

Aggregate (cost=420.67..420.68 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=27)

61. 0.052 0.162 ↑ 46.0 1 27

Nested Loop (cost=1.13..420.32 rows=46 width=87) (actual time=0.005..0.006 rows=1 loops=27)

62. 0.054 0.054 ↑ 46.0 1 27

Index Scan using files_parent_id_idx on files f (cost=0.56..25.64 rows=46 width=79) (actual time=0.002..0.002 rows=1 loops=27)

  • Index Cond: (parent_id = t_1.id)
63. 0.056 0.056 ↑ 1.0 1 28

Index Scan using files_md5_pkey on files_md5 m (cost=0.56..8.58 rows=1 width=41) (actual time=0.002..0.002 rows=1 loops=28)

  • Index Cond: (id = f.md5)
64. 0.261 0.696 ↑ 1.0 1 87

Aggregate (cost=420.67..420.68 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=87)

65. 0.065 0.435 ↓ 0.0 0 87

Nested Loop (cost=1.13..420.32 rows=46 width=87) (actual time=0.005..0.005 rows=0 loops=87)

66. 0.174 0.174 ↓ 0.0 0 87

Index Scan using files_parent_id_idx on files f_1 (cost=0.56..25.64 rows=46 width=79) (actual time=0.002..0.002 rows=0 loops=87)

  • Index Cond: (parent_id = t_1.id)
67. 0.196 0.196 ↑ 1.0 1 28

Index Scan using files_md5_pkey on files_md5 m_1 (cost=0.56..8.58 rows=1 width=41) (actual time=0.007..0.007 rows=1 loops=28)

  • Index Cond: (id = f_1.md5)
68. 0.020 0.340 ↑ 1.0 1 10

Aggregate (cost=30,051.79..30,051.80 rows=1 width=32) (actual time=0.034..0.034 rows=1 loops=10)

69. 0.003 0.320 ↓ 0.0 0 10

Nested Loop (cost=38.83..30,051.10 rows=91 width=10) (actual time=0.021..0.032 rows=0 loops=10)

70. 0.011 0.310 ↓ 0.0 0 10

Nested Loop Semi Join (cost=38.55..30,024.49 rows=91 width=18) (actual time=0.019..0.031 rows=0 loops=10)

  • Join Filter: (objects_part_1.object_type_id = c_3.object_type_id)
  • Rows Removed by Join Filter: 0
71. 0.026 0.280 ↓ 0.0 0 10

Nested Loop (cost=38.27..29,810.83 rows=288 width=10) (actual time=0.017..0.028 rows=0 loops=10)

72. 0.020 0.130 ↓ 0.0 0 10

HashAggregate (cost=38.27..41.15 rows=288 width=8) (actual time=0.013..0.013 rows=0 loops=10)

  • Group Key: c_obj_object.master_id
73. 0.010 0.110 ↓ 0.0 0 10

Append (cost=0.43..37.55 rows=288 width=8) (actual time=0.011..0.011 rows=0 loops=10)

74. 0.050 0.050 ↓ 0.0 0 10

Index Scan using c_obj_object_slave_id_idx on c_obj_object (cost=0.43..17.32 rows=14 width=8) (actual time=0.005..0.005 rows=0 loops=10)

  • Index Cond: (slave_id = objects_part.id)
75. 0.050 0.050 ↓ 0.0 0 10

Index Only Scan using c_obj_object_master_id_slave_id_role_key on c_obj_object c_obj_object_1 (cost=0.56..17.36 rows=274 width=8) (actual time=0.005..0.005 rows=0 loops=10)

  • Index Cond: (master_id = objects_part.id)
  • Heap Fetches: 0
76. 0.004 0.124 ↑ 14.0 1 1

Append (cost=0.00..103.22 rows=14 width=10) (actual time=0.014..0.124 rows=1 loops=1)

77. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on objects_part objects_part_1 (cost=0.00..0.00 rows=1 width=10) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (c_obj_object.master_id = id)
78. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using objects_part00_id_object_type_id_idx on objects_part00 objects_part00_1 (cost=0.56..4.87 rows=1 width=10) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
  • Heap Fetches: 0
79. 0.009 0.009 ↓ 0.0 0 1

Index Scan using objects_part01_pkey on objects_part01 objects_part01_1 (cost=0.42..7.90 rows=1 width=10) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
80. 0.009 0.009 ↓ 0.0 0 1

Index Scan using objects_part02_pkey on objects_part02 objects_part02_1 (cost=0.43..8.31 rows=1 width=10) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
81. 0.008 0.008 ↓ 0.0 0 1

Index Scan using objects_part03_pkey on objects_part03 objects_part03_1 (cost=0.42..8.06 rows=1 width=10) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
82. 0.009 0.009 ↓ 0.0 0 1

Index Scan using objects_part04_pkey on objects_part04 objects_part04_1 (cost=0.42..8.10 rows=1 width=10) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
83. 0.010 0.010 ↓ 0.0 0 1

Index Scan using objects_part05_pkey on objects_part05 objects_part05_1 (cost=0.43..8.41 rows=1 width=10) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
84. 0.009 0.009 ↓ 0.0 0 1

Index Scan using objects_part06_pkey on objects_part06 objects_part06_1 (cost=0.43..8.39 rows=1 width=10) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
85. 0.007 0.007 ↓ 0.0 0 1

Index Scan using objects_part07_pkey on objects_part07 objects_part07_1 (cost=0.43..8.39 rows=1 width=10) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
86. 0.009 0.009 ↓ 0.0 0 1

Index Scan using objects_part10_pkey on objects_part10 objects_part10_1 (cost=0.42..8.28 rows=1 width=10) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
87. 0.009 0.009 ↓ 0.0 0 1

Index Scan using objects_part09_pkey on objects_part09 objects_part09_1 (cost=0.42..8.10 rows=1 width=10) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
88. 0.010 0.010 ↓ 0.0 0 1

Index Scan using objects_part08_pkey on objects_part08 objects_part08_1 (cost=0.42..8.05 rows=1 width=10) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
89. 0.009 0.009 ↓ 0.0 0 1

Index Scan using objects_part11_pkey on objects_part11 objects_part11_1 (cost=0.42..8.05 rows=1 width=10) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
90. 0.008 0.008 ↓ 0.0 0 1

Index Scan using objects_part12_pkey on objects_part12 objects_part12_1 (cost=0.43..8.31 rows=1 width=10) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
91. 0.002 0.019 ↑ 6.8 6 1

Materialize (cost=0.28..36.64 rows=41 width=8) (actual time=0.009..0.019 rows=6 loops=1)

92. 0.001 0.017 ↑ 6.8 6 1

Nested Loop (cost=0.28..36.43 rows=41 width=8) (actual time=0.009..0.017 rows=6 loops=1)

93. 0.001 0.001 ↑ 9.0 1 1

CTE Scan on au au_2 (cost=0.00..0.18 rows=9 width=4) (actual time=0.001..0.001 rows=1 loops=1)

94. 0.015 0.015 ↓ 1.2 6 1

Index Only Scan using c_role_objtype_roleid_object_type_id_action_key on c_role_objtype c_3 (cost=0.28..3.98 rows=5 width=10) (actual time=0.007..0.015 rows=6 loops=1)

  • Index Cond: ((roleid = au_2.authid) AND (action = 'show'::text))
  • Heap Fetches: 0
95. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using object_types_pkey on object_types ot_1 (cost=0.28..0.29 rows=1 width=2) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = objects_part_1.object_type_id)
  • Heap Fetches: 0
96. 0.380 0.440 ↑ 1.0 1 10

Aggregate (cost=31,869.74..31,869.75 rows=1 width=32) (actual time=0.044..0.044 rows=1 loops=10)

97. 0.060 0.060 ↓ 0.0 0 10

Index Scan using geom_data_numberarea on geom_data g (cost=0.56..18,135.01 rows=5,472 width=147) (actual time=0.006..0.006 rows=0 loops=10)

  • Index Cond: (numberarea = objects_part.numberarea)
  • Filter: (NOT isarchive)
Planning time : 6.445 ms
Execution time : 51.354 ms