explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mwIx

Settings
# exclusive inclusive rows x rows loops node
1. 2.762 48.282 ↑ 1.0 1 1

Aggregate (cost=8,320,352.60..8,320,352.61 rows=1 width=32) (actual time=48.282..48.282 rows=1 loops=1)

2. 0.076 45.520 ↑ 12.8 10 1

Subquery Scan on r (cost=41.59..8,320,351.64 rows=128 width=515) (actual time=11.226..45.520 rows=10 loops=1)

3. 9.897 45.444 ↑ 12.8 10 1

Hash Semi Join (cost=41.59..8,320,350.36 rows=128 width=683) (actual time=11.220..45.444 rows=10 loops=1)

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

CTE au

5. 0.006 0.042 ↑ 1.8 5 1

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

  • Group Key: user_roles.role_id
6. 0.000 0.036 ↑ 1.8 5 1

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

7. 0.035 0.035 ↑ 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.034..0.035 rows=4 loops=1)

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

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

9. 0.009 1.423 ↑ 13.0 31 1

Append (cost=0.00..2,943.22 rows=404 width=531) (actual time=0.065..1.423 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.335 0.335 ↑ 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.063..0.335 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.104 0.104 ↓ 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.104..0.104 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.061 0.061 ↑ 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.035..0.061 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.002 0.070 ↓ 0.0 0 1

Bitmap Heap Scan on objects_part03 (cost=137.34..255.39 rows=31 width=652) (actual time=0.070..0.070 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.068 0.068 ↓ 0.0 0 1

Bitmap Index Scan on objects_part03_pkey (cost=0.00..137.33 rows=31 width=0) (actual time=0.068..0.068 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.060 ↓ 0.0 0 1

Bitmap Heap Scan on objects_part04 (cost=137.26..254.29 rows=31 width=153) (actual time=0.060..0.060 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.060 0.060 ↓ 0.0 0 1

Bitmap Index Scan on objects_part04_pkey (cost=0.00..137.25 rows=31 width=0) (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[]))
18. 0.141 0.141 ↑ 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.015..0.141 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.065 0.065 ↑ 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.025..0.065 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.107 0.107 ↑ 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.061..0.107 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.124 0.124 ↑ 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.069..0.124 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.004 0.082 ↑ 31.0 1 1

Bitmap Heap Scan on objects_part09 (cost=137.42..257.17 rows=31 width=652) (actual time=0.081..0.082 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.078 0.078 ↑ 31.0 1 1

Bitmap Index Scan on objects_part09_pkey (cost=0.00..137.41 rows=31 width=0) (actual time=0.078..0.078 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.067 0.067 ↓ 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.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[]))
25. 0.076 0.076 ↓ 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.076..0.076 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.121 0.121 ↓ 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.121..0.121 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.011 0.134 ↓ 2.4 100 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
28. 0.008 0.123 ↓ 2.4 100 1

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

29. 0.045 0.045 ↑ 1.8 5 1

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

30. 0.070 0.070 ↓ 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.009..0.014 rows=20 loops=5)

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

SubPlan (for Hash Semi Join)

32. 4.900 30.570 ↑ 1.0 1 10

Aggregate (cost=374.11..374.12 rows=1 width=32) (actual time=3.057..3.057 rows=1 loops=10)

33. 1.030 25.670 ↓ 88.0 88 10

Nested Loop (cost=155.23..374.05 rows=1 width=498) (actual time=0.457..2.567 rows=88 loops=10)

34. 0.044 9.480 ↓ 152.0 152 10

Nested Loop (cost=155.23..167.90 rows=1 width=18) (actual time=0.433..0.948 rows=152 loops=10)

35. 1.434 7.920 ↓ 152.0 152 10

Nested Loop (cost=154.96..165.32 rows=1 width=20) (actual time=0.429..0.792 rows=152 loops=10)

  • Join Filter: (c_1.tep_id = t.id)
36. 0.530 4.970 ↓ 152.0 152 10

Merge Join (cost=154.67..159.45 rows=1 width=12) (actual time=0.420..0.497 rows=152 loops=10)

  • Merge Cond: (c_1.tep_id = crt.tep_id)
37. 0.260 0.260 ↓ 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=12) (actual time=0.009..0.026 rows=153 loops=10)

  • Index Cond: (object_type_id = objects_part.object_type_id)
  • Heap Fetches: 0
38. 0.240 4.180 ↓ 79.5 159 10

Sort (cost=154.38..154.39 rows=2 width=16) (actual time=0.408..0.418 rows=159 loops=10)

  • Sort Key: crt.tep_id
  • Sort Method: quicksort Memory: 27kB
39. 0.210 3.940 ↓ 79.5 159 10

Unique (cost=154.36..154.38 rows=2 width=16) (actual time=0.366..0.394 rows=159 loops=10)

40. 0.280 3.730 ↓ 88.0 176 10

Sort (cost=154.36..154.37 rows=2 width=16) (actual time=0.366..0.373 rows=176 loops=10)

  • Sort Key: crt.tep_id, crt.object_type_id
  • Sort Method: quicksort Memory: 30kB
41. 0.140 3.450 ↓ 88.0 176 10

Nested Loop (cost=0.42..154.35 rows=2 width=16) (actual time=0.014..0.345 rows=176 loops=10)

42. 0.010 0.010 ↑ 1.8 5 10

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

43. 3.300 3.300 ↓ 35.0 35 50

Index Only Scan using c_role_teps_roleid_tep_id_action_object_type_id_key on c_role_teps crt (cost=0.42..17.12 rows=1 width=18) (actual time=0.009..0.066 rows=35 loops=50)

  • Index Cond: ((roleid = au_1.authid) AND (action = 'show'::text) AND (object_type_id = objects_part.object_type_id))
  • Heap Fetches: 0
44. 1.516 1.516 ↑ 1.0 1 1,516

Index Scan using obj_teps_pkey on obj_teps t (cost=0.29..5.85 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1,516)

  • Index Cond: (id = crt.tep_id)
45. 1.516 1.516 ↑ 1.0 1 1,516

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=1,516)

  • Index Cond: (id = t.category_id)
  • Heap Fetches: 0
46. 4.548 15.160 ↑ 93.0 1 1,516

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

47. 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))
48. 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.50 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))
49. 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.65 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))
50. 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..50.37 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))
51. 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..41.08 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))
52. 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..78.76 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))
53. 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..13.86 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))
54. 0.322 2.160 ↑ 1.0 1 10

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

55. 0.094 0.590 ↓ 3.0 9 10

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

  • Hash Cond: ((t_1.name)::text = (cd.text)::text)
56. 0.126 0.126 ↑ 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.010..0.014 rows=11 loops=9)

  • Index Cond: (parent_id = objects_part.id_folder)
57. 0.040 0.370 ↓ 10.0 10 10

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
58. 0.037 0.330 ↓ 10.0 10 10

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

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

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

60. 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)
61. 0.110 0.110 ↑ 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.005..0.011 rows=11 loops=10)

  • Index Cond: (class_id = ot.file_tree_class_id)
62. 0.021 0.103 ↑ 1.5 166 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
63. 0.016 0.082 ↑ 1.5 166 1

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

64. 0.001 0.001 ↑ 1.8 5 1

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

65. 0.065 0.065 ↓ 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.009..0.013 rows=33 loops=5)

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

SubPlan (for Aggregate)

67. 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)

68. 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)

69. 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)
70. 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)
71. 0.261 0.870 ↑ 1.0 1 87

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

72. 0.040 0.609 ↓ 0.0 0 87

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

73. 0.261 0.261 ↓ 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.003..0.003 rows=0 loops=87)

  • Index Cond: (parent_id = t_1.id)
74. 0.308 0.308 ↑ 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.011..0.011 rows=1 loops=28)

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

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

76. 0.000 0.540 ↓ 0.0 0 10

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

77. 0.015 0.530 ↓ 0.0 0 10

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

  • Join Filter: (objects_part_1.object_type_id = c_3.object_type_id)
  • Rows Removed by Join Filter: 0
78. 0.016 0.490 ↓ 0.0 0 10

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

79. 0.020 0.210 ↓ 0.0 0 10

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

  • Group Key: c_obj_object.master_id
80. 0.000 0.190 ↓ 0.0 0 10

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

81. 0.100 0.100 ↓ 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.010..0.010 rows=0 loops=10)

  • Index Cond: (slave_id = objects_part.id)
82. 0.090 0.090 ↓ 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.009..0.009 rows=0 loops=10)

  • Index Cond: (master_id = objects_part.id)
  • Heap Fetches: 0
83. 0.008 0.264 ↑ 14.0 1 1

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

84. 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)
85. 0.029 0.029 ↑ 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.028..0.029 rows=1 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
  • Heap Fetches: 0
86. 0.019 0.019 ↓ 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.019..0.019 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
87. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
88. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
89. 0.020 0.020 ↓ 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.020..0.020 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
90. 0.023 0.023 ↓ 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.022..0.023 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
91. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
92. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
93. 0.059 0.059 ↓ 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.059..0.059 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
94. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
95. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
96. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
97. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (id = c_obj_object.master_id)
98. 0.003 0.025 ↑ 6.8 6 1

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

99. 0.002 0.022 ↑ 6.8 6 1

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

100. 0.000 0.000 ↑ 9.0 1 1

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

101. 0.020 0.020 ↓ 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.012..0.020 rows=6 loops=1)

  • Index Cond: ((roleid = au_3.authid) AND (action = 'show'::text))
  • Heap Fetches: 0
102. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

  • Index Cond: (id = objects_part_1.object_type_id)
  • Heap Fetches: 0
103. 0.620 0.700 ↑ 1.0 1 10

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

104. 0.080 0.080 ↓ 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.007..0.008 rows=0 loops=10)

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