explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cxsx : huge

Settings
# exclusive inclusive rows x rows loops node
1. 3.381 3,694.501 ↓ 774.5 11,617 1

Unique (cost=166,802.13..166,802.58 rows=15 width=234) (actual time=3,689.847..3,694.501 rows=11,617 loops=1)

  • Buffers: shared hit=56121
2. 62.798 3,691.120 ↓ 779.6 11,694 1

Sort (cost=166,802.13..166,802.17 rows=15 width=234) (actual time=3,689.845..3,691.12 rows=11,694 loops=1)

  • Sort Key: ((nc_4.nspname)::information_schema.sql_identifier), ((c_5.relname)::information_schema.sql_identifier), ((a_4.attnum)::information_schema.cardinal_number), ((COALESCE(((((CASE WHEN ((pg_relation_is_updatable((c_6.oid)::regclass, false) & 20) = 20) THEN 'YES'::text ELSE 'NO'::text END)::information_schema.yes_or_no))::text = 'YES'::text), true) AND COALESCE(((((CASE WHEN ((pg_relation_is_updatable((c_6.oid)::regclass, false) & 8) = 8) THEN 'YES'::text ELSE 'NO'::text END)::information_schema.yes_or_no))::text = 'YES'::text), true))), ((((CASE WHEN (nc_4.oid = pg_my_temp_schema()) THEN 'LOCAL TEMPORARY'::text WHEN (c_4.relkind = 'r'::"char") THEN 'BASE TABLE'::text WHEN (c_4.relkind = 'v'::"char") THEN 'VIEW'::text WHEN (c_4.relkind = 'f'::"char") THEN 'FOREIGN TABLE'::text ELSE NULL::text END)::information_schema.character_data)::text = 'VIEW'::text)), ((a_4.attname)::information_schema.sql_identifier), ((CASE WHEN (t_1.typtype = 'd'::"char") THEN CASE WHEN ((bt.typelem <> '0'::oid) AND (bt.typlen = '-1'::integer)) THEN 'ARRAY'::text WHEN (nbt.nspname = 'pg_catalog'::name) THEN format_type(t_1.typbasetype, NULL::integer) ELSE 'USER-DEFINED'::text END ELSE CASE WHEN ((t_1.typelem <> '0'::oid) AND (t_1.typlen = '-1'::integer)) THEN 'ARRAY'::text WHEN (nt_1.nspname = 'pg_catalog'::name) THEN format_type(a_4.atttypid, NULL::integer) ELSE 'USER-DEFINED'::text END END)::information_schema.character_data), ((information_schema._pg_char_max_length(information_schema._pg_truetypid(a_4.*, t_1.*), information_schema._pg_truetypmod(a_4.*, t_1.*)))::information_schema.cardinal_number), ((pg_get_expr(ad.adbin, ad.adrelid))::information_schema.character_data), (("*SELECT* 1_1".relname)::information_schema.sql_identifier), (("*SELECT* 1_1".attname)::information_schema.sql_identifier)
  • Sort Method: quicksort Memory: 1964kB
  • Buffers: shared hit=56121
3. 5.586 3,628.322 ↓ 779.6 11,694 1

Hash Join (cost=52,373.45..166,801.84 rows=15 width=234) (actual time=851.368..3,628.322 rows=11,694 loops=1)

  • Buffers: shared hit=56113
4. 1.974 3,066.626 ↓ 74.1 889 1

Hash Join (cost=47,962.44..162,390.59 rows=12 width=256) (actual time=295.218..3,066.626 rows=889 loops=1)

  • Buffers: shared hit=15444
5. 0.191 3,022.877 ↑ 689.1 1,478 1

Append (cost=899.03..105,142.37 rows=1,018,456 width=256) (actual time=4.215..3,022.877 rows=1,478 loops=1)

  • Buffers: shared hit=4422
6. 0.017 4.390 ↓ 151.0 151 1

Subquery Scan on *SELECT* 1_1 (cost=899.03..899.06 rows=1 width=256) (actual time=4.214..4.39 rows=151 loops=1)

  • Buffers: shared hit=3488
7. 0.070 4.373 ↓ 151.0 151 1

Unique (cost=899.03..899.05 rows=1 width=324) (actual time=4.213..4.373 rows=151 loops=1)

  • Buffers: shared hit=3488
8. 0.593 4.303 ↓ 302.0 302 1

Sort (cost=899.03..899.03 rows=1 width=324) (actual time=4.212..4.303 rows=302 loops=1)

  • Sort Key: nr.nspname, r.relname, r.relowner, a_1.attname, nc.nspname, c.conname
  • Sort Method: quicksort Memory: 180kB
  • Buffers: shared hit=3488
9. 0.181 3.710 ↓ 302.0 302 1

Nested Loop (cost=1.27..899.02 rows=1 width=324) (actual time=0.175..3.71 rows=302 loops=1)

  • Buffers: shared hit=3482
10. 0.268 3.227 ↓ 302.0 302 1

Nested Loop (cost=1.13..898.6 rows=1 width=264) (actual time=0.172..3.227 rows=302 loops=1)

  • Buffers: shared hit=2878
11. 0.178 2.355 ↓ 302.0 302 1

Nested Loop (cost=0.84..894.66 rows=1 width=212) (actual time=0.151..2.355 rows=302 loops=1)

  • Buffers: shared hit=1963
12. 0.230 1.875 ↓ 302.0 302 1

Nested Loop (cost=0.7..894.36 rows=1 width=152) (actual time=0.144..1.875 rows=302 loops=1)

  • Buffers: shared hit=1359
13. 0.032 1.041 ↓ 30.2 302 1

Nested Loop (cost=0.41..885.25 rows=10 width=76) (actual time=0.076..1.041 rows=302 loops=1)

  • Buffers: shared hit=453
14. 0.415 0.415 ↓ 1.0 99 1

Seq Scan on pg_constraint c (cost=0..125.4 rows=98 width=72) (actual time=0.027..0.415 rows=99 loops=1)

  • Filter: (c.contype = 'c'::"char")
  • Buffers: shared hit=54
15. 0.594 0.594 ↓ 3.0 3 99

Index Scan using pg_depend_depender_index on pg_depend d (cost=0.41..7.74 rows=1 width=12) (actual time=0.005..0.006 rows=3 loops=99)

  • Index Cond: ((d.classid = '2606'::oid) AND (d.objid = c.oid))
  • Filter: (d.refclassid = '1259'::oid)
  • Buffers: shared hit=399
16. 0.604 0.604 ↑ 1.0 1 302

Index Scan using pg_class_oid_index on pg_class r (cost=0.28..0.9 rows=1 width=76) (actual time=0.002..0.002 rows=1 loops=302)

  • Index Cond: (r.oid = d.refobjid)
  • Filter: (pg_has_role(r.relowner, 'USAGE'::text) AND (r.relkind = 'r'::"char"))
  • Buffers: shared hit=906
17. 0.302 0.302 ↑ 1.0 1 302

Index Scan using pg_namespace_oid_index on pg_namespace nr (cost=0.14..0.29 rows=1 width=68) (actual time=0.001..0.001 rows=1 loops=302)

  • Index Cond: (nr.oid = r.relnamespace)
  • Buffers: shared hit=604
18. 0.604 0.604 ↑ 1.0 1 302

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a_1 (cost=0.29..3.93 rows=1 width=70) (actual time=0.002..0.002 rows=1 loops=302)

  • Index Cond: ((a_1.attrelid = d.refobjid) AND (a_1.attnum = d.refobjsubid))
  • Filter: (NOT a_1.attisdropped)
  • Buffers: shared hit=915
19. 0.302 0.302 ↑ 1.0 1 302

Index Scan using pg_namespace_oid_index on pg_namespace nc (cost=0.14..0.41 rows=1 width=68) (actual time=0.001..0.001 rows=1 loops=302)

  • Index Cond: (nc.oid = c.connamespace)
  • Buffers: shared hit=604
20. 0.187 3,018.296 ↑ 767.5 1,327 1

Subquery Scan on *SELECT* 2_1 (cost=363.95..104,243.32 rows=1,018,455 width=256) (actual time=236.224..3,018.296 rows=1,327 loops=1)

  • Buffers: shared hit=934
21. 2,413.308 3,018.109 ↑ 767.5 1,327 1

Nested Loop (cost=363.95..94,058.77 rows=1,018,455 width=324) (actual time=236.224..3,018.109 rows=1,327 loops=1)

  • Buffers: shared hit=934
22. 6.546 18.711 ↓ 7.9 12,470 1

Hash Join (cost=350.64..2,236.4 rows=1,579 width=134) (actual time=2.113..18.711 rows=12,470 loops=1)

  • Buffers: shared hit=876
23. 10.083 10.083 ↑ 1.0 29,520 1

Seq Scan on pg_attribute a_2 (cost=0..1,759.27 rows=29,520 width=70) (actual time=0.022..10.083 rows=29,520 loops=1)

  • Filter: (NOT a_2.attisdropped)
  • Buffers: shared hit=732
24. 0.118 2.082 ↓ 3.0 562 1

Hash (cost=348.31..348.31 rows=187 width=68) (actual time=2.082..2.082 rows=562 loops=1)

  • Buffers: shared hit=144
25. 0.185 1.964 ↓ 3.0 562 1

Hash Join (cost=13.31..348.31 rows=187 width=68) (actual time=0.13..1.964 rows=562 loops=1)

  • Buffers: shared hit=144
26. 1.678 1.678 ↓ 3.0 562 1

Seq Scan on pg_class r_1 (cost=0..332.43 rows=187 width=72) (actual time=0.024..1.678 rows=562 loops=1)

  • Filter: (pg_has_role(r_1.relowner, 'USAGE'::text) AND (r_1.relkind = 'r'::"char"))
  • Buffers: shared hit=140
27. 0.043 0.101 ↓ 1.0 237 1

Hash (cost=10.36..10.36 rows=236 width=4) (actual time=0.101..0.101 rows=237 loops=1)

  • Buffers: shared hit=4
28. 0.058 0.058 ↓ 1.0 237 1

Seq Scan on pg_namespace nr_1 (cost=0..10.36 rows=236 width=4) (actual time=0.008..0.058 rows=237 loops=1)

  • Buffers: shared hit=4
29. 585.263 586.090 ↓ 1.0 1,298 12,470

Materialize (cost=13.31..164.64 rows=1,290 width=183) (actual time=0..0.047 rows=1,298 loops=12,470)

  • Buffers: shared hit=58
30. 0.429 0.827 ↓ 1.0 1,298 1

Hash Join (cost=13.31..158.19 rows=1,290 width=183) (actual time=0.103..0.827 rows=1,298 loops=1)

  • Buffers: shared hit=58
31. 0.315 0.315 ↓ 1.0 1,298 1

Seq Scan on pg_constraint c_1 (cost=0..127.14 rows=1,290 width=123) (actual time=0.009..0.315 rows=1,298 loops=1)

  • Filter: (c_1.contype = ANY ('{p,u,f}'::"char"[]))
  • Buffers: shared hit=54
32. 0.049 0.083 ↓ 1.0 237 1

Hash (cost=10.36..10.36 rows=236 width=68) (actual time=0.083..0.083 rows=237 loops=1)

  • Buffers: shared hit=4
33. 0.034 0.034 ↓ 1.0 237 1

Seq Scan on pg_namespace nc_1 (cost=0..10.36 rows=236 width=68) (actual time=0.005..0.034 rows=237 loops=1)

  • Buffers: shared hit=4
34. 0.580 41.775 ↓ 813.0 813 1

Hash (cost=47,063.39..47,063.39 rows=1 width=320) (actual time=41.775..41.775 rows=813 loops=1)

  • Buffers: shared hit=11022
35. 0.862 41.195 ↓ 813.0 813 1

Nested Loop (cost=43,940.21..47,063.39 rows=1 width=320) (actual time=33.604..41.195 rows=813 loops=1)

  • Buffers: shared hit=11022
36. 0.422 38.689 ↓ 822.0 822 1

Nested Loop (cost=43,939.93..47,062.35 rows=1 width=320) (actual time=33.584..38.689 rows=822 loops=1)

  • Buffers: shared hit=8480
37. 1.886 35.801 ↓ 822.0 822 1

Merge Join (cost=43,939.65..47,061.98 rows=1 width=296) (actual time=33.568..35.801 rows=822 loops=1)

  • Buffers: shared hit=6007
38. 8.459 24.117 ↑ 104.0 1,327 1

Sort (cost=41,335.12..41,680.12 rows=138,000 width=296) (actual time=23.854..24.117 rows=1,327 loops=1)

  • Sort Key: (((ss.nc_nspname)::information_schema.sql_identifier)::text), (((ss.conname)::information_schema.sql_identifier)::text), (((ss.nr_nspname)::information_schema.sql_identifier)::text), (((ss.relname)::information_schema.sql_identifier)::text)
  • Sort Method: quicksort Memory: 733kB
  • Buffers: shared hit=232
39. 0.952 15.658 ↑ 104.0 1,327 1

Subquery Scan on ss (cost=356.93..2,598.85 rows=138,000 width=296) (actual time=1.739..15.658 rows=1,327 loops=1)

  • Buffers: shared hit=232
40. 12.010 14.706 ↑ 104.0 1,327 1

Hash Join (cost=356.93..1,218.85 rows=138,000 width=341) (actual time=1.731..14.706 rows=1,327 loops=1)

  • Buffers: shared hit=232
41. 0.343 2.599 ↓ 9.4 1,298 1

Hash Join (cost=343.62..479.83 rows=138 width=227) (actual time=1.218..2.599 rows=1,298 loops=1)

  • Buffers: shared hit=198
42. 0.491 2.153 ↓ 6.3 1,298 1

Hash Join (cost=330.71..464.76 rows=207 width=167) (actual time=1.107..2.153 rows=1,298 loops=1)

  • Buffers: shared hit=194
43. 0.572 0.572 ↓ 1.0 1,298 1

Seq Scan on pg_constraint c_2 (cost=0..127.14 rows=1,290 width=95) (actual time=0.007..0.572 rows=1,298 loops=1)

  • Filter: (c_2.contype = ANY ('{p,u,f}'::"char"[]))
  • Buffers: shared hit=54
44. 0.142 1.090 ↑ 1.0 562 1

Hash (cost=323.69..323.69 rows=562 width=76) (actual time=1.09..1.09 rows=562 loops=1)

  • Buffers: shared hit=140
45. 0.948 0.948 ↑ 1.0 562 1

Seq Scan on pg_class r_2 (cost=0..323.69 rows=562 width=76) (actual time=0.01..0.948 rows=562 loops=1)

  • Filter: (r_2.relkind = 'r'::"char")
  • Buffers: shared hit=140
46. 0.012 0.103 ↑ 4.5 35 1

Hash (cost=10.95..10.95 rows=157 width=68) (actual time=0.103..0.103 rows=35 loops=1)

  • Buffers: shared hit=4
47. 0.091 0.091 ↑ 4.5 35 1

Seq Scan on pg_namespace nr_2 (cost=0..10.95 rows=157 width=68) (actual time=0.009..0.091 rows=35 loops=1)

  • Filter: (NOT pg_is_other_temp_schema(nr_2.oid))
  • Buffers: shared hit=4
48. 0.039 0.097 ↓ 1.0 237 1

Hash (cost=10.36..10.36 rows=236 width=68) (actual time=0.097..0.097 rows=237 loops=1)

  • Buffers: shared hit=4
49. 0.058 0.058 ↓ 1.0 237 1

Seq Scan on pg_namespace nc_2 (cost=0..10.36 rows=236 width=68) (actual time=0.013..0.058 rows=237 loops=1)

  • Buffers: shared hit=4
50. 3.998 9.798 ↓ 1.1 822 1

Sort (cost=2,604.53..2,606.45 rows=770 width=128) (actual time=9.704..9.798 rows=822 loops=1)

  • Sort Key: "*SELECT* 1".constraint_schema, "*SELECT* 1".constraint_name, "*SELECT* 1".table_schema, "*SELECT* 1".table_name
  • Sort Method: quicksort Memory: 114kB
  • Buffers: shared hit=5775
51. 0.067 5.800 ↓ 1.1 817 1

Append (cost=0.57..2,567.61 rows=770 width=128) (actual time=0.051..5.8 rows=817 loops=1)

  • Buffers: shared hit=5775
52. 0.099 5.731 ↓ 817.0 817 1

Subquery Scan on *SELECT* 1 (cost=0.57..205.04 rows=1 width=128) (actual time=0.05..5.731 rows=817 loops=1)

  • Buffers: shared hit=5775
53. 1.053 5.632 ↓ 817.0 817 1

Nested Loop (cost=0.57..205.03 rows=1 width=288) (actual time=0.049..5.632 rows=817 loops=1)

  • Buffers: shared hit=5775
54. 0.405 3.762 ↓ 817.0 817 1

Nested Loop (cost=0.43..204.78 rows=1 width=196) (actual time=0.039..3.762 rows=817 loops=1)

  • Buffers: shared hit=4141
55. 0.368 2.540 ↓ 817.0 817 1

Nested Loop (cost=0.28..201.18 rows=1 width=136) (actual time=0.035..2.54 rows=817 loops=1)

  • Buffers: shared hit=2507
56. 0.538 0.538 ↓ 116.7 817 1

Seq Scan on pg_constraint c_3 (cost=0..142.8 rows=7 width=72) (actual time=0.02..0.538 rows=817 loops=1)

  • Filter: ((c_3.contype <> ALL ('{t,x}'::"char"[])) AND (((CASE c_3.contype WHEN 'c'::"char" THEN 'CHECK'::text WHEN 'f'::"char" THEN 'FOREIGN KEY'::text WHEN 'p'::"char" THEN 'PRIMARY KEY'::text WHEN 'u'::"char" THEN 'UNIQUE'::text ELSE NULL::text END)::information_schema.character_data)::text = 'FOREIGN KEY'::text))
  • Buffers: shared hit=54
57. 1.634 1.634 ↑ 1.0 1 817

Index Scan using pg_class_oid_index on pg_class r_3 (cost=0.28..8.33 rows=1 width=72) (actual time=0.002..0.002 rows=1 loops=817)

  • Index Cond: (r_3.oid = c_3.conrelid)
  • Filter: ((r_3.relkind = 'r'::"char") AND (pg_has_role(r_3.relowner, 'USAGE'::text) OR has_table_privilege(r_3.oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(r_3.oid, 'INSERT, UPDATE, REFERENCES'::text)))
  • Buffers: shared hit=2453
58. 0.817 0.817 ↑ 1.0 1 817

Index Scan using pg_namespace_oid_index on pg_namespace nc_3 (cost=0.14..3.59 rows=1 width=68) (actual time=0.001..0.001 rows=1 loops=817)

  • Index Cond: (nc_3.oid = c_3.connamespace)
  • Buffers: shared hit=1634
59. 0.817 0.817 ↑ 1.0 1 817

Index Scan using pg_namespace_oid_index on pg_namespace nr_3 (cost=0.14..0.23 rows=1 width=68) (actual time=0.001..0.001 rows=1 loops=817)

  • Index Cond: (nr_3.oid = r_3.relnamespace)
  • Filter: (NOT pg_is_other_temp_schema(nr_3.oid))
  • Buffers: shared hit=1634
60. 0.000 0.002 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=448.85..2,362.57 rows=769 width=128) (actual time=0.002..0.002 rows=0 loops=1)

61. 0.002 0.002 ↓ 0.0 0 1

Result (cost=448.85..2,354.88 rows=769 width=288) (actual time=0.002..0.002 rows=0 loops=1)

62. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=448.85..2,354.88 rows=769 width=288) (never executed)

63. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on pg_attribute a_3 (cost=0..1,833.09 rows=10,224 width=6) (never executed)

  • Filter: (a_3.attnotnull AND (NOT a_3.attisdropped) AND (a_3.attnum > 0))
64. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=445.56..445.56 rows=263 width=136) (never executed)

65. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=12.91..445.56 rows=263 width=136) (never executed)

66. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on pg_class r_4 (cost=0..428.54 rows=395 width=72) (never executed)

  • Filter: ((r_4.relkind = 'r'::"char") AND (pg_has_role(r_4.relowner, 'USAGE'::text) OR has_table_privilege(r_4.oid, 'INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(r_4.oid, 'INSERT, UPDATE, REFERENCES'::text)))
67. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=10.95..10.95 rows=157 width=68) (never executed)

68. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on pg_namespace nr_4 (cost=0..10.95 rows=157 width=68) (never executed)

  • Filter: (NOT pg_is_other_temp_schema(nr_4.oid))
69. 2.466 2.466 ↑ 1.0 1 822

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.29..0.36 rows=1 width=70) (actual time=0.003..0.003 rows=1 loops=822)

  • Index Cond: ((a.attrelid = ss.roid) AND (a.attnum = (ss.x).x))
  • Filter: ((NOT a.attisdropped) AND (pg_has_role(ss.relowner, 'USAGE'::text) OR has_column_privilege(ss.roid, a.attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
  • Buffers: shared hit=2473
70. 1.644 1.644 ↓ 0.0 0 822

Index Scan using pg_constraint_conname_nsp_index on pg_constraint p (cost=0.28..0.66 rows=1 width=64) (actual time=0.002..0.002 rows=0 loops=822)

  • Index Cond: (p.conname = ("*SELECT* 1".constraint_name)::name)
  • Filter: ((p.contype = 'f'::"char") AND (array_length(p.confkey, 1) > 1))
  • Buffers: shared hit=2542
71. 3.464 556.110 ↓ 774.5 11,617 1

Hash (cost=4,410.75..4,410.75 rows=15 width=170) (actual time=556.11..556.11 rows=11,617 loops=1)

  • Buffers: shared hit=40669
72. 64.324 552.646 ↓ 774.5 11,617 1

Sort (cost=4,410.56..4,410.6 rows=15 width=170) (actual time=550.977..552.646 rows=11,617 loops=1)

  • Sort Key: ((nc_4.nspname)::information_schema.sql_identifier), ((c_5.relname)::information_schema.sql_identifier), ((a_4.attnum)::information_schema.cardinal_number)
  • Sort Method: quicksort Memory: 1942kB
  • Buffers: shared hit=40669
73. 225.068 488.322 ↓ 774.5 11,617 1

Hash Join (cost=3,931.55..4,410.27 rows=15 width=170) (actual time=163.825..488.322 rows=11,617 loops=1)

  • Buffers: shared hit=40669
74. 11.181 263.177 ↓ 774.5 11,617 1

Nested Loop (cost=3,917.56..4,384 rows=15 width=1,883) (actual time=163.483..263.177 rows=11,617 loops=1)

  • Buffers: shared hit=28229
75. 10.702 240.379 ↓ 774.5 11,617 1

Hash Join (cost=3,917.14..4,358.65 rows=15 width=1,887) (actual time=163.474..240.379 rows=11,617 loops=1)

  • Buffers: shared hit=4995
76. 0.182 89.549 ↓ 2.1 207 1

Hash Join (cost=12.91..452.46 rows=97 width=192) (actual time=0.439..89.549 rows=207 loops=1)

  • Buffers: shared hit=3169
77. 89.256 89.256 ↓ 1.4 207 1

Seq Scan on pg_class c_6 (cost=0..438.03 rows=146 width=132) (actual time=0.317..89.256 rows=207 loops=1)

  • Filter: ((c_6.relkind = 'v'::"char") AND (pg_has_role(c_6.relowner, 'USAGE'::text) OR has_table_privilege(c_6.oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(c_6.oid, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
  • Buffers: shared hit=3165
78. 0.010 0.111 ↑ 4.5 35 1

Hash (cost=10.95..10.95 rows=157 width=68) (actual time=0.111..0.111 rows=35 loops=1)

  • Buffers: shared hit=4
79. 0.101 0.101 ↑ 4.5 35 1

Seq Scan on pg_namespace nc_6 (cost=0..10.95 rows=157 width=68) (actual time=0.014..0.101 rows=35 loops=1)

  • Filter: (NOT pg_is_other_temp_schema(nc_6.oid))
  • Buffers: shared hit=4
80. 13.223 140.128 ↓ 774.5 11,617 1

Hash (cost=3,904..3,904 rows=15 width=1,951) (actual time=140.128..140.128 rows=11,617 loops=1)

  • Buffers: shared hit=1826
81. 8.036 126.905 ↓ 774.5 11,617 1

Merge Join (cost=3,867.14..3,904 rows=15 width=1,951) (actual time=114.261..126.905 rows=11,617 loops=1)

  • Buffers: shared hit=1826
82. 2.119 4.650 ↓ 1.6 570 1

Sort (cost=469.36..470.23 rows=346 width=137) (actual time=4.519..4.65 rows=570 loops=1)

  • Sort Key: (((c_4.relname)::information_schema.sql_identifier)::text), (((nc_4.nspname)::information_schema.sql_identifier)::text)
  • Sort Method: quicksort Memory: 176kB
  • Buffers: shared hit=619
83. 0.317 2.531 ↓ 1.6 570 1

Hash Join (cost=16.38..454.77 rows=346 width=137) (actual time=0.796..2.531 rows=570 loops=1)

  • Buffers: shared hit=619
84. 1.469 1.469 ↓ 1.4 769 1

Seq Scan on pg_class c_4 (cost=0..432.91 rows=541 width=73) (actual time=0.029..1.469 rows=769 loops=1)

  • Filter: ((c_4.relkind = ANY ('{r,v,f}'::"char"[])) AND (pg_has_role(c_4.relowner, 'USAGE'::text) OR has_table_privilege(c_4.oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(c_4.oid, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
  • Buffers: shared hit=140
85. 0.012 0.745 ↑ 5.2 29 1

Hash (cost=14.49..14.49 rows=151 width=68) (actual time=0.745..0.745 rows=29 loops=1)

  • Buffers: shared hit=476
86. 0.733 0.733 ↑ 5.2 29 1

Seq Scan on pg_namespace nc_4 (cost=0..14.49 rows=151 width=68) (actual time=0.042..0.733 rows=29 loops=1)

  • Filter: ((NOT pg_is_other_temp_schema(nc_4.oid)) AND (lower(((nc_4.nspname)::information_schema.sql_identifier)::text) <> ALL ('{pg_catalog,information_schema,tcache,tsystem,sunext,import,z_99_drop,x_900_export}'::text[])))
  • Buffers: shared hit=476
87. 58.546 114.219 ↓ 7.6 13,400 1

Sort (cost=3,397.77..3,402.15 rows=1,752 width=1,814) (actual time=109.66..114.219 rows=13,400 loops=1)

  • Sort Key: (((c_5.relname)::information_schema.sql_identifier)::text), (((nc_5.nspname)::information_schema.sql_identifier)::text)
  • Sort Method: quicksort Memory: 15141kB
  • Buffers: shared hit=1207
88. 7.280 55.673 ↓ 7.6 13,400 1

Hash Join (cost=2,849.28..3,303.39 rows=1,752 width=1,814) (actual time=35.788..55.673 rows=13,400 loops=1)

  • Buffers: shared hit=1207
89. 2.415 48.309 ↓ 7.6 13,400 1

Hash Join (cost=2,835.97..3,265.99 rows=1,752 width=1,754) (actual time=35.692..48.309 rows=13,400 loops=1)

  • Buffers: shared hit=1203
90. 3.843 43.925 ↓ 7.6 13,400 1

Hash Join (cost=2,566.42..2,967.97 rows=1,752 width=1,684) (actual time=33.691..43.925 rows=13,400 loops=1)

  • Buffers: shared hit=1114
91. 5.520 37.651 ↓ 7.6 13,400 1

Hash Join (cost=2,342.89..2,720.35 rows=1,752 width=893) (actual time=31.239..37.651 rows=13,400 loops=1)

  • Buffers: shared hit=1029
92. 0.952 0.952 ↓ 1.0 1,897 1

Seq Scan on pg_attrdef ad (cost=0..318.95 rows=1,895 width=466) (actual time=0.028..0.952 rows=1,897 loops=1)

  • Buffers: shared hit=150
93. 7.660 31.179 ↓ 7.6 13,400 1

Hash (cost=2,316.61..2,316.61 rows=1,752 width=433) (actual time=31.179..31.179 rows=13,400 loops=1)

  • Buffers: shared hit=876
94. 8.185 23.519 ↓ 7.6 13,400 1

Hash Join (cost=355.37..2,316.61 rows=1,752 width=433) (actual time=1.437..23.519 rows=13,400 loops=1)

  • Buffers: shared hit=876
95. 13.925 13.925 ↑ 1.0 21,547 1

Seq Scan on pg_attribute a_4 (cost=0..1,833.09 rows=21,549 width=305) (actual time=0.014..13.925 rows=21,547 loops=1)

  • Filter: ((NOT a_4.attisdropped) AND (a_4.attnum > 0))
  • Buffers: shared hit=732
96. 0.239 1.409 ↓ 1.5 756 1

Hash (cost=348.97..348.97 rows=512 width=136) (actual time=1.409..1.409 rows=756 loops=1)

  • Buffers: shared hit=144
97. 0.212 1.170 ↓ 1.5 756 1

Hash Join (cost=12.91..348.97 rows=512 width=136) (actual time=0.167..1.17 rows=756 loops=1)

  • Buffers: shared hit=144
98. 0.809 0.809 ↑ 1.0 769 1

Seq Scan on pg_class c_5 (cost=0..328.06 rows=769 width=76) (actual time=0.008..0.809 rows=769 loops=1)

  • Filter: (c_5.relkind = ANY ('{r,v,f}'::"char"[]))
  • Buffers: shared hit=140
99. 0.015 0.149 ↑ 4.5 35 1

Hash (cost=10.95..10.95 rows=157 width=68) (actual time=0.149..0.149 rows=35 loops=1)

  • Buffers: shared hit=4
100. 0.134 0.134 ↑ 4.5 35 1

Seq Scan on pg_namespace nc_5 (cost=0..10.95 rows=157 width=68) (actual time=0.007..0.134 rows=35 loops=1)

  • Filter: (NOT pg_is_other_temp_schema(nc_5.oid))
  • Buffers: shared hit=4
101. 0.892 2.431 ↑ 1.0 2,379 1

Hash (cost=193.79..193.79 rows=2,379 width=795) (actual time=2.431..2.431 rows=2,379 loops=1)

  • Buffers: shared hit=85
102. 1.539 1.539 ↑ 1.0 2,379 1

Seq Scan on pg_type t_1 (cost=0..193.79 rows=2,379 width=795) (actual time=0.011..1.539 rows=2,379 loops=1)

  • Buffers: shared hit=85
103. 0.501 1.969 ↑ 1.0 2,379 1

Hash (cost=239.81..239.81 rows=2,379 width=74) (actual time=1.969..1.969 rows=2,379 loops=1)

  • Buffers: shared hit=89
104. 0.642 1.468 ↑ 1.0 2,379 1

Hash Join (cost=13.31..239.81 rows=2,379 width=74) (actual time=0.134..1.468 rows=2,379 loops=1)

  • Buffers: shared hit=89
105. 0.708 0.708 ↑ 1.0 2,379 1

Seq Scan on pg_type bt (cost=0..193.79 rows=2,379 width=14) (actual time=0.008..0.708 rows=2,379 loops=1)

  • Buffers: shared hit=85
106. 0.064 0.118 ↓ 1.0 237 1

Hash (cost=10.36..10.36 rows=236 width=68) (actual time=0.118..0.118 rows=237 loops=1)

  • Buffers: shared hit=4
107. 0.054 0.054 ↓ 1.0 237 1

Seq Scan on pg_namespace nbt (cost=0..10.36 rows=236 width=68) (actual time=0.009..0.054 rows=237 loops=1)

  • Buffers: shared hit=4
108. 0.050 0.084 ↓ 1.0 237 1

Hash (cost=10.36..10.36 rows=236 width=68) (actual time=0.084..0.084 rows=237 loops=1)

  • Buffers: shared hit=4
109. 0.034 0.034 ↓ 1.0 237 1

Seq Scan on pg_namespace nt_1 (cost=0..10.36 rows=236 width=68) (actual time=0.008..0.034 rows=237 loops=1)

  • Buffers: shared hit=4
110. 0.000 11.617 ↓ 0.0 0 11,617

Nested Loop (cost=0.43..1.68 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=11,617)

  • Buffers: shared hit=23234
111. 11.617 11.617 ↓ 0.0 0 11,617

Index Scan using pg_type_oid_index on pg_type t (cost=0.28..1.5 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=11,617)

  • Index Cond: (c_4.reloftype = t.oid)
  • Buffers: shared hit=23234
112. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (nt.oid = t.typnamespace)
113. 0.000 0.077 ↑ 1.5 2 1

Hash (cost=13.95..13.95 rows=3 width=4) (actual time=0.077..0.077 rows=2 loops=1)

  • Buffers: shared hit=5
114. 0.029 0.077 ↑ 1.5 2 1

Hash Join (cost=2.07..13.95 rows=3 width=4) (actual time=0.034..0.077 rows=2 loops=1)

  • Buffers: shared hit=5
115. 0.035 0.035 ↓ 1.0 237 1

Seq Scan on pg_namespace nco (cost=0..10.36 rows=236 width=68) (actual time=0.011..0.035 rows=237 loops=1)

  • Buffers: shared hit=4
116. 0.002 0.013 ↑ 1.0 3 1

Hash (cost=2.03..2.03 rows=3 width=72) (actual time=0.013..0.013 rows=3 loops=1)

  • Buffers: shared hit=1
117. 0.011 0.011 ↑ 1.0 3 1

Seq Scan on pg_collation co (cost=0..2.03 rows=3 width=72) (actual time=0.009..0.011 rows=3 loops=1)

  • Buffers: shared hit=1
Planning time : 22.029 ms
Execution time : 3,703.729 ms