explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hy2i : Q1

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 154.161 ↓ 4.0 4 1

Sort (cost=43,510.99..43,510.99 rows=1 width=240) (actual time=154.161..154.161 rows=4 loops=1)

  • Sort Key: ((a.attnum)::information_schema.cardinal_number)
  • Sort Method: quicksort Memory: 25kB
2.          

CTE table_source

3. 0.007 38.022 ↑ 1.0 1 1

Limit (cost=2,213.08..4,119.12 rows=1 width=96) (actual time=38.016..38.022 rows=1 loops=1)

4. 0.142 38.015 ↑ 1.0 1 1

Nested Loop Left Join (cost=2,213.08..4,119.12 rows=1 width=96) (actual time=38.015..38.015 rows=1 loops=1)

  • Join Filter: ((((nc_3.nspname)::information_schema.sql_identifier)::text = (((nv.nspname)::information_schema.sql_identifier))::text) AND (((c_3.relname)::information_schema.sql_identifier)::text = (((v.relname)::information_schema.sql_identifier))::text))
  • Rows Removed by Join Filter: 1059
5. 0.001 0.826 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.55..1,906.00 rows=1 width=128) (actual time=0.826..0.826 rows=1 loops=1)

6. 0.002 0.820 ↑ 1.0 1 1

Nested Loop (cost=0.00..1,897.40 rows=1 width=132) (actual time=0.820..0.820 rows=1 loops=1)

  • Join Filter: (nc_3.oid = c_3.relnamespace)
7. 0.042 0.042 ↑ 1.0 1 1

Seq Scan on pg_namespace nc_3 (cost=0.00..6.02 rows=1 width=68) (actual time=0.042..0.042 rows=1 loops=1)

  • Filter: ((NOT pg_is_other_temp_schema(oid)) AND (((nspname)::information_schema.sql_identifier)::text = 'osplatform'::text))
  • Rows Removed by Filter: 148
8. 0.776 0.776 ↑ 6.0 1 1

Seq Scan on pg_class c_3 (cost=0.00..1,891.31 rows=6 width=72) (actual time=0.776..0.776 rows=1 loops=1)

  • Filter: ((relkind = ANY ('{r,v,f,p}'::"char"[])) AND (lower(((relname)::information_schema.sql_identifier)::text) = 'osusr_j4v_devicedatabasebinary'::text) AND (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(oid, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
  • Rows Removed by Filter: 2912
9. 0.001 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.55..8.59 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)

10. 0.004 0.004 ↓ 0.0 0 1

Index Scan using pg_type_oid_index on pg_type t_1 (cost=0.41..8.43 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (c_3.reloftype = oid)
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pg_namespace_oid_index on pg_namespace nt_1 (cost=0.14..0.16 rows=1 width=4) (never executed)

  • Index Cond: (oid = t_1.typnamespace)
  • Heap Fetches: 0
12. 1.257 37.047 ↓ 81.5 1,059 1

Unique (cost=2,212.52..2,212.65 rows=13 width=192) (actual time=35.379..37.047 rows=1,059 loops=1)

13. 4.840 35.790 ↓ 596.5 7,754 1

Sort (cost=2,212.52..2,212.56 rows=13 width=192) (actual time=35.378..35.790 rows=7,754 loops=1)

  • Sort Key: ((v.relname)::information_schema.sql_identifier), ((nt_2.nspname)::information_schema.sql_identifier), ((t_2.relname)::information_schema.sql_identifier)
  • Sort Method: quicksort Memory: 1303kB
14. 2.598 30.950 ↓ 596.5 7,754 1

Nested Loop (cost=1.38..2,212.28 rows=13 width=192) (actual time=0.115..30.950 rows=7,754 loops=1)

15. 3.778 20.598 ↓ 596.5 7,754 1

Nested Loop (cost=1.23..2,209.29 rows=13 width=196) (actual time=0.110..20.598 rows=7,754 loops=1)

16. 1.364 9.066 ↓ 35.2 7,754 1

Nested Loop (cost=0.82..1,802.76 rows=220 width=132) (actual time=0.105..9.066 rows=7,754 loops=1)

17. 0.626 5.008 ↓ 898.0 898 1

Nested Loop (cost=0.41..1,796.36 rows=1 width=136) (actual time=0.100..5.008 rows=898 loops=1)

18. 0.153 2.586 ↓ 128.3 898 1

Nested Loop (cost=0.00..1,738.24 rows=7 width=132) (actual time=0.093..2.586 rows=898 loops=1)

  • Join Filter: (nv.oid = v.relnamespace)
  • Rows Removed by Join Filter: 148
19. 0.024 0.024 ↑ 1.0 1 1

Seq Scan on pg_namespace nv (cost=0.00..5.64 rows=1 width=68) (actual time=0.022..0.024 rows=1 loops=1)

  • Filter: (((nspname)::information_schema.sql_identifier)::text = 'osplatform'::text)
  • Rows Removed by Filter: 158
20. 2.409 2.409 ↑ 1.0 1,046 1

Seq Scan on pg_class v (cost=0.00..1,719.53 rows=1,046 width=72) (actual time=0.028..2.409 rows=1,046 loops=1)

  • Filter: (relkind = 'v'::"char")
  • Rows Removed by Filter: 2996
21. 1.796 1.796 ↑ 1.0 1 898

Index Scan using pg_depend_reference_index on pg_depend dv (cost=0.41..8.29 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=898)

  • Index Cond: ((refclassid = '1259'::oid) AND (refobjid = v.oid))
  • Filter: ((classid = '2618'::oid) AND (deptype = 'i'::"char"))
  • Rows Removed by Filter: 2
22. 2.694 2.694 ↓ 9.0 9 898

Index Scan using pg_depend_depender_index on pg_depend dt (cost=0.41..6.39 rows=1 width=8) (actual time=0.002..0.003 rows=9 loops=898)

  • Index Cond: ((classid = '2618'::oid) AND (objid = dv.objid))
  • Filter: ((refclassid = '1259'::oid) AND (dv.refobjid <> refobjid))
  • Rows Removed by Filter: 2
23. 7.754 7.754 ↑ 1.0 1 7,754

Index Scan using pg_class_oid_index on pg_class t_2 (cost=0.41..1.85 rows=1 width=72) (actual time=0.001..0.001 rows=1 loops=7,754)

  • Index Cond: (oid = dt.refobjid)
  • Filter: (pg_has_role(relowner, 'USAGE'::text) AND (relkind = ANY ('{r,v,f,p}'::"char"[])))
24. 7.754 7.754 ↑ 1.0 1 7,754

Index Scan using pg_namespace_oid_index on pg_namespace nt_2 (cost=0.14..0.20 rows=1 width=68) (actual time=0.001..0.001 rows=1 loops=7,754)

  • Index Cond: (oid = t_2.relnamespace)
25. 0.652 154.136 ↓ 4.0 4 1

Nested Loop Left Join (cost=29,768.58..39,391.86 rows=1 width=240) (actual time=116.523..154.136 rows=4 loops=1)

26. 0.006 153.476 ↓ 4.0 4 1

Nested Loop Left Join (cost=29,768.16..39,389.03 rows=1 width=1,333) (actual time=116.002..153.476 rows=4 loops=1)

27. 0.410 153.434 ↓ 4.0 4 1

Nested Loop Left Join (cost=29,767.47..39,382.65 rows=1 width=1,337) (actual time=115.984..153.434 rows=4 loops=1)

  • Join Filter: ((((nc.nspname)::information_schema.sql_identifier)::text = ("*SELECT* 1".table_schema)::text) AND (((c.relname)::information_schema.sql_identifier)::text = ("*SELECT* 1".table_name)::text) AND (((a.attname)::information_schema.sql_identifier)::text = ((a_1.attname)::information_schema.sql_identifier)::text))
  • Rows Removed by Join Filter: 3454
28. 2.731 100.552 ↓ 4.0 4 1

Hash Join (cost=5,986.33..15,535.57 rows=1 width=1,433) (actual time=65.809..100.552 rows=4 loops=1)

  • Hash Cond: ((((nc.nspname)::information_schema.sql_identifier)::text = (table_source.table_schema)::text) AND (((c.relname)::information_schema.sql_identifier)::text = (table_source.table_name)::text))
29. 3.526 59.788 ↓ 4.6 14,294 1

Hash Join (cost=5,986.30..15,496.55 rows=3,118 width=1,369) (actual time=10.028..59.788 rows=14,294 loops=1)

  • Hash Cond: (t.typnamespace = nt.oid)
30. 4.707 56.216 ↓ 4.6 14,294 1

Hash Left Join (cost=5,979.90..15,481.73 rows=3,118 width=1,309) (actual time=9.973..56.216 rows=14,294 loops=1)

  • Hash Cond: ((a.attrelid = ad.adrelid) AND (a.attnum = ad.adnum))
31. 2.845 50.825 ↓ 4.6 14,294 1

Hash Left Join (cost=5,738.55..15,224.01 rows=3,118 width=836) (actual time=9.284..50.825 rows=14,294 loops=1)

  • Hash Cond: (t.typbasetype = bt.oid)
  • Join Filter: (t.typtype = 'd'::"char")
32. 3.901 44.938 ↓ 4.6 14,294 1

Hash Join (cost=3,739.71..13,174.50 rows=3,118 width=766) (actual time=6.236..44.938 rows=14,294 loops=1)

  • Hash Cond: (a.atttypid = t.oid)
33. 2.964 37.053 ↓ 4.6 14,294 1

Hash Join (cost=1,758.77..11,185.37 rows=3,118 width=474) (actual time=2.244..37.053 rows=14,294 loops=1)

  • Hash Cond: (c.relnamespace = nc.oid)
34. 5.122 34.057 ↓ 3.1 14,294 1

Hash Join (cost=1,752.62..11,166.64 rows=4,661 width=414) (actual time=2.209..34.057 rows=14,294 loops=1)

  • Hash Cond: (a.attrelid = c.oid)
  • Join Filter: (pg_has_role(c.relowner, 'USAGE'::text) OR has_column_privilege(c.oid, a.attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text))
35. 26.770 26.770 ↑ 1.0 18,440 1

Seq Scan on pg_attribute a (cost=0.00..9,365.56 rows=18,441 width=342) (actual time=0.023..26.770 rows=18,440 loops=1)

  • Filter: ((NOT attisdropped) AND (attnum > 0))
  • Rows Removed by Filter: 8405
36. 0.217 2.165 ↑ 1.0 1,839 1

Hash (cost=1,729.63..1,729.63 rows=1,839 width=76) (actual time=2.164..2.165 rows=1,839 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 210kB
37. 1.948 1.948 ↑ 1.0 1,839 1

Seq Scan on pg_class c (cost=0.00..1,729.63 rows=1,839 width=76) (actual time=0.006..1.948 rows=1,839 loops=1)

  • Filter: (relkind = ANY ('{r,v,f,p}'::"char"[]))
  • Rows Removed by Filter: 2203
38. 0.001 0.032 ↑ 14.4 7 1

Hash (cost=4.89..4.89 rows=101 width=68) (actual time=0.032..0.032 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
39. 0.031 0.031 ↑ 14.4 7 1

Seq Scan on pg_namespace nc (cost=0.00..4.89 rows=101 width=68) (actual time=0.004..0.031 rows=7 loops=1)

  • Filter: (NOT pg_is_other_temp_schema(oid))
  • Rows Removed by Filter: 152
40. 0.625 3.984 ↑ 1.0 4,264 1

Hash (cost=1,927.64..1,927.64 rows=4,264 width=296) (actual time=3.984..3.984 rows=4,264 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1014kB
41. 3.359 3.359 ↑ 1.0 4,264 1

Seq Scan on pg_type t (cost=0.00..1,927.64 rows=4,264 width=296) (actual time=0.018..3.359 rows=4,264 loops=1)

42. 0.482 3.042 ↑ 1.0 4,264 1

Hash (cost=1,945.54..1,945.54 rows=4,264 width=74) (actual time=3.042..3.042 rows=4,264 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 514kB
43. 0.648 2.560 ↑ 1.0 4,264 1

Hash Join (cost=6.40..1,945.54 rows=4,264 width=74) (actual time=0.049..2.560 rows=4,264 loops=1)

  • Hash Cond: (bt.typnamespace = nbt.oid)
44. 1.868 1.868 ↑ 1.0 4,264 1

Seq Scan on pg_type bt (cost=0.00..1,927.64 rows=4,264 width=14) (actual time=0.003..1.868 rows=4,264 loops=1)

45. 0.019 0.044 ↓ 1.1 159 1

Hash (cost=4.51..4.51 rows=151 width=68) (actual time=0.043..0.044 rows=159 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
46. 0.025 0.025 ↓ 1.1 159 1

Seq Scan on pg_namespace nbt (cost=0.00..4.51 rows=151 width=68) (actual time=0.008..0.025 rows=159 loops=1)

47. 0.348 0.684 ↓ 1.0 1,955 1

Hash (cost=212.34..212.34 rows=1,934 width=479) (actual time=0.683..0.684 rows=1,955 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 995kB
48. 0.336 0.336 ↓ 1.0 1,955 1

Seq Scan on pg_attrdef ad (cost=0.00..212.34 rows=1,934 width=479) (actual time=0.003..0.336 rows=1,955 loops=1)

49. 0.017 0.046 ↓ 1.1 159 1

Hash (cost=4.51..4.51 rows=151 width=68) (actual time=0.046..0.046 rows=159 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
50. 0.029 0.029 ↓ 1.1 159 1

Seq Scan on pg_namespace nt (cost=0.00..4.51 rows=151 width=68) (actual time=0.012..0.029 rows=159 loops=1)

51. 0.005 38.033 ↑ 1.0 1 1

Hash (cost=0.02..0.02 rows=1 width=96) (actual time=38.033..38.033 rows=1 loops=1)

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

CTE Scan on table_source (cost=0.00..0.02 rows=1 width=96) (actual time=38.022..38.028 rows=1 loops=1)

53. 2.432 52.472 ↓ 864.0 864 4

Merge Join (cost=23,781.14..23,847.05 rows=1 width=160) (actual time=12.378..13.118 rows=864 loops=4)

  • Merge Cond: (((((nr.nspname)::information_schema.sql_identifier)::text) = ("*SELECT* 1".table_schema)::text) AND ((((r.relname)::information_schema.sql_identifier)::text) = ("*SELECT* 1".table_name)::text) AND ((((c_1.conname)::information_schema.sql_identifier)::text) = ("*SELECT* 1".constraint_name)::text))
54. 1.267 37.084 ↑ 2.1 864 4

Sort (cost=13,663.38..13,668.00 rows=1,845 width=256) (actual time=9.227..9.271 rows=864 loops=4)

  • Sort Key: (((nr.nspname)::information_schema.sql_identifier)::text), (((r.relname)::information_schema.sql_identifier)::text), (((c_1.conname)::information_schema.sql_identifier)::text)
  • Sort Method: quicksort Memory: 470kB
55. 0.711 35.817 ↑ 2.1 864 1

Hash Join (cost=9,767.71..13,563.30 rows=1,845 width=256) (actual time=28.029..35.817 rows=864 loops=1)

  • Hash Cond: ((r.oid = a_1.attrelid) AND (((information_schema._pg_expandarray(c_1.conkey))).x = a_1.attnum))
  • Join Filter: (pg_has_role(r.relowner, 'USAGE'::text) OR has_column_privilege(r.oid, a_1.attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text))
56. 3.860 7.707 ↑ 115.7 864 1

ProjectSet (cost=66.61..2,337.20 rows=100,000 width=341) (actual time=0.597..7.707 rows=864 loops=1)

57. 0.175 3.847 ↓ 8.6 864 1

Nested Loop (cost=66.61..1,811.70 rows=100 width=223) (actual time=0.436..3.847 rows=864 loops=1)

58. 0.246 2.808 ↓ 8.6 864 1

Hash Join (cost=66.47..1,794.43 rows=100 width=227) (actual time=0.425..2.808 rows=864 loops=1)

  • Hash Cond: (r.oid = c_1.conrelid)
59. 0.157 2.207 ↓ 1.5 793 1

Hash Join (cost=6.15..1,727.81 rows=530 width=136) (actual time=0.062..2.207 rows=793 loops=1)

  • Hash Cond: (r.relnamespace = nr.oid)
60. 2.008 2.008 ↑ 1.0 793 1

Seq Scan on pg_class r (cost=0.00..1,719.53 rows=793 width=76) (actual time=0.015..2.008 rows=793 loops=1)

  • Filter: (relkind = ANY ('{r,p}'::"char"[]))
  • Rows Removed by Filter: 3249
61. 0.002 0.042 ↑ 14.4 7 1

Hash (cost=4.89..4.89 rows=101 width=68) (actual time=0.042..0.042 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
62. 0.040 0.040 ↑ 14.4 7 1

Seq Scan on pg_namespace nr (cost=0.00..4.89 rows=101 width=68) (actual time=0.007..0.040 rows=7 loops=1)

  • Filter: (NOT pg_is_other_temp_schema(oid))
  • Rows Removed by Filter: 152
63. 0.107 0.355 ↓ 1.1 864 1

Hash (cost=50.77..50.77 rows=764 width=95) (actual time=0.355..0.355 rows=864 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 116kB
64. 0.248 0.248 ↓ 1.1 864 1

Seq Scan on pg_constraint c_1 (cost=0.00..50.77 rows=764 width=95) (actual time=0.004..0.248 rows=864 loops=1)

  • Filter: (contype = ANY ('{p,u,f}'::"char"[]))
  • Rows Removed by Filter: 92
65. 0.864 0.864 ↑ 1.0 1 864

Index Only Scan using pg_namespace_oid_index on pg_namespace nc_1 (cost=0.14..0.17 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=864)

  • Index Cond: (oid = c_1.connamespace)
  • Heap Fetches: 864
66. 3.973 27.399 ↑ 1.0 26,843 1

Hash (cost=9,298.45..9,298.45 rows=26,843 width=70) (actual time=27.399..27.399 rows=26,843 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2930kB
67. 23.426 23.426 ↑ 1.0 26,843 1

Seq Scan on pg_attribute a_1 (cost=0.00..9,298.45 rows=26,843 width=70) (actual time=0.006..23.426 rows=26,843 loops=1)

  • Filter: (NOT attisdropped)
  • Rows Removed by Filter: 2
68. 3.815 12.956 ↓ 3.6 2,860 4

Sort (cost=10,117.76..10,119.73 rows=791 width=128) (actual time=3.138..3.239 rows=2,860 loops=4)

  • Sort Key: "*SELECT* 1".table_schema, "*SELECT* 1".table_name, "*SELECT* 1".constraint_name
  • Sort Method: quicksort Memory: 493kB
69. 0.143 9.141 ↓ 3.6 2,860 1

Append (cost=75.26..10,079.68 rows=791 width=128) (actual time=0.566..9.141 rows=2,860 loops=1)

70. 0.080 2.971 ↓ 12.1 954 1

Subquery Scan on *SELECT* 1 (cost=75.26..1,925.04 rows=79 width=128) (actual time=0.565..2.971 rows=954 loops=1)

71. 0.352 2.891 ↓ 12.1 954 1

Hash Join (cost=75.26..1,924.25 rows=79 width=320) (actual time=0.564..2.891 rows=954 loops=1)

  • Hash Cond: (r_1.oid = c_2.conrelid)
72. 0.130 2.060 ↓ 2.1 793 1

Hash Join (cost=6.15..1,848.44 rows=373 width=132) (actual time=0.075..2.060 rows=793 loops=1)

  • Hash Cond: (r_1.relnamespace = nr_1.oid)
73. 1.887 1.887 ↓ 1.4 793 1

Seq Scan on pg_class r_1 (cost=0.00..1,840.79 rows=558 width=72) (actual time=0.014..1.887 rows=793 loops=1)

  • Filter: ((relkind = ANY ('{r,p}'::"char"[])) AND (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(oid, 'INSERT, UPDATE, REFERENCES'::text)))
  • Rows Removed by Filter: 3249
74. 0.002 0.043 ↑ 14.4 7 1

Hash (cost=4.89..4.89 rows=101 width=68) (actual time=0.043..0.043 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
75. 0.041 0.041 ↑ 14.4 7 1

Seq Scan on pg_namespace nr_1 (cost=0.00..4.89 rows=101 width=68) (actual time=0.007..0.041 rows=7 loops=1)

  • Filter: (NOT pg_is_other_temp_schema(oid))
  • Rows Removed by Filter: 152
76. 0.134 0.479 ↓ 1.1 956 1

Hash (cost=58.41..58.41 rows=856 width=69) (actual time=0.479..0.479 rows=956 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 106kB
77. 0.155 0.345 ↓ 1.1 956 1

Hash Join (cost=6.40..58.41 rows=856 width=69) (actual time=0.036..0.345 rows=956 loops=1)

  • Hash Cond: (c_2.connamespace = nc_2.oid)
78. 0.160 0.160 ↓ 1.1 956 1

Seq Scan on pg_constraint c_2 (cost=0.00..49.70 rows=856 width=73) (actual time=0.003..0.160 rows=956 loops=1)

  • Filter: (contype <> ALL ('{t,x}'::"char"[]))
79. 0.016 0.030 ↓ 1.1 159 1

Hash (cost=4.51..4.51 rows=151 width=4) (actual time=0.030..0.030 rows=159 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
80. 0.014 0.014 ↓ 1.1 159 1

Seq Scan on pg_namespace nc_2 (cost=0.00..4.51 rows=151 width=4) (actual time=0.002..0.014 rows=159 loops=1)

81. 0.163 6.027 ↓ 2.7 1,906 1

Subquery Scan on *SELECT* 2 (cost=6.56..8,150.69 rows=712 width=128) (actual time=0.081..6.027 rows=1,906 loops=1)

82. 1.409 5.864 ↓ 2.7 1,906 1

Nested Loop (cost=6.56..8,143.57 rows=712 width=320) (actual time=0.081..5.864 rows=1,906 loops=1)

83. 0.143 2.076 ↓ 2.1 793 1

Hash Join (cost=6.15..1,848.44 rows=373 width=136) (actual time=0.046..2.076 rows=793 loops=1)

  • Hash Cond: (r_2.relnamespace = nr_2.oid)
84. 1.897 1.897 ↓ 1.4 793 1

Seq Scan on pg_class r_2 (cost=0.00..1,840.79 rows=558 width=72) (actual time=0.006..1.897 rows=793 loops=1)

  • Filter: ((relkind = ANY ('{r,p}'::"char"[])) AND (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(oid, 'INSERT, UPDATE, REFERENCES'::text)))
  • Rows Removed by Filter: 3249
85. 0.002 0.036 ↑ 14.4 7 1

Hash (cost=4.89..4.89 rows=101 width=68) (actual time=0.036..0.036 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 0.034 0.034 ↑ 14.4 7 1

Seq Scan on pg_namespace nr_2 (cost=0.00..4.89 rows=101 width=68) (actual time=0.004..0.034 rows=7 loops=1)

  • Filter: (NOT pg_is_other_temp_schema(oid))
  • Rows Removed by Filter: 152
87. 2.379 2.379 ↑ 1.0 2 793

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a_2 (cost=0.41..16.78 rows=2 width=6) (actual time=0.002..0.003 rows=2 loops=793)

  • Index Cond: ((attrelid = r_2.oid) AND (attnum > 0))
  • Filter: (attnotnull AND (NOT attisdropped))
  • Rows Removed by Filter: 4
88. 0.004 0.036 ↓ 0.0 0 4

Nested Loop (cost=0.69..6.37 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=4)

89. 0.032 0.032 ↓ 0.0 0 4

Index Scan using pg_depend_reference_index on pg_depend dep (cost=0.41..6.01 rows=1 width=12) (actual time=0.008..0.008 rows=0 loops=4)

  • Index Cond: ((refclassid = '1259'::oid) AND (refobjid = c.oid) AND (refobjsubid = a.attnum))
  • Filter: ((classid = '1259'::oid) AND (deptype = 'i'::"char"))
  • Rows Removed by Filter: 1
90. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pg_sequence_seqrelid_index on pg_sequence seq (cost=0.27..0.35 rows=1 width=4) (never executed)

  • Index Cond: (seqrelid = dep.objid)
  • Heap Fetches: 0
91. 0.000 0.008 ↓ 0.0 0 4

Nested Loop (cost=0.42..0.50 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4)

92. 0.008 0.008 ↓ 0.0 0 4

Index Scan using pg_collation_oid_index on pg_collation co (cost=0.28..0.30 rows=1 width=72) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (a.attcollation = oid)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using pg_namespace_oid_index on pg_namespace nco (cost=0.14..0.20 rows=1 width=68) (never executed)

  • Index Cond: (oid = co.collnamespace)
  • Filter: ((nspname <> 'pg_catalog'::name) OR (co.collname <> 'default'::name))
Planning time : 3.880 ms
Execution time : 154.538 ms